Skip to main content

Good afternoon everyone,

 

I’m writing to see if anyone has any tips for the following:

 

I’ve made a line report to show our NPS over time for several different surveys represented as different lines. In some quarters, we’ve had no responses for certain surveys which shows the NPS there as a 0.

 

Is there a way to get the line to follow from the last quarter that has data to the next quarter that has data, rather than dipping down to 0 in the middle where there’s no data? 

 

Equally, if the survey hadn’t been sent out yet the NPS shows as a 0 until it’s first sent out, is there a way to start the line only when the survey is first sent out and stop the line when the most recent response is received?

 

I know using a bar chart fixes this in a way, as the bar is then just absent where there’s no data, but we would like to use a line report as this is showing a view over time.

 

Any help would be greatly appreciated.

 

Thank you! 

Grace

You can set the chart options to TRUE for Show Missing Data Points. This’ll fill in a dotted line where there is missing data, and it goes from one data point to the next.

 

In your report filters, filter for quarters where the sum of responses is greater than 0. You’ll end up with a dotted line instead of zeros.

 

 

Thank you very much for your response @jason_metzler - we’ve put the show missing data points option on, but it’s not added the dotted line (screenshot below with yellow where the dotted line should be). We can’t filter by greater than 0 as the value of the some of the data points, (see the red line) do have responses where the value equals 0.

 

Reply


Terms & ConditionsCookie settings