Unanswered

Can a line chart join gaps in data

Like (0) Share

Report

Posted on 14 Jan 2024 09:18:12 by mrwilliams

I have am charting data from a collection for three subjects representing tests which are taken either in the Autumn term, or the summer term. One of the subjects only tests during the autumn term so that subject has no data for the summer term.

When charting the relationship between the test scores, it considers a missing entry as 0, and therefore does this to the chart. Is there a way of getting the chart to join the data points?

Categories:

General Questions

All responses (2)

Answers (0)

mrwilliams 50 on 19 Jan 2024 at 16:50:21

Like (0)

Report

Re: Can a line chart join gaps in data

Thanks for the reply @RogierE - I will have a go this weekend.
RogierE 862 Super User 2025 Season 1 on 14 Jan 2024 at 19:55:27

Like (0)

Report
Re: Can a line chart join gaps in data

You could either calculate and add the intermediate values to your table or add a separate chart for the Ability figures. I would go for the last, as it could be confusing to the user that there is a label for a value that is not in your table.
So if you copy your chart, get rid of the title and legend of this copy, and set the grid style to "None", you would get something like this:

Of course for this to work you would need to:
filter out the empty values in your second chart, so I added this to the Items property:
Filter('New tables',!IsBlank(Ability))
get rid of the data in your first chart, so to the items of that chart I added this:
DropColumns('New tables',"cr594_ability")
connect the MaxY, MinY, X, Y, Height, Width etc of the copy Graph to the original Graph so that they stay aligned.
Please like the reply and/or accept it as the solution if the answer is what you were looking for.