I have lets say 1mio records in one month. And I want to display all records in a line diagram. I have a global drilldown filter for several charts on a sheet. The drill down levels are month, week and day.
What I want is to display every single record only when I am at the "day" level. When I am at the "month" and "week" level, I just want to display aggregated values. But when I zoom in, I want to display all vales at every timestamp.
Is that possible?
BR