Replace Null to 0 if no records found in Visualisation

[bandodkarD]

We have this visualisation created.
We want the CSV download to show the value as 0 not "null" for filters with no records.
Is this possible ?

[bandodkarD]

hi, Any suggestions?

[Marco_Liberati]

Hi @bandodkarD

what is the configuration for the pie chart?
Can you share a screenshot of the Lens configuration of it? Are you using Count operation?

[bandodkarD]

Not Count. Filters operation.

[Marco_Liberati]

I meant the dimension defined as Metric.
Some operations, like Count, provide some control over null coercion to 0 via an advanced flag:

[bandodkarD]

Yes its count.

[bandodkarD]

Do we need to disable that radio button?

[Marco_Liberati]

Yes, disabling it will cast null values into 0.

With option enabled:

With option disabled:

[bandodkarD]

great!! Thanks