cancel
Showing results for 
Search instead for 
Did you mean: 

Chart to show trendlines comparing year over year data

former_member406941
Participant
0 Kudos

Hello again!

My first inquiry was answered so quickly and accurately I thought I'd try again!!

I have a chart where I want to show two trendlines that compare year-over-year data. 

The chart has 'On the change of' @Month (where the formula for MONTH is....DatePart ("m",{PTS_1_18_13_10_09.Entry Date/Time})  to 'Show Values' for 2 running totals: #2013 and #2014.  So far so good.  The issue is that for the months where there is yet to be data (Nov 2014 and Dec 2014), the 2014 trendline drops down to 0, like this:

          |  /\

          | /  \/\             

2014  |/       \/\          /\     

          |  /\        \    /\/   \

2013  |/   \     /\ \ /        \  

          |      \  /   \/\

          |____\/____ \_______________  (Monthly points graphed)

          Sept  Oct   Nov    Dec



Hopefully this is understandable .

How can I just have the 2014 trendline discontinue where the data stops (Oct 2014) instead of it dropping down to 0?

Ideally it would like this:

          |  /\

          | /  \/\             

2014  |/       \/\          /\     

          |  /\             /\/   \

2013  |/   \     /\   /        \  

          |      \  /   \/

          |____\/____ _______________  (Monthly points graphed)

          Sept  Oct   Nov    Dec

Thanks so much!



Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Rich,

Right-click the chart > Chart Options > Check 'Break lines for missing data'.

-Abhilash

former_member406941
Participant
0 Kudos

Thank you Abhilash,

I tried this and it doesn't seem to work, I still show the trendine going down to 0.

Thanks!

abhilash_kumar
Active Contributor
0 Kudos

Try unchecking the two NULL options under File > Report Options (The first two options).

-Abhilash

former_member406941
Participant
0 Kudos

Thank you...I've tried checking and unchecking both of those options under File > Report Options, the trendine still goes down to 0.  Any other thoughts or suggestion??  Thanks SO much.