3 Replies Latest reply on Feb 5, 2019 7:46 AM by Shinichiro Murakami

# Connecting missing points in Multi-line Graph and discrete axis

While working with a graph containing multiple lines, a discrete X-axis and some lines with missing data points, I've typically had to change the axis to continuous when I wanted all the points have connecting lines (even the missing points).  However, I accidentally discovered a technique which allows the points to connect even when the axis is discrete, but I don't really understand why it works. I search for similar situations, but they all seem to "add" missing points, rather than connecting the points.

I've created a simple workbook with arbitrary data.

• The DiscreteX sheet shows the problem - with missing connections.
• The ContinuousX sheet shows the typical solution, but I really don't want a continuous axis based on the value (small value compress to the left).
• The MissingValueFilter sheet shows a working solution, which uses a filter of an aggregate value based on a test for a missing value: calculation = ATTR(NOT ISNULL([Value])

Thus, I'm turning DiscreteX graph into MissingValueFilter graph

===>>>>

Can someone explain why the Aggregate Filter works (connects without leaving gaps)?  Is there a better way to accomplish the same thing without changing the x-axis?  The calculated field doesn't show when I view data source data, or view data within the graph, and I can't seem to get my brain around it.

• ###### 1. Re: Connecting missing points in Multi-line Graph and discrete axis

I know navigation is very difficult, but I think you can follow the screen shots.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Connecting missing points in Multi-line Graph and discrete axis

Shin,

Excellent - very clear.  I had no idea there were more format option if you picked the fields!  Maybe that will help with other frustrations.  Thanks for the quick and detailed answer.

Kris