Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression of CYTD-LYTD
fabs(count({1}{<[date]={">=$(=YearStart(Max(date([date],'DD/MM/YYYY'))))<=$(=date(MakeDate(Year(Max([date])),Month(Today()),Day(Today(0)-1)),'DD/MM/YYYY'))"},[year]=, [month]=>} id)-count({1}{<[date]={">=$(=YearStart(Max(date([date]),'DD/MM/YYYY'),-1))<=$(=date(MakeDate(Year(Max([date]))-1,Month(Today()),Day(Today(0)-1)),'DD/MM/YYYY'))"},[year]=, [month]= >} id)
)
I set the coloring limit to the second part for LYTD like so:
count({1}{<[date]={">=$(=YearStart(Max(date([date]),'DD/MM/YYYY'),-1))<=$(=date(MakeDate(Year(Max([date]))-1,Month(Today()),Day(Today(0)-1)),'DD/MM/YYYY'))"},[year]=, [month]= >} id)
and over this LYTD i want the color to be green and use the upwards triangle
and below this LYTD i want the color to be red and use the downwards triangle
For 2021 the count is 837519
For 2020 the count is 688032, so this KPI should show 149487 with the upwards triangle, well it shows 149487 with the downwards triangle.
Any idea what is wrong here?