Forum Discussion
Display records by the hour
I am accessing a database with instruments logs at 30 sec interval. I need to create a visual that display chart not every 30 sec but instead every hour only. The values doesn't need to be calculat...
Hi Anonymous ,
You could still use this method, just apply visual/page filters where:
time[minutes] = 1 and time[seconds] = 27.
Pete
so there being 120 values per hour, you could add an index column beginning at one, and then a custom column like
Table.SelectRows(PriorStepName, each Number.Mod([Index], 120) =0)
Actually, this is easier:
= Table.Split(TableName, 120){0}[Timestamp]
--Nate