Forum Discussion
Helper Vgrouping question
Helper V
This is how it looks as of now. In a separate table visualization as soon as I drop colorcode, the only color it displays is GREEN because overall result is GREEN. This is happening because the GREEN/RED for individual plan is determined based on the calculation for that plan.
Desired output for above is:
Colorcode Count
RED 2
GREEN 7
Thanks.
- RMDNA
Solution Sage
In the visual settings, turn off "Total", and set Health Plan to "Count" rather than "Don't Summarize"
- ppgandhi11
where is the "Total" that I need to turn off? I did not get that part.
Also, I already tried doing count on Health Plan the way you showed me. That would not work I think because I am getting 1000s of records from the database. every record has a associated health plan.
The logic is: if the 90% of claims are paid within 15 days, then the associated health plan should turn Green, otherwise Red. I got upto the point I demonstrated where I am putting every plan in either green or red by using various measures.
Now I need to display how many plans are red and how many are green. that is where I am stuck.
If I put count on health plan, then the aggregation is putting the numbers in 10000s for green and red is missing because overall total claims and processed claims are above 90% for all the healthplans collectively.
- ppgandhi11
may be this will give you a better picture. The bottom table shows total number of records, processed records and green/red for each of the health plan.
The total number gets displayed when i follow your steps. The total is turned off in the middle visual .
- ppgandhi11
if the color is a calculated column then it works fine. I just tested it. My problem is: color is a measure that is being derived from the calculations.