Antoine Gaultier Posted August 31, 2023 Share Posted August 31, 2023 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 ? Link to comment Share on other sites More sharing options...
Gaia Paolini Posted September 7, 2023 Share Posted September 7, 2023 Sorry, I don't understand. Can you provide an example? Link to comment Share on other sites More sharing options...
Antoine Gaultier Posted September 18, 2023 Author Share Posted September 18, 2023 @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 Link to comment Share on other sites More sharing options...
Antoine Gaultier Posted September 26, 2023 Author Share Posted September 26, 2023 @Gaia Paolini Do you have any ideas ? Link to comment Share on other sites More sharing options...
Gaia Paolini Posted September 26, 2023 Share Posted September 26, 2023 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. Link to comment Share on other sites More sharing options...
Antoine Gaultier Posted September 27, 2023 Author Share Posted September 27, 2023 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 ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now