I can't seem to figure out how to split a table based on time. I am trying to show one measure but to display it in a table like the following:
Time | Measure
01:00 | 25
02:00 | 80
Can anyone tell me how I can do this? I would be much appreciative.
Thanks again for any help,
Solved! Go to Solution.
If I understand correctly, in the table right click on the measure and select grouping -> records. Then you'll be able to expand the measure and see the data you see in the chart broken down by timeframes.
Also note that the data you see in the table is all based off of the data points you see in the chart not the underlying measures/data itself. For instance if you are charting the max aggregation of a measure - the average column in the table is really the average of the all the max values based on the resolution you've selected (just something that can be confusing at first).