My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule.
In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim.
Below is an example where we have 10 Feedback/Comments/Verbatim.
I tried 4 different Beast Modes -
Unique Count Token = Count(Distinct 'Survey Token ID')
Unique Count Feedback = Count(Distinct 'Feedback')
Count Token = Count('Survey Token ID')
Count Feedback = Count('Feedback')
When used Beast Modes in Filters section in Analyzer it returns following output:
Unique Count Token (Business Rule applied >=5) = No Data
Unique Count Feedback (Business Rule applied >=5) = No Data
Count Token (Business Rule applied >=5) = All Good is the only feedback that shows up
Count Feedback (Business Rule applied >=5) = All Good is the only feedback that shows up
No matter whatever approach I try, it will look for Feedback count >=5, hence I am not getting the expected output.
Survey Token ID | Feedback |
|---|
A001 | All Good |
A002 | All Good |
A003 | Our Leaders are approchable |
A004 | All Good |
A005 | We have good Cafeteria |
A006 | All Good |
A007 | I have a Good Work-Life Balance |
A008 | I feel I am valued |
A009 | I enjoy doing my Work |
A010 | All Good |
Can someone please advise, how can I handle this scenario using Beast Mode.
Please Note that the Schema is much more complex than what I have shown here and we cannot make any change in the schema.
