Help with Line Chart

[#1]

Hi,

Can someone please explain how I acheive the following...

I have a two dimensional line chart{month offset, start month). I'm trying to track customer churn rate by month, so how long a customer stays before cancelling. All start months, start with a 0 month offset and each subsequent month I add one to the offset. Please see attached image.

I'd like to change the structure of the chart so I calculate the accumulated percentage drop each month for each start month rather than show the number. Ie, month_offset 0 = 0%, month_offset 1 = 5%, month_offset 2 = 8%, month_offset 3 =12%, etc.

Can anybody offer some advice?

Many thanks.

Warren

[MK_QSL]

Can you provide some sample data please?

[SergeyMak]

there is no image.

could you attache an application?

[#4]

Thanks for your replies. I have attached application - thanks.

[#5]

Have attached - Thanks Sergey.

[SergeyMak]

Hi Warren,

You can use expression like below as values on data point

Count(DISTINCT {<status={0}>} cust_no)/Count(DISTINCT TOTAL  <start_date> {<status={0}>} cust_no)

PFA

P.S.: I rewrote your expression using set analysis

[#7]

Many thanks Sergey. Much appreciated.

[SergeyMak]

Hi Warren,

If you have a correct answer please select one to close the discussion.

Regards,

Sergey

[#9]

Hi Sergey,

I've marked yours as helpful and set the question to assumed answered.

Do I need to do something more than that?

Sorry for the confusion.

Warren

[SergeyMak]

No worries, Worren.

As I know there is another button to select a correct answer. Unfortunately, I've never started the discussion and I don't know the interface. But you can see that some discussions are green - it means that the question is answered.

So it helps further users to find a solution if they have the same problem.

Regards,

Sergey