Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to understand why set analysis drops some rows when chart dimension value is null and measure field exists in different than chart dimension field.
I have attached sample app, very similar to what we have in production app. The main question is, why left chart shows count 2 against null dimension but right one shows 1 against null dimension.
I observed if I replace set analysis expression with IF statement, both chart shows 2 against null dimension value.
Any help will be highly appreciated.
Thanks,
DJ
When I drop 'Key' column from the table, It drops the middle record. Strange, Even 'Key' removal wasn't making duplicate records situations in the table.