To put summary numbers behind the chart, you would need to hack a solution using a dual axis. (You would create a second chart, and layer it behind the first.)
The trick is getting the positioning consistent, and placing a zero if needed.
You might use use a second data source that just contains coordinates for the four quadrants, and blend that with the project totals.
Sorry - I missed the second part of your question, which was how would you get each of those numbers in the background of the proper quadrant. Other than what Branden Kornell suggested above, I can't think of a way to get the quadrant totals placed appropriately. My first instinct was to create a separate worksheet filtered to each quadrant value (i.e. High Risk / High Volume, High Risk / Low Volume, etc), display the total in a circle, and place that as a floating object over the matrix in a dashboard. Unfortunately the transparency can't be set to allow both the matrix and the total to show through.
Please find my workaround to your case, though it is not meet all your requirement, you may consider as a temporary way before you could get any further solution.
Here is the result
To achieve above,
the first step is to union your data by itself
and then create below calculation fields
and then drag the calculation fields to the viz
and finally, change to dual axis and sync the axis
The workbook attached for your reference. Hope this could help
Example_data.twbx 37.3 KB
HI Andreas, ZZ
Sorry for jumping in.
I did this without duplicating data, but one difficulty is align X-axis with whole number and decimal .
I tried to put big circle in the middle of range, but most of the case, the position is not the center, because I needed to put on top of existing data.
Some of calculation involve my over complication and I am lazy not to clean up those..
Example_data_SM_10.3.twbx 58.5 KB
I beg your pardon for jumping in with the view
slightly deviating from the original request.
Please find the attached.
Hope it could help.
Example_data_YF.twbx 65.3 KB
thank you very much! I'm really excited about the many answers!
I've never seen such a perfect community before!
Many of your suggestions are fine for me but especially the last one exactly hits my requirements!
Thank you very much!
Hello everyone again,
I was able to transfer the solution by Yuri Fal to my worksheet but now I am struggeling with a difference between the example data and my original data.
In my original data I assign each project to a project category (one project category includes one or more projects).
Actually I wanted to visualize only the project categories and not single projects. The problem is, that I cannot adjust your solutions, so that it sums up the project volume and only shows the project category.
I updated my example and attached it again and I really hope, that it's not that complicated to transfer the solution to the updated data.
Thanks a lot for your help,
Example_data (2).twbx 21.2 KB
One question to make things clear to me
Do you want to count Projects in each Quadrant,
or do you want to count Project Categories?
PS Other questions may follow depends on your answer.
sorry for my late reply! I want to count project categories.
Thanks a lot,
OK, then the next questions, please:
1) What level of detail (VizLOD) should be on a view?
Should each Mark represent a distinct [Project Name],
or should it be a distinct [projekt_category]?
2) How the [Project Risk] value should be calculated
when aggregated by the [projekt_category]?
Should it be weighted by [Project Volume],
or aggregated by some other calculation logic?
Question 1: Each mark should represent a distinct [project_category].
Question 2: Sorry, there was another mistake with my example data. In my original data I've got a mapping, so that every project within a [project_category] has the same [project_risk]. Therefore no special calculation logic is needed. I attached the corrected example data.
Example_data (2).twbx 26.0 KB