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 and South 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
one Rich Text Formula field to do everything.
No relationships,
no user defined variables,
no code pages,
no summary or lookup fields. Just
one Rich Text Formula Field.