I create a new measure named hourly count and when I try create a measure to aggregate it, the measure does not appear in the predictive text. When the measure is typed in manually it gives me an error.
Also I'm not sure if what you provided is what I am trying to go for.
What I actually want is a moving average and moving median.
To further explain our data, I only want to be working with WORK_ITEM_ID and CREATE_DATE at the moment.
I have extracted the hours of the day from CREATE_DATTE.
I have then plotted the hours of the day against distinct count of WORK_ITEM_ID.
This has given me the total amount of WORK_ITEM_ID received per hour.
Bevcause our data goes back about a year, for example, between 10am and 11am it will show 10 000 instructions (all instructions received since the beginning of time of our data set between 10am and 11am).
I'd like to see the average amount of instructions received between 10am and 11am.
And then how that average changes from 11am to 12pm, 12pm - 1pm etc.
So I would like to calculate how the average moves through out the day