KPI Widget with dynamic Group By
I've created my KPI comparison widget with a Group By "Month" but I want to know if I can dynamically group it based on the date range?
For example, my KPI widget compares the current month vs previous month (primary value, secondary value and the difference) but sometimes my dashboard users would change the date range to today vs yesterday. This is a problem because it means my KPI widget is broken due to it still being grouped by "Month".
So, I would like to dynamically group it based on the date range. If the user selects current month vs previous month, then group it by "Month". If the user selects today vs yesterday, then group by "Full Date". The same with weeks etc.
Is that possible?