cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ichebobo Member
Member

Display data after every 30 mins

 

 Please help

This data below is in every 5mins. Please I want the data to display every 30mins. Please What column or measure or expression to achieve this??

 

 time.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Display data after every 30 mins

Hi @ichebobo,

 

As a workaround, rather than creating a calculated table where date/time displays every 30 minutes, please add two calculated columns in original table 'A2011_ConfigData'.

Minute diff =
IF (
    MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ) < 30,
    30 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ),
    60 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) )
)

every 30 minutes =
SWITCH (
    A2011_ConfigData[Minute diff],
    5, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 5, 0 ),
    10, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 10, 0 ),
    15, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 15, 0 ),
    20, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 20, 0 ),
    25, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 25, 0 ),
    30, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 0, 0 )
)

 

Add 'A2011_ConfigData'[DataValueDelta] and 'A2011_ConfigData'[every 30 minutes] to your line chart.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

Re: Display data after every 30 mins

Hi @ichebobo,

 

Not sure what is your desired output. If you want the data to display every 30mins, how to deal with those records within 30 minutes? Also, how to deal with other columns in the same table?

 

If you want the time flow to be displayed every 30mins via removing extra records, you could new a calculated table with this formula:

filter time table = FILTER('TimeTable', MOD(MINUTE('TimeTable'[Time Flow]),30)=0)

 

For further analysis, please provide more information to better illustrate your scenario.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Display data after every 30 mins

Hi @ichebobo,

 

What do you mean the calculated table does not responding to other charts, it doesnt respond appropriately like the original 5minutes chart data do? Do you mean the chart based on the calculated table doesn't show data conditionally according to the selection from slicer?

 

Based on my test, it did respond to the slicer selection, you coule see the difference from below screenshot. You can set the value range on Y-axis to a smaller value so that you can see the difference more clearly.

1.PNG

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ichebobo Member
Member

Solved

 Solved

 

 

 

Community Support Team
Community Support Team

Re: Display data after every 30 mins

Hi @ichebobo,

 

As a workaround, rather than creating a calculated table where date/time displays every 30 minutes, please add two calculated columns in original table 'A2011_ConfigData'.

Minute diff =
IF (
    MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ) < 30,
    30 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ),
    60 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) )
)

every 30 minutes =
SWITCH (
    A2011_ConfigData[Minute diff],
    5, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 5, 0 ),
    10, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 10, 0 ),
    15, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 15, 0 ),
    20, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 20, 0 ),
    25, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 25, 0 ),
    30, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 0, 0 )
)

 

Add 'A2011_ConfigData'[DataValueDelta] and 'A2011_ConfigData'[every 30 minutes] to your line chart.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.