Adding Historical benchmarks ro dashboard | XM Community
Skip to main content

Adding Historical benchmarks ro dashboard

  • February 20, 2023
  • 2 replies
  • 35 views
MsIreen
Level 5 ●●●●●
Forum|alt.badge.img+23

Hi all,
I have a question about adding a historical benchmark for data.
Situation: I have a set of historical benchmarks for different Countries. I would like to show this in the format of bar chart to show last year result for this country and then this year result for the same country, then next country same way and so on, for example green: last year, blue: this year.
image.pngCan I do this using benchmarks editor? Or can I do that any other way than loading the historical data set to the system.

TusharDalwani

2 replies

InessaG
Level 5 ●●●●●
Forum|alt.badge.img+19
  • InessaG
  • Level 5 ●●●●●
  • February 20, 2023

I ended up loading it into the data set and then using the Avg calculation in custom metrics to calculate delta to benchmarks for that time period. If there is a better way, open to suggestions as well.

MsIreen
Level 5 ●●●●●
Forum|alt.badge.img+23
  • MsIreen
  • Author
  • Level 5 ●●●●●
  • February 21, 2023

I really hope there is a way, we had a complicated way to do the global division last time, and if i have to upload raw data, it will be very difficult to do the calculations...

Terms & ConditionsAccessibility statement