Hi there
I would like to show the trend in the number of occurrences minute-by-minute through the PowerView scatter plot with the corresponding playback axis.
My challenge is that if I add a HH: MM formatted column to my playing axis, the output is bounded on the x-axis to the number of occurrences recorded at any given minute. In my case, this means that the x-axis ranges between 1-2.
Is it possible to accumulate the number of occurrences?
I would like to accumulation calculated per day, minute-by-minute, so 2 or more days can be viewed as an average, if it were desired in a future situation.
In my data table, I have the following relevant columns:
- ID (unique identifier for the line)
- Started (DD-MM-YYYY HH: MM: SS formatted date)
- Type (a text that shows which category the registration belongs)
- Orign (a text showing the sender of registration)
I hope that one of you can figure out my challenge
I would like to show the trend in the number of occurrences minute-by-minute through the PowerView scatter plot with the corresponding playback axis.
My challenge is that if I add a HH: MM formatted column to my playing axis, the output is bounded on the x-axis to the number of occurrences recorded at any given minute. In my case, this means that the x-axis ranges between 1-2.
Is it possible to accumulate the number of occurrences?
I would like to accumulation calculated per day, minute-by-minute, so 2 or more days can be viewed as an average, if it were desired in a future situation.
In my data table, I have the following relevant columns:
- ID (unique identifier for the line)
- Started (DD-MM-YYYY HH: MM: SS formatted date)
- Type (a text that shows which category the registration belongs)
- Orign (a text showing the sender of registration)
I hope that one of you can figure out my challenge
