Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a question when trying to customize a measurement calculation chart.
Example: I have the following data table:
Leader | Project | Perform | Architec | QA | Oper | Security |
---|---|---|---|---|---|---|
Juan Mendaz | AAA | 100% | 0% | 100% | 50% | 100% |
Juan Mendaz | BBB | 100% | 100% | 100% | 100% | 100% |
Pablo Perez | CCC | 100% | 0% | 100% | 100% | 0% |
Karina Ulloa | DDD | 100% | 0% | 50% | 100% | 100% |
Karina Ulloa | EEE | 100% | 100% | 100% | 100% | 100% |
Karina Ulloa | FFF | 100% | 100% | 100% | 50% | 100% |
I need to calculate the minimum value for each leader and the average of each of the areas (Management, Architecture, Quality, Operations and Security) project, and I tried with this function:
Min(Aggr(Avg(Architec)avg(QA)avg(Perfom)avg(Oper)avg(Security),Leader)) but does not work in the chart, the chart included as measurement data does not recognize "the graph is not shown because it only contains undefined values."
Thank you help me shape the appropriate function for calculating I need in graph.
I'll be very greatful.
Can you try this:
RangeMin(Avg(Architec), Avg(QA), Avg(Perfom), Avg(Oper), Avg(Security))
Tommy is perfect, thanks thousand!
Hahahaha how is tommy?
If you got what you were looking for, do you mind closing this thread down by selecting the correct answer.
jajaja sorry Sunny <"the self-correcting">
Okay, I do right away!