Relative numbers

[SevillaFe]

Hello,

I have a problem with the calculation of relative quotas.
The data e.g. come from two tables:
1. Failed units:
2. Units produced

Calculation (Failed units/produced units) *1000

The problem is that the failed units have some characteristics (Model, color, shape, production factory, ...) (... represents the filters that I use in the dashboard)
The produced units should have the same characteristics and should be chosen automatically with dasboard filters:

then the calculation would be:

Calculation: (Failed units (Model1, color 1, factory 1)/Produced units (Model1, color 1, factory 1)) *1000

Can you help me?

Thank you!

[h_prakash]

Hi,

Can you provide a sample data. I am not visualizing how the data is like.

Thanks

Prakash

[morenoju]

I think seeing the load script, and the actual columns the tables "Failed units" and "Units produced" would help. Can you share it?

[rogerpegler · Accepted solution]

I'm guessing your two tables have the same characteristics (eg model, color, factory) and values, but in different fields otherwise they would be joined by association.

Assuming you are filtering based on the Failed_Units version of the fields, the following expression may work

Count(Failed_Units) / 

Count({< Model_Produced_Units=p(Model_Failed_Units), Color_Produced_Units=p(Color_Failed_Units), Factory_Produced_Units=p(Factory_Failed_Units)>} Produced_Units)

*1000

[SevillaFe]

Hi!!!

Sorry for my delay...

it works!! Awesome 😀

thank you so much for your Help!!!