When creating a widget, I can "group by" week, month, year, etc., but I can't figure out how to group by "the last X days". This can be done with a chart and pivot table. I can even set the timeline filter with a customer date range.
The timeline filter allows the user to select the past 3 months. Every one of the charts are correct, but the widgets at the top are set to "full date" so they show today compared to yesterday. If I change the "group by" option to month, then the widget shows me the this month (13 days) in relation to all last month. There is way to view the last 3 months in relation to the 3 months prior. There is no way to compare data in the widgets based on the timeline filter. If I select to view the last two months, the widget is only going to compare today in relation to yesterday. Users are then confused and blame the analyst for showing false/misleading data.
This issue is prevalent in every one of the premade dashboards in zoho analytics.
What am I missing?