Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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é
Is this what you are looking for?
count({$<Felkod={'Montör'}>}Ordernr)/count(TOTAL {$<Ordertyp={'Order'}>}Ordernr)
Is this what you are looking for?
count({$<Felkod={'Montör'}>}Ordernr)/count(TOTAL {$<Ordertyp={'Order'}>}Ordernr)