Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for
Did you mean:
Contributor

## Create a graph on evolution

Dear community,

I would like to create a dashboard on evolution but I have some problems regarding the formula

Regarding the following picture, I would like to create a graph with a curve of the evolution of my contracts

In January I have 50 new contracts and 30 cancellations. 50 new contracts - 30 cancellations = +20

In february I have 60 contracts - 30 cancellations = +30 (I would like to add also the +20 of january which means +50)

In march I have 50 contracts - 70 cancellations = -20 (Then I would like 50 - 20 = +30).

I tried the following dimensions :

=Dual(Year([date_signup])&'-'&Month([date_signup]),MonthStart([date_signup]))

I tried the following measures :

RangeSum(Above((Count({<[signup_plan_type]= {'plantype-standard'}>} [date_signup])),0, RowNo()))
-
RangeSum(Above((Count({<[signup_plan_type]= {'plantype-standard'}>} [date_cancelled])),0, RowNo()))

My graph is continually increasing. Therefore, there is a problem since I know there are months when there were more cancellations than new contracts

Thank you in advance for you help

Regards,

3 Replies
MVP

Hi,

Try like below

RangeSum(Above((Count({<[signup_plan_type]= {'plantype-standard'}>} [date_signup]) - Count({<[signup_plan_type]= {'plantype-standard'}>} [date_cancelled])),0, RowNo()))

Thanks & Regards, Mayil Vahanan R
Contributor
Author

Hi Mayilvahanan,

I still have the same graph and the same problem with the formula you advised me.

Contributor
Author

Does anyone have any idea regarding ​​the formula?

Regards,