Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Modelling for multiple reports on a single page.

Hello Community, I am creating a Project Status - Weekly Dashboard for executives to get a high level overview of the project status as the first screenshot. There is an Excel Spreadsheet that I ha...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    You can achieve the same result with a dashboard. 

    Create a report with ONE visual and the filter. 
    Then 

    1. Filter by area 1
    2. the visual will be updated

    3. Pin the visual to a dashboard

    4. Repeat steps 1-3 for all 12 areas

     

    Now you will have one dashboard with all of your visuals. As dashboard keeps the filters, all those visuals will be prefiltered with your values. Now rename them (as they will be named the same) and place them in your preferred order.


    You can actually name them correctly using Conditional Formatting in visual name and avoid the last step.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

All fact tables looks like the same. Aren't them 12 EXACTLY identical tables (in terms of structure)? Then UNION them and add a key column that divide them by zone.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    AnonymousHi, you are absolutely right. Thanks for the advice. I'll do that today and let you know how I go. On the other note, is there anything I could do w.r.t the 12 + 12 (so many) tabs in the spreadsheet! I was wondering if I could make my end users's life easier by amalgamating so many tabs with same columns but different data coming in from various zones.

     

    Thanks in advance.

    Anonymous wrote:

    All fact tables looks like the same. Aren't them 12 EXACTLY identical tables (in terms of structure)? Then UNION them and add a key column that divide them by zone.

    Kind regards,

    Bhoga

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Do they actually need to see ALL of those 12 graphs all the time, together? Can't they have 1 graph and a filter to show the zone? As they're all showing the same data for the same period, can't you have a Last Period over Zone graph? So they can go in detail in a zone or see all the zones compared across the same perido.
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks for your reply and nice to hear from you again Anonymous.

        Absolutely, the CEO and Board of Directors actually need to see ALL of those 12 graphs all the time, together on a single A3 Page. They can't have 1 graph and a filter to show the zone because they don't have time for that and need complete visibility in a single snapshot!

        The requirement was so abrupt that the CEO just wants his PA to print an A3 copy for him to take into his meetings.

        Thanks for your great ideas, will keep them handy for future use.

        Kind regards,

        Bhoga