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 scenarioI 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 5.0 -- A Modern Self-service BI & Analytics Platform

      We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data Preparation
    • Ask the Experts #18: Five hours live Q&A session with Zoho Analytics product experts

      Hello all,  We are excited to host the next online community event - Ask the Experts #18 on 24 March 2021 between 05:30 AM - 10:30 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with
    • Free Webinar: 5 Must have inventory reports for online sellers | Zoho Analytics & Zoho Inventory

      Hello All, Selling goods online? These 5 inventory reports will help you make better informed decisions. Join us on this free webinar hosted by Zoho Analytics and Inventory domain experts to learn more. Register now! Friday, December 13th: 9am PST
    • Zoho Reports to be renamed and launched as Zoho Analytics 4.0

      We made the Zoho Reports 4.0 Beta announcement a few months back. As we worked on new features in 4.0, we realized we are moving away from just Reporting, and getting more and more into the Analytics realm. And that's the reason why we have decided to rename Zoho Reports as Zoho Analytics. This post is just to give you a heads up on the Zoho Analytics 4.0 launch in mid November 2018. As present users of Zoho Reports, be assured that the new product will continue to work the same as the current one.
    • Zoho Reports Release 4.0 Beta

      We are delighted to announce the new Zoho Reports Release 4.0 Beta. Your favorite Zoho Reports now comes with a fresh new-look and exciting features. The new Zoho Reports 4.0 includes the following features: Dashboards in Single Click The UI has been completely revamped focusing on easy navigation. Now you can access any dashboard in a single click using the Preview Cards. Easy Navigation The main navigational elements are made bolder and bigger now. The analytics elements are organized into three

          Zoho TeamInbox Resources

            Zoho DataPrep Resources

                Zoho CRM Plus Resources

                  Zoho Books Resources

                    Zoho Subscriptions Resources

                      Zoho Desk Resources

                        Zoho Projects Resources

                          Zoho Sprints Resources

                            Zoho Orchestly Resources

                              Zoho Creator Resources

                                Zoho WorkDrive Resources

                                    Zoho Campaigns Resources

                                      Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now

                                                      Zoho Show Resources

                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.