I have a data type called “Cases”. It has several fields, including “Geo” (list of countries), and Rating (5 options: Low, Medium, High, Positive, Neutral).
Let’s say I have 3 cases in the database:
1 case in France, rating Low
1 case in United Kingdom, rating High
1 case in Japan, rating Low
To feed a plugin i’m using (which build charts), I need the following lists:
List of unique countries referenced in cases: France, United Kingdom, Japan ( I got it using a “search for cases, grouped by geo, each item’s geo”)
List of counts of cases rated “Low” : in this example, it would be 1, 0, 1 (in the same order as countries)
etc for each rating.
I can not figure how to build this list of counts, I’ve been trying different types of groupings, aggregations… but nothing seems to be working
Any help would be much appreciated,
thanks in advance
You can do the same for all ratings. I did High as well in the textbox above. Totally same, except the search constraint in the format as text expression.
I set the country and rating both as text in my data type, but it doesn’t really matter. The same thing would work with options sets or other data types.
Amazing!! Thanks a lot! I really don’t have the reflex to use the format as text… I think i have to learn how to use it properly, it looks like I could save a lot of time in other parts of my app