Period Over Period Charts

ggenovese
ggenovese Coach
in Charting Ideas

Period over Period cards are pretty limited; there's no Period Over Period Table and the graphs don't allow for a series. This forces users to have to either solve for it in their ETL's or write complicated beast modes. Often times going this route forces you to have to not allow date filtering on cards which further limits them.

Having more robust period over period card options feels like a better solution to me.

Tagged:
10
Up
10 votes

Submitted and awaiting review from product team · Last Updated

Comments

  • jennih_acc
    jennih_acc Member

    I've been looking for this too! I'd love to have some color coding around positive and negative changes as well.

  • Xan
    Xan Member

    This would be great! An increasing number of my dashboard users are asking for the ability to have the period over period comparison be flexible with the top level date filter of the app/dashboard.

    Adding to what @ggenovese said, the current solution (linked at bottom) of beast modes and additional ETL are not scalable. Providing more options to end users results in duplicate records. Beyond duplication of metrics it duplicates row counts. You can use views to reduce row credit consumption, but this quickly slows down dashboards/apps as cards are slower when powered by views.

    Potential solution could be a conditional drop down in the top level date filter that enables changing comparison periods. If PoP cards are present on dashboard/app, then show "compare to" option. Additionally, dashboard/app editors would have the option to show or hide this conditional drop down.

    Example: PoP cards on an app are default are set to current month-to-date, compare to one month ago. When the user changes the top level date filter to yesterday, all of the PoP charts compare to the same day one month ago (I believe this functionality is already in place). The user could then change the "compare to" filter to "Day over Day" and all the PoP charts will update to compare yesterday to the day before.

    Hope this explanation helps and looking forward to enhanced PoP cards!

    https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

Categories