Forum Discussion
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??
Hi Anonymous,
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
4 Replies
Hi Anonymous,
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 GuHi Anonymous,
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.
Regards,
Yuliana GuHi Anonymous,
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