Multiple scores in a single widget

[jasonedwards]

Hi Community

We have an indicator with daily scores. Is it possible to display the result for the latest / current month, the result for the previous month and the result for the latest / current month from 12 months earlier. Something like below. I can do this in Power BI by creating different measures.

Indicator	Result for Current Month e.g. March 2024	Result for Previous month e.g. Feb 2024	Result for current month 12 months ago e.g. March 2023
Indicator A	200	190	210

We currently have 2 separate score widgets using month sum + for current month and comparing to 1 period back and month sum + for current month comparing to 12 periods back. This means we have to display the current score in each of the widgets which my clients would like to avoid.

Hoping you can help.

Thanks

[Its_Azar]

Hey there @jasonedwards 

Guess this is possible so create three breakdown sources, one for the current month, one for the previous month, and one for the current month 12 months ago.

Configure the breakdown source for each period , filtering the data to only include scores for the relevant months.

Create three separate Breakdown Widgets, each referencing one of the breakdown sources.

Arrange the widgets on the dashboard to display the results for the current month, previous month, and the month 12 months ago side by side.

This way, you'll have a dashboard that displays the indicator results for the desired periods without duplicating the current score. Each widget will show the result for the specific period you've configured. Hope this helps

If this helps kindly accept the response thanks much.

Regards

Azar

[Manohararuna]

Hello Azar,

       can you please send me the practical solution with screen shot. That will more help me to understand ahd following your above solution.

Regards,

Manohararuna.