How to hide non existing record in a Line with dates in X axis

[jmartiinsa]

Hello,

I have created a spline data visualization with a filter on dates. But it shows values even if there is no record on some days of the last 7 days. It will be all weekends. I can't find anywhere how to hide these values displayed with "0". Somebody can help me ? 😞

[AndersBGS]

Hi @jmartiinsa 

this is configured on the automated indicator/formula indicator.

[jmartiinsa]

Thx for your quick reply. Nevertheless I still don't understand how to configure what you mean on my dashboard. I'm not an expert, especially on PA 😞

Because the issue is not on the filter of record as those related to weekend dates are not existing, it's just to not display these days in my dashboard. 

[AndersBGS]

Hi @jmartiinsa ,

On the automated indicator - value when nill:

[jmartiinsa]

Hi @AndersBGS 

I'm sorry but I don't understand how to fix it. I have not created any Automated or formula indicator, it's really a basic data visualization. If I'm filtering on last year it's just horrible ...