Hi, Thank you for the response. How would I go about putting this into a bar chart? I created the measure, and added to the height section. I then added 'record number' in the bar section, but it did not work.
Values I need;
Record # to display in the x axis
Duration in the y axis
and the bar height will be the duration for each record, but only for the last 30 days.
And a second bar chart that will display the average duration for the past 30 days grouped by category.