Best Of
Re: Help with Beast Mode Formula
Just to be clear each record has a value for A, B and C, which will either be a 1 or 0 since they are basically flags and your card should show a single % based on all the entries that match your filter criteria (including date range).
Can you share the examples of the list of values for A, B and C you're using and how manually you're getting to 9.4%? This will allow us to understand the logic behind how it should be calculated via beast mode, or even better, lets suppose your filtered range would give you these 9 entries:
What would be the result you would expect and can you explain how you're getting to it?
Re: Help with Beast Mode Formula
What happens if you use a table chart and then create separate beast modes for A, B and C to sum them all together and validate those sums are calculating correctly? Do you get the numbers you're expecting for each of those?
SUM(A) / (SUM(A) + SUM(B) - SUM(C)) should work according to your logic but without knowing the underlying logic being used in the beast mode to calculate the flags it's difficult to pinpoint the exact cause.
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 Count))*100
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.
Re: Drill down into table
You can create a custom drill down. Follow the images below for the steps:
In your custom drill view create a table card with the fields you listed.
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.