Elegant solution for Missing Values in numeric dimensions?

[cjlaumans]

Hi all,

I know there’s a few solutions for this, but they feel clunky and am wondering if I’m missing a more elegant solution to this problem.

I have a dimension, called NPS, which is of type: number, and has a known range: [0, 10]. I want to, for example, create a bar chart with count per dimension value, and I want to show the full range of values. However, in some cases there may not be any records for a certain dimension value, hence no row is shown, and the bar chart ends up omitting the value.

I know this can be solved with “fill in missing values”, however this requires changing the dimension to type: tier or case, which also has it’s disadvantages:

• Missing values can only be filled if 1 dimension is used, so not possible with more complex datasets
• The dimension values are strings, making subsequent manipulation of them (such as performing a table calculation on the values) more complex

Ideally, I’d like to be able to specify the possible values without needing to change the data type.

But if that’s not possible, I’m wondering what other solutions there may be, using whatever other functionality Looker has to offer.

Thanks!