Dimension fill and value fill are slightly different.
Dimension fill will supply missing rows or columns for a dimension, such as a date series or an enumerated list like yes/no or entries in a case statement. It ensures that each value shows up whether or not there are corresponding rows in the database. This toggle is available on each dimension in the data table that can be filled (dates with endpoints or enumerated lists).
- For example, maybe you want to plot the count of inventory items created per day in a given time period, but there are some days when no inventory was created. You can use dimension fill on the
created_datefield to fill in those missing dates:
Value fill is used to fill in null values in a pivoted table. This is most useful to build calculations on top of a pivoted data set that may be sparse. Null values will be returned as zero, and thus calculations like moving averages or moving sums will work over even columns or rows with missing data. This toggle is available in the measures on a table.