How can I add 2 Kpi charts when they follow certain conditions ?

[Antoine Gaultier]

I will try to explain as much as I can, I have basically a few KPI charts that I wanna sum together to create one KPI, but I don't want to add them all the time, I want to add them together only when they follow the conditions I want. For example each row of data has timestamps, and I calculate the difference between those timestamps. One KPI is the difference between those timestamps and another KPI is what we usually get between those timestamps, the average. I want to add this "average timestamp" to the rows where we don't have those timestamps.

Is it understandable ?

[Gaia Paolini]

Sorry, I don't understand. Can you provide an example?

[Antoine Gaultier]

@Gaia Paolini​  Yes sorry for the delay,

So As you can see here we have multiple KPIs, Basically I want to add them together and create one Kpi,

So I want to do this formula (A * Row count of A) + (D+B)*Row count of D+(E+B+C)*row count of E+(F+C)*Row count of F. and everything would be divided by row count of (A+D+E+F)

It means it's (4,9*40490+(4.38+0.8)*29303+(3.52+0.8+2.02)*1819+(1.93+2.02)*58)/71 670.

It should give 5.05 approx

[Antoine Gaultier]

@Gaia Paolini​ 

Do you have any ideas ?

[Gaia Paolini]

Unfortunately, no I still don't understand your question, and the relationship between the clarification and the original question.

I hope some other community user might be able to help you.

[Antoine Gaultier]

Well to make it easier let's just assume I want to add the KPI A with the KPI B and I want to have a third KPI who will be the result ( so 4,9 + 0,8), is it possible to basically make a sum ?