Forum Discussion
Data Modelling for multiple reports on a single page.
You can achieve the same result with a dashboard.
Create a report with ONE visual and the filter.
Then1. Filter by area 1
2. the visual will be updated3. 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.
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
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.
Thank you so much for your time Anonymous.
Kind regards,
Bhoga