Expression to filter results in a gauge chart

[kgeen]

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!