Could you provide a sample packaged workbook? We'll need to understand the structure of your data and how you've built the chart in order to properly help with this question.
Are you planning to display the resulting data in table form as you've shown here?
Yes. I would like that. Possibly on a third row. But I am okay with any way to display it on the same worksheet.
To get the desired result, you should do a workaround.
1. Create a calculated field
2. Add the calculated field in new sheet without Phase as below
And create a dashboard and include both the sheets and will exactly look like your desired result.
Attached the workbook for your reference.
I hope this helps If it does, can I ask you to mark it as helpful and correct? this will help other users to find correct answers and will allow us to close the thread. Many thanks!
Sample1.twbx 31.0 KB
Thank you. Love how you combined the two sheets on a dashboard. That helps me with some other projects as well.
I'd suggest creating three calculated fields like this:
// Count of open projects COUNTD( IF [Phase]="Open" THEN [Project Number] END )
// Count of closed projects COUNTD( IF [Phase]="Closed" THEN [Project Number] END )
// Ratio of Closed to Open [Closed Projects]/[Open Projects]
Then use Measure Names on the rows shelf instead of Phase.
Ratios.twbx 28.0 KB