Mark -
I don't understand, then the whole concept of creating a summary formula using distinct count in the pie chart if there is no way to actually use the summary formula on the pie chart. How / where would the pie chart summary formula be demonstrated? Separately, how would one create a companion gauge chart that associates to the data that has been included in dynamic filters?
Use Case:
- We have ~400 2021 projects in our project table.
- Each project identifies impacted value chain teams from a multi-select. (Each project will impact 1-n value chains)
- Each project identifies impacted markets from a multi-select. (Each project will impact 1-n markets)
- Each project identifies impacted systems. (Each project will impact 1-n systems)
- These 3 multi-select fields are dynamic filters.
- Each project goes through 5 project phases.
- Pie chart built to demonstrate Active Projects by Phase with dynamic filters to look at all, or various combinations from the dynamic filters.
- Pie chart dynamically changes based on the dynamic filters. Each slice identifies the # of projects in slice and allows drill down to the subset records below the slice.
- Easy to drop a picture of the pie if needed for an update presentation.
- Problem: It is untenable to do mentally or manually do the math of the sum of slices. There MUST be a way to do this. Thoughts????
------------------------------
Annetta Coleman
------------------------------
