topic Re: How to remove zero values from YoY line chart in App Development

How to remove zero values from YoY line chart

Anonymous — Thu, 08 Mar 2018 16:10:33 GMT

Hi,

I have a line chart with YoY comparisons like this. Dimensions is month name. Measures are current fiscal year performance and last fiscal year performance.

Current Year:

if(GetSelectedCount(MonthYear)=1, sum({$<MonthYear=,FiscalYear=,FiscalYear={"$(=Max(FiscalYear))"},Date={"=$(=max(Date))"}>}Orders))

Last Year:

if(GetSelectedCount(MonthYear)=1, sum({$<MonthYear=,FiscalYear=,FiscalYear={"$(=Max(FiscalYear)-2)"}>}Orders))

I want to have the red line stops at Feb instead of showing the performance drops to zero since I don't have any data after Feb in 2018. I have tried unchecking "Include zero values" under data handling and unchecking "Include null values" under dimensions. Neither of them worked.

Can anyone help?

Thank you

Re: How to remove zero values from YoY line chart

YoussefBelloum — Thu, 08 Mar 2018 17:12:13 GMT

Hi,

try this on the current year expression:

if(GetSelectedCount(MonthYear)=1, sum({$<MonthYear=,FiscalYear=,FiscalYear={"$(=Max(FiscalYear))"},Date={"=$(=max(Date))"}, Month={"<=2"}>}Orders))

use the numeric month field

Re: How to remove zero values from YoY line chart

Digvijay_Singh — Thu, 08 Mar 2018 18:37:39 GMT

May be this property is making it 0 -

Re: How to remove zero values from YoY line chart

Anonymous — Thu, 08 Mar 2018 21:12:01 GMT

This doesn't work

Re: How to remove zero values from YoY line chart

YoussefBelloum — Fri, 09 Mar 2018 08:59:12 GMT

Just verify that you put the correct Month NUM FIELD and NOT the Month CHAR FIELD on the set analysis.

Can you attach sample app ? or sample data ?