Hello. I have a field "equity focus area" that has five different data choices (race, gender, national origin, religion, and SES). The field "equity focus area" is in a table named "Project" and each ...
No problem. I think I will make the problem simpler by introducing four regions. Here is some sample data:
I have one table Programs with three fields:
[Program Name] Text [Region] Multiple Choice with values {North,East,South,West} [Equity Focus Areas] - Multiple Selection with values {Race,Gender,National Origin,Religion,SES}
There are 24 Programs code-named after the 24 letters in the Greek alphabet.
I will produce four pie charts for various "views" of this data - one for each region. The pie charts will have up to five slices and correspond to the following aggregations across reports for each region:
North ===== Value | Count =================+======= Race | 3 Gender | 2 National Origin | 2 Religion | 3 SES | 2
East ==== Value | Count =================+======= Race | 3 Gender | 2 National Origin | 0 Religion | 2 SES | 3 South ===== Value | Count =================+======= Race | 2 Gender | 2 National Origin | 1 Religion | 0 SES | 3 West ==== Value | Count =================+======= Race | 2 Gender | 3 National Origin | 1 Religion | 3 SES | 2
In fact, I am going to go even further to simplify this demo. I am going to structure the pie chart generation by specifying a query ti specify which to records to aggregate over. So if you wanted to aggregate over all records in say the North andSouth regions, you would just specify a query that returned those records and one aggregate pie chart will be generated per query.
To make the demo even simpler I am going to use only oneRich Text Formula field to do everything. No relationships, no user defined variables, no code pages, no summary or lookup fields. Just oneRich Text Formula Field.