Line Chart

[#1]

Hi everyone,

I have produced a line chart that measures pupil performance over time- however, for one pupil (Minnie) it doesn't pick up one date. It works for all other pupils, and is shown on other charts and tables, however this one for some reason it doesn't. I have attached a sample file, please have a look.

Thank you,

Anna

[alexandros17 · Accepted solution]

The expression work with the condition:

({<[Overall Score]={'G'}>} [Problem Reference])

While Minnie has Overall Score = 'R' that's why

Hope it helps

[Anonymous]

You have this set analysis in your expressions {<[Overall Score]={'G'}>} . Minnie's Overall Score for that date are all "R", so calculation gives 0.

[#4]

Thank you!

[#5]

Thank you!

[alexandros17]

Hi Anna

coud you please mark the answer if it has been useful?

Thankyou

Alex