-
1. Re: Showing Only Top 3 in Bubble Chart
David Li Aug 26, 2016 11:14 AM (in response to Nathen Wagner) -
2. Re: Showing Only Top 3 in Bubble Chart
Nathen Wagner Aug 26, 2016 12:02 PM (in response to David Li) -
3. Re: Showing Only Top 3 in Bubble Chart
David Li Aug 26, 2016 12:14 PM (in response to Nathen Wagner)No problem!
Here, it looks like your breakdown (which is also called your level of detail) is determined by both [Direct Sponsor] and [Award Admin School]. Now, you need to figure out if these dimensions will create cross products. Think of this like putting all the Direct Sponsors and Award Admin schools into a Venn Diagram. Do any of the circles intersect?
For instance, let's say that Direct Sponsors never choose more than one Award Admin School. In that case, you won't get any cross products, and the number of bubbles will be equal to the number of Direct Sponsors. If that's the case, then you can just use Award Admin School as your dimension for the filtering I mentioned in my first reply.
However, if Direct Sponsors can pick more than one school, then you'll get more bubbles than schools or sponsors. In this case, you'll have to create a combined field of both Direct Sponsors and Award Admin Schools (the easiest way is just to select them both, right-click, and select Create > Combined Field). Then, you can filter on that. FYI, you can also use this method if your fields are non-intersecting.
When you use the filter, you should filter by the Obligated field you mentioned. (In my sample screenshot, I'm filtering by Sales.)
Let me know if you need any additional clarification!
-
4. Re: Showing Only Top 3 in Bubble Chart
Nathen Wagner Aug 26, 2016 12:28 PM (in response to David Li) -
5. Re: Showing Only Top 3 in Bubble Chart
David Li Aug 26, 2016 12:31 PM (in response to Nathen Wagner)Oh, weird! I didn't realize that the Top filter would be excluded like that. You can manually create a combined field by just adding a + sign between the two fields in a calculated field. I.e.:
[Direct Sponsor] + [Award Admin School]
Then, you should be able to filter on that.
-
6. Re: Showing Only Top 3 in Bubble Chart
Nathen Wagner Aug 26, 2016 12:39 PM (in response to David Li)Worked great! Thanks, David!
-
7. Re: Showing Only Top 3 in Bubble Chart
David Li Aug 26, 2016 1:05 PM (in response to Nathen Wagner)You're welcome! Glad I could help!