Creating a gauge chart by epic with color indicating overall progress

Hi all, as the title states, I’m attempting to create a gauge chart in Eazybi which will show the number of issues related to an epic in Jira, with the gauge itself indicating at which step the issues are in through the workflow (e.g. To do, In Progess, Done).

I attempted to create my own calculated measure - see below:

[Status].[Ready for Dev].
[Dev in Progress].
[Dev Complete]
.[Ready for QA]
.[QA in Progress]
.[QA Complete]
.[Ready For UAT]
.[UAT in Progress]
.[UAT Complete]

However, when I select this measure to be used as what I can define in the “set limits” section, nothing shows up on my report.

I guess I have two questions - would this aggregate actually give me what I’m looking for within the gauge, so I can set my own colors by status? Secondly, is there a better way to do this?