I wonder if you could use the class function in an expression together with an aggr function?
I am having two dimensions - one using the class function and one as Year.
Expression:
aggr(count({$<ContentType= {'Incident'}, ows_TSC_SD_Status={'Closed'}>} ows_Created) / count({$<ows_ContentType= {'Incident'}>}ows_Created), Created_Year, (need the class function)
Dimension:
class(if(ows_TSC_SD_Status='Closed',ows_TSC_SD_DateClosed, timestamp(today())) - ows_Created,10, 'Days'))
Year
I have also been thinking of using some kind of Interval or Intervalmatch.
