Percentage of total connected to a dimension

harjedalskok — Wed, 25 Nov 2020 16:16:04 GMT

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é

Re: Percentage of total connected to a dimension

Vegar — Fri, 27 Mar 2020 12:15:08 GMT

Is this what you are looking for?

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