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.
The definition of the dimensions and the measure should be like
this:dimension: dim_1{ type: number}dimension: dim_2{ type: number}
measure:measure_count_lvl3 { type: sum sql: CASE WHEN
${column}='GEO_AREA_ID' THEN ${dim_1} ELSE ${dim_2} END ;; }You ...
Hey Miguel! The issue is coming as you are using a type number. Type
number usually should be used to do a calculation. In your case I
suggest you to change the measures used in the CASE when statement with
the dimensions that you’ve used in those me...
May be a little late, but still:The correct format that you should use
is: [>=1000000000]$0.0,,," B";[>=1000000]$0.0,," M";[>=100000]$0.0,"
K";$0You should add more comas in order to specify the millions and
billions.Regards