Exclude Null Values Dimension and measure

[Avin]

How toexclude Null Values inDimension and measure

[Eric_Lyons]

Hi @Avin,

Would you like to exclude them from the visualization or the entire data set? You can apply a filter to remove null values in an explore, on a dashboard, or even in a derived table/view. Alternatively, you can try wrapping the sql parameter for those fields in a coalesce function. COALESCE(${field},0)

If you want to hide them just from the visualization, some charts in looker have an option for this in the visualization settings,  you can navigate here in the explore by clicking the gear icon on the top right of the visualization. Alternatively, you can use an if statement in a table calculation that returns no if the value is null. Then, hide the no’s from the visualization. 

Thanks,

Eric