Trend chart and Simple char, all in one

Question

How can I add a trend line to a monthly distribution chart? I attach the chart below, to which I would like to add an NPS trend line.The idea is to mix the first graph with the second one, which I will add below How can I do it? Is this possible? Thanks!

NiC · Accepted Answer

hi Alea Yes it is very much possibleHere i assume your Data Series is the recorded date / end date / start date Now if you have the NPS data as X - Axis data, then we won't be able to do this with this in X-axis then we don't have option to add any more metrics.So if you have something other than  Metrics in data series remove it. and have Date in X-AxisWe need to have multiple metrics 1 for detractor , 1 for promoters, 1 for passive (For these 3 Top/bottom box metrics would be ideal)  and 1 for NPS score.After adding all these your metrics your simple chart should look something like this(i didn't have an NPS question)Now scroll down on the same settings column of this widget and you should see the section named  Legend Values . Below this section you will see all the metrics added above listed here, so you can go ahead and click on the NPS metric it where in you will be greeted by a window as seen belowYou should ideally select the secondary axis for NPS value as it is measured on a different scale as compared to other values and also mark it as a line. This will give you something like this

Alea · Answer

Thank you very very much!!!! :) It worked!

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded