Row Average Total in Chart
Hello YF Community,
I'm trying to find row average total.
In the screenshot, I'm able to breakdown into Count and Avg Days taken by a person.
For Average Days Total, the value displayed is (Approved Avg days + Rejected Avg Days)/2.
I'm trying to find a way for Average Days Total to give me the value of
(Approved Count*Approved Avg Days + Rejected Count*Rejected Avg Days)/Total Count
Is it possible to achieve this in YF ?
May be create a new Calculated field ?