Make a line chart ignore date filters?

[alespooletto]

I have filters on a sheet that automatically retrieve the latest date from the available ones. However, I would like for a line chart to not be filtered by this, as it will only give 1 dot in the graph. 

How can I avoid this and make sure the line chart has all the dates available? 

[Parthiban]

Hi,

Just exclude that date field in your expression.

[alespooletto]

Hi, 

Thank you. I'm sorry I omitted the expression above, you can find it here:

Count( {< Flag= {'LABOR_OFF'}, MainSFC = {'Main SFC'}>} distinct SFC) / Count(distinct WorkDay)

Could you help me figure out what should I change to make it work as intended?

[Parthiban · Accepted solution]

Hi,

Try this one..

Count( {< Flag= {'LABOR_OFF'}, MainSFC = {'Main SFC'},Date=>} distinct SFC) / Count(distinct{<Date=>} WorkDay)

[alespooletto]

Thank you! This works perfectly 😀