Hi Everyone,
I've been trying to wrap my brain around this one. I'm using a series of gauge charts to measure time differences between two events.
Currently I have the expression to obtain the difference in minutes from the times
=Avg(Time((TimeB),'hh:mm:ss')*24*60 - Time((TimeA),'hh:mm:ss')*24*60)
`
The other charts follow suite, TimeC-Time B, TimeD-TimeC etc
This shows are fairly accurate time average. However, I want to filter out dispositions so if a time falls into a certain category to ignore it from being used in the calculation of the chart without any selection. Below is a mockup of the table
Date | Disposition | TimeA | TimeB | TimeC |
06/01/2020 | A | 0800 | 0900 | 1000 |
06/01/2020 | B | 0815 | 1915 | 2015 |
06/01/2020 | C | 0900 | 1000 | 1100 |
Due to the nature of disposition B in the table, it's a different workflow that could skew the numbers i'm looking for. Therefore on the initial load of the page with these charts, looking for a way to not calculate that value.
I know this code doesn't work, but this was my thought process on how this would work:
If(Not Match(Disposition,'B'),Disposition,null()) THEN AVG(Time((TimeB,'hh:mm:ss')*24*60 - Time((TimeA),'hh:mm:ss')*24*60)
Any help with this would be greatly appreciated!