Multiple scores in a single widget

jasonedwards
Tera Contributor

‎03-06-2024 10:08 AM

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.

 

IndicatorResult for Current Month e.g. March 2024Result for Previous month e.g. Feb 2024

Result for current month 12 months ago

e.g. March 2023

Indicator A200190210

 

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