MarkSnodgrass Coach 
-
Re: Single Value Card - Value is 0
I would put survey type in your filter and filter to 2 and then just have your beast mode do the summing and not the case statement like this: ((sum(Promoter Count) - sum(Detractor Count)) / sum(NPS …1 -
Re: Single Value Card - Value is 0
It's odd that is blank, but the first thing I would try would be go to General - No Data Handling and choose Zero Value and see if that works.1 -
Re: Creating a multi category chart
I believe L1_dist_value should be category and event_date should be category 2 to get that look.3 -
Re: Top N items in tree map
In the Chart Properties - General, you can enter a value in "Maximum Slices Before Other" and that will limit. Make sure you also have your sales metric in the sorting properties and set to…1 -
Re: Apostrophe messing up formula
You can also use a LIKE statement and use wildcard matching depending on what your data looks like. As an example, here is what the first few rows would look like as a CASE statement. CASE WHEN TRIM(…1
