Percentage of total connected to a dimension

[harjedalskok]

Hi,

I am trying to get a percentage of faulty orders / total amount of orders

I have two dimenssions

Deliveryoffice

Faultdescription

3 expression

One that count orders with fault,

One that count total amount of orders

Since the dimension value Felfri = no faults isnt on the same raw as faults "Felborrad" or "Transportskada" the expression cant calculate it.

How should i do this calculation?

expressions used:

count ( {$ <Felkod = {'Montör'}> } (Ordernr)) All faulty orders

count ( {$ <Ordertyp = {'Order'}> } (Ordernr)) All orders

This is with selection of "helsingborg" and the second is how the table could be seen without any selection on "delivery office"

Thanks in advance
Regards
André

[Vegar · Accepted solution]

Is this what you are looking  for?

count({$<Felkod={'Montör'}>}Ordernr)/count(TOTAL {$<Ordertyp={'Order'}>}Ordernr)