This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Using pivot for one of the dimensions creates null values in metrics that have coalesce and CASE WHEN IS NULL THEN 0 for the missing data. Is there any way to avoid that (apart of creating dummy data in the source DB table with 0 values)