Hide future days in the chart

[duscaranari]

Hi, everyone!

I have this chart that shows me the production volume by day.

I want to hide the future days, showing just the ones from day 1 to today. 

I know I can hide zeros, but it's important to show the past days that the production volume was zero.

Any tip?

Thanks,

Eduardo.

[aruneshgupta · Accepted solution]

I suggest to use conditional dimension.

ex: if(day(today())>Days,Days) 

Regards,

Arunesh

[duscaranari]

Hy Arunesh, I hope you are well.

I first tried to place that expression in the "show dimension if" box, with no luck.

Then I placed it in the "field" box, and it worked.

Thank you so much for your help.

Regards,

Eduardo.

[aruneshgupta]

Great Eduardo!