Cumulative NPS line chart in Qualtrics CX dashboard | XM Community
Skip to main content

Hi everyone,

I wanted to ask if it’s possible to configure a line chart in a Qualtrics CX dashboard to show a cumulative NPS for the current year only.

Here’s the situation: I know there’s a continuous metric option in Qualtrics, but the problem is that it always calculates the previous 12 months rolling, regardless of the filters I apply. For example, if I set a filter for “this year only,” the metric in January still shows data from February of the previous year up to January of the current year.

What I need is a chart where:

  • In January, the NPS is calculated only with responses from January of this year.

  • In February, the NPS is recalculated as the cumulative of January + February responses.

  • In March, the cumulative is Jan–Mar, and so on, until December.

Basically, I want a year-to-date cumulative NPS trend line, but restricted to the current year (no data leaking in from the previous year).

Is this possible to achieve within the Qualtrics dashboard settings, or would it require a custom metric/other workaround?

Thanks in advance!

You can try adding advanced filter on widget from Jan 1 till today, so it will update on real time to current date.

 

 


You can try adding advanced filter on widget from Jan 1 till today, so it will update on real time to current date.

 

 

I tried adding this and also a filter to the metric itself but keeps showing me data from the past 😔


It should not be the case, you have to lock the filter. So that it doesnot interact with the page filter.


It should not be the case, you have to lock the filter. So that it doesnot interact with the page filter.

I am not sure why this is happening but i dont have any page filters and i have filters on the metric and the widget with no luck 

January shouldt have responses for this year for example.


I would suggest not to add filter on metric, just add a advanced filter on the widget and lock it.


Leave a Reply