topic Re: Table indicator based on Current year vs Last year in App Development

Table indicator based on Current year vs Last year

Jonathan_Alm — Wed, 18 May 2022 07:39:54 GMT

Hi,

I have a requirement that I am trying to solve.

Users want an indicator that says if Difference between Current year and Last year is more than 29% then Thumbs UP, if the difference is 20% or below than thumbs DOWN.

A mocked table can look like this:

	Current year	Last year
Total	10 000	7 800
Jan	1000 ^	500
Feb	1400 v	1300
Mar	1000 -	750
Apr	1000 ^	500

I am trying to use the table indicator but do now know if this can be evaluated like this per row?

Kind regards, Jonathan

Re: Table indicator based on Current year vs Last year

brunobertels — Wed, 18 May 2022 10:13:48 GMT

Hello

may be somethink like this :

if(MesureCurrentYear / MesureLastYear > 0.29 , num(MesureCurrentYear, '#,## ▲ ' ) ,

if(MesureCurrentYear / MesureLastYear < 0.20, num(MesureCurrentYear, '#,## ▼ ' ),

num(MesureCurrentYear, '#,## - ' )

))

Re: Table indicator based on Current year vs Last year

vinieme12 — Thu, 19 May 2022 03:49:43 GMT

This is not possible using "Indicators" as they compare against only one value and limits are not evaluated for each row

You can add a Text ▲ ▼ to your measure though as below

=Dual(num(ExpressionCurrYear,'#,##0')&

if( 1- (ExpressionCurrYear/ExpressionLastYear)>0.29,'▲'

,if(1- (ExpressionCurrYear/ExpressionLastYear)<0.20,'▼','►')

, ExpressionCurrYear)