Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to create a measure T.Pendentes (the red one) that is the sum of the mesasure Pendentes (the yellow) on the previous years.
So it should be:
68 on 2014
68+132= 200 on 2015
68+132+292=492 on 2016.
I don´t know if it help but at the moment the formula for the yellow measure is:
Count(
{
$<status_name={
'new',
'open',
'pending reminder',
'pending auto close+',
'pending auto close-',
'approved',
'Waiting customer action',
'Waiting implementation Date',
'Verification in progress'
}>
}
[ticket_id])
Not for the dimension, but may be under the appearance
My bad, it is under Add-ons -> Data handling -> Uncheck Show zero values