Forum Discussion
Progress bar calculation and design
Anonymous I see the issue, your data is in pivoted shape, and you need to unpivot it.
Transform Data -> Select Id Column -> Right click -> Unpivot other columns, it will create two columns attribute and value, rename those as you fit and then use attribute columns (or whatever you rename it to) on the y-axis.
HTH
Super UserAnonymous I see the issue, your data is in pivoted shape, and you need to unpivot it.
Transform Data -> Select Id Column -> Right click -> Unpivot other columns, it will create two columns attribute and value, rename those as you fit and then use attribute columns (or whatever you rename it to) on the y-axis.
HTH
The example I gave above is simplified. I have hundreds of columns and that table is also joined to another table 1:1. When I tried to unpivot the way you recommended, it threw an error as the 1:1 relationship was breaking due to creation of the Attribute. So here's what I did and please let me know if it makes sense.
I duplicated the original table and removed the 1:1 relationship with this other table. The original table still has that relationship to do the other logic that I have elsewhere in the report. This new table without any relationship is my table for unpivoting. I clicked on ID and did "unpivoting other columns" as you suggested. For the bar charts, I brought in the percentages of work done and "total 100%" measures the way you suggested, but I am using these from the original table. The new duplicated table now unpivoted doesn't have those measures. For the Y axis, I am using the Attribute column from the duplicated, unpivoted table.
Does it make sense? If it does, if the report is refreshed, does the duplicated table automatically update its values based on the main table?
Thank you for the insights!