Forum Discussion
Relative Date (last 7 days) Donut Count
I am trying to get my donut to show the number of events of each type in the last 7 days. I can't change the filters on this visual, it doesn't allow me to change.
Ashish_Mathur
Super User
Super User
Afraid this doesn't work, as it is live data that is updated weekly and the way the information has been sorted is too time consuming. It also not producing the right data. I need to be able to take the data in the format I sent, add a slice that creates data count for the last 60 days (I will then create a last 7 days and last 30 days), but would prefer to not have individual slices per column which is what I have, I would like a pie chart.
- Ashish_Mathur
If you want a single date slicer, you will have to transform data in the format that i have suggested. Also, i have automated the transformation process using the Query Editor - that has not been done manually.