This content has been marked as final.
Show 6 replies

1. Re: Showing sums of zero on line graphs
Sherzodbek Ibragimov Nov 15, 2016 1:06 PM (in response to Howard Shen) 
2. Re: Showing sums of zero on line graphs
Sherzodbek Ibragimov Nov 15, 2016 1:08 PM (in response to Sherzodbek Ibragimov)1 of 1 people found this helpfulIf, so you need to change few things here. First change your date to Discrete, second right click Sum(Number of Records, then Format), Under Pane, make sure you have followings:

3. Re: Showing sums of zero on line graphs
Michel Caissie Nov 15, 2016 1:25 PM (in response to Sherzodbek Ibragimov)Alternate solution,
Make two calculations returning the number of records for each Letter Grade.
Bring both on the rows and create a dual axis.
Format each axis with Special Values Marks: Show at Default Value.
This way you can keep the continuous date axis
Michel

Book3 ed mc.twbx 27.7 KB


4. Re: Showing sums of zero on line graphs
Howard Shen Nov 15, 2016 1:59 PM (in response to Michel Caissie)Interesting  that would work. In my actual version, I'm already using dual axis for something else, so this won't work for me, but thanks!

5. Re: Showing sums of zero on line graphs
Howard Shen Nov 15, 2016 1:59 PM (in response to Sherzodbek Ibragimov)Perfect  thanks!

6. Re: Showing sums of zero on line graphs
Sherzodbek Ibragimov Nov 15, 2016 2:01 PM (in response to Howard Shen)Howard,
You are welcome. Glad it worked on you.