topic Re: Make a line chart ignore date filters? in App Development

Make a line chart ignore date filters?

alespooletto — Wed, 03 Jan 2024 08:13:46 GMT

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?

Re: Make a line chart ignore date filters?

Parthiban — Wed, 03 Jan 2024 09:25:32 GMT

Hi,

Just exclude that date field in your expression.

Re: Make a line chart ignore date filters?

alespooletto — Wed, 03 Jan 2024 09:27:53 GMT

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?

Re: Make a line chart ignore date filters?

Parthiban — Wed, 03 Jan 2024 09:30:13 GMT

Hi,

Try this one..

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

Re: Make a line chart ignore date filters?

alespooletto — Wed, 03 Jan 2024 09:40:09 GMT

Thank you! This works perfectly 😀