Forum Discussion
Dynamic calculation time slider
Hello everybody, I'm trying to dynamically manipulate a value according to the time frame chosen on a time slicer (slider, not dropdown or selection). I have values per Month like this: ...
Approach your issue step by step
- get the distinct values of the dates inside your slider selection (min to max)
- group the values by month
- for each month add the count of days from the dates table
- add the count of days from the slider/slicer for each group
- profit!