Custom Date Range in Dashboard Widgets

Custom Date Range in Dashboard Widgets

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.


Here is my use case scenario: I have a social media dashboard showing key performance indictors. I log in on Monday and access my "weekly quick view" dashboard to see how my company is doing this week compared to last week. A line chart, bar chart, and pivot table all accurately show data for the last seven days. However, the widget only allows me to group data by week, which means I am viewing this week (which is only one day) in relation to all of last week. So with this limited functionality, the dashboard is only accurate on Saturdays because it is set as the last day of the week. 

 

-----

I see this same issue with all of the premade social media dashboards in Zoho Analytics. For instance, when I synced my facebook data, I got a premade dashboard called "Page Insights (Dashboard) (Facebook Pages)".

 

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?




      • Sticky Posts

      • Announcing Zoho Analytics 6.0 Beta!

        We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team

      • What's New in Zoho Analytics - August 2024

        Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data

      • We are coming to your city! Zoho Analytics Community Meetup

        Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

      • Zoho Analytics: 2021 Look Back

        As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021

      • [Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022

        Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution.  Hear more from Claudio Cabeza, Director at PREMO