-
1. Re: Problem with special calculation
Brent Mathison Oct 27, 2017 6:57 AM (in response to Andreas Kuhnen) -
2. Re: Problem with special calculation
Branden Kornell Oct 27, 2017 7:23 AM (in response to Brent Mathison)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.
-
3. Re: Problem with special calculation
Brent Mathison Oct 27, 2017 7:37 AM (in response to Brent Mathison)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.
-
4. Re: Problem with special calculation
Zhouyi ZhangOct 29, 2017 6:15 AM (in response to Andreas Kuhnen)
Hi, Andreas
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
ZZ
-
Example_data.twbx 37.3 KB
-
-
5. Re: Problem with special calculation
Shinichiro MurakamiOct 29, 2017 11:58 AM (in response to Andreas Kuhnen)
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.
Anyways,
Some of calculation involve my over complication and I am lazy not to clean up those..
failure example
Thanks,
Shin
.
-
Example_data_SM_10.3.twbx 58.5 KB
-
-
6. Re: Problem with special calculation
Yuriy FalOct 29, 2017 3:24 PM (in response to Shinichiro Murakami)
Hi friends,
I beg your pardon for jumping in with the view
slightly deviating from the original request.
Please find the attached.
Hope it could help.
Yours,
Yuri
-
Example_data_YF.twbx 65.3 KB
-
-
7. Re: Problem with special calculation
Zhouyi ZhangOct 29, 2017 4:26 PM (in response to Yuriy Fal)
-
8. Re: Problem with special calculation
Andreas Kuhnen Oct 30, 2017 3:47 AM (in response to Zhouyi Zhang)Hallo everyone,
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!
-
9. Re: Problem with special calculation
Andreas Kuhnen Nov 3, 2017 6:23 AM (in response to Andreas Kuhnen)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,
Andreas!
-
Example_data (2).twbx 21.2 KB
-
-
10. Re: Problem with special calculation
Andreas Kuhnen Nov 3, 2017 6:25 AM (in response to Andreas Kuhnen) -
11. Re: Problem with special calculation
Yuriy FalNov 3, 2017 6:29 PM (in response to Andreas Kuhnen)
Hi Andreas,
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?
Yours,
Yuri
PS Other questions may follow depends on your answer.
-
12. Re: Problem with special calculation
Andreas Kuhnen Nov 9, 2017 11:45 PM (in response to Yuriy Fal)Hello Yuriy,
sorry for my late reply! I want to count project categories.
Thanks a lot,
Andreas
-
13. Re: Problem with special calculation
Yuriy FalNov 10, 2017 1:47 AM (in response to Andreas Kuhnen)
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?
Please reply,
Yours,
Yuri
-
14. Re: Problem with special calculation
Andreas Kuhnen Nov 10, 2017 6:31 AM (in response to Yuriy Fal)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.
Yours,
Andreas
-
Example_data (2).twbx 26.0 KB
-