Multi line chart

[smilingjohn]

Hi All,

my below range sum expression is giving all zero for line chart , and this is working perfectly in pivot table . Can please expertise suggest on this .

Expression :
rangeSum(Before(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,ColumnNo(TOTAL)))

Can please someone help me on this .

Thanks in advance 

[smilingjohn]

Any help expertise ???

[smilingjohn]

Any help on this 

[Anil_Babu_Samineni]

May be try this for straight?

rangeSum(Above(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,RowNo(TOTAL)))

[smilingjohn]

Hi Anil

Thanks for th reply 

How do I convert the below expression to straight . Can you please help me.on this 

RangeSum(
RangeSum(Before(TOTAL Count({<Year *= {">2015"}, Status = {'OpenTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, ColumnNo(TOTAL))),

-Before(TOTAL RangeSum(Before(TOTAL Count({<Year *= {">2015"}, Status = {'ClosedTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, ColumnNo(TOTAL))))
)

[Anil_Babu_Samineni]

May be this

RangeSum(
RangeSum(Above(TOTAL Count({<Year *= {">2015"}, Status = {'OpenTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, RowNo(TOTAL))),

-Above(TOTAL RangeSum(Above(TOTAL Count({<Year *= {">2015"}, Status = {'ClosedTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, RowNo(TOTAL))))

[Brett_Bleess]

John, did Anil's last post do the trick for things?  Do not forget to use the Accept as Solution button on that post if it did to give him credit for the assist and let other Community Members know that worked for the use case.  If you are still working on things, leave an update.

Regards,
Brett