topic Re: Calculated dimension with multiple IF conditions in App Development

Calculated dimension with multiple IF conditions

Saritha077 — Fri, 20 Sep 2024 04:43:21 GMT

Hi All,

I am trying to create a calculate field based on multiple IF conditions in chart in dimension field.

I know we can create easily in script but i need to put in frontend.

If($(variable)<1, 'start',

If($(variable)<2, 'End',

If($(variable)<3, 'xyz',

If($(variable)<4, 'middle','abc'))))

If $(variable) is 1, the field would return start but i need to display all values in chart

start

end

xyz

middle

abc

and measure is Sum(sales)

Please suggest me how can we create this in chart.

Thanks & regards,

Saritha.

Re: Calculated dimension with multiple IF conditions

BrunPierre — Fri, 20 Sep 2024 09:53:16 GMT

Try this

=Only(Aggr(
If($(variable)<1, 'start',
If($(variable)<2, 'End',
If($(variable)<3, 'xyz',
If($(variable)<4, 'middle','abc'))))
,$(variable)))

Re: Calculated dimension with multiple IF conditions

avinashelite — Fri, 20 Sep 2024 10:03:51 GMT

For chart to show all values its better to create an inline load in the script and based on the condition you could calculate the value in the expression

Re: Calculated dimension with multiple IF conditions

ali_hijazi — Mon, 23 Sep 2024 05:36:50 GMT

you can also add the five dimensions start, end,...
then in the Show dimension if : you put $(variable)=1 for "start", $(variable)=2 for "end" , and so on

or as previously said:
you can create one calculated dimension as follows:
aggr(if($(variable)=1, 'start',if($(variable)=2, 'end')), $(variable))

but you are saying that you want to display all values?
can you elaborate more?