Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
JRamos
Contributor III
Contributor III

Pareto with 2 dimensions

Hi all!

I'm trying to create a Pareto chart with two dimensions using set analysis but the visualization is not working with the essential filter, when I use it, the pareto don't move to due 'yes' or 'no',  my table is working and my Pareto% as master item too, but not the set analysis in the pareto chart, even, I can't personalized the colors at the end...


Set analysis to Due 'No': count({<[Due]={'No'}>}distinct([Reqs]))
Set analysis to Due 'Yes': count({<[Due]={'Yes'}>}distinct([Reqs]))
To create the Pareto% as master item:  RangeSum(Above(Count(distinct([Reqs]))/Count(total distinct([Reqs])),0,RowNo()))

JRamos_0-1645540577113.png

Could you support me?

Regards!!!

 

Labels (6)
0 Replies