Dashboarding with custom graph settings across report suites
Hi,
I'm trying to create a dashboard with the following:
- a customized reportlet showing a bubble chart instead of a bar graph,
- show the first 30 items sorted by a calculated metric,
- not show the calculated metric in the graph,
- be able to switch report suites in the dashboard while maintaining the reportlet settings.
I know for a bubble chart Report & Analytics will use the first three metrics selected, 1st for X axis, 2nd for Y axis, and 3rd for Bubble Size. Once I have the chart the way I want to show it, I create the reportlet in one of my report suites and add it to the Dashboard. Here are the problems I'm facing when I switch report suites while viewing the Dashboard:
- The default setting is to always sort by the first metric when changing report suites. So I placed my weighted metric first and chose to not graph it, however when I change suites while in a dashboard the chart will now show it.
- If I move the weighted metric to the 4th column and sort by it, then whenever I switch report suites the dashboard will now sort by the first metric instead of the 4th.
Any ideas of what I can do here to keep the sorting settings when switching suites?