How to create one chart expression

[Anonymous]

Hi there,

PFA,

Could you please assist me with creation of one chart expression. I would like to have a situation like this

Issue_Rule                                                  Score

<20% issues are AIV                                      5

<79% Limited issues                                     12

>16% overdue less than 6 months          13

>21% Major issues                                          14

and so forth. 

I am hoping if I can be assisted with the above, I will be able to calculate the percentages and create charts and not use text boxes.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Actually I won't combine the expressions into one, but simply add another expression to the table that sums the other four and then hide the others. See attached example.

If you do want one expression then you just need to expand your pick function and add the parts that are now in the four expressions you have. Not that hard, just tedious.