topic Dimension to be set with static values in App Development

Dimension to be set with static values

shrutipg — Sun, 13 Dec 2020 01:35:35 GMT

Test result is single value dimension and psuedo code as follows

Test Result : Pseudo Code:
if (Update Score='1' then 'Success', if (Update Score=2 then 'Suspect', if (Update Score='3' then 'Failed')))

How this be created ?

i am getting only Failed as a value with if then else condition even though update score is 1 or 2

Re: Dimension to be set with static values

Vegar — Sun, 13 Dec 2020 07:00:40 GMT

Try adjusting the syntax to this:

if ([Update Score] ='1', 'Success', if ([Update Score] =2, 'Suspect', if ([Update Score] ='3', 'Failed')))

Re: Dimension to be set with static values

Vegar — Sun, 13 Dec 2020 18:19:19 GMT

You could even try using ~~Match()~~ pick() for this.

~~Match ([Update Score], 'Success', 'Suspect', 'Failed')~~

Pick([Update Score], 'Success', 'Suspect', 'Failed')

Re: Dimension to be set with static values

shrutipg — Sun, 13 Dec 2020 09:15:00 GMT

Hi Vegar,

Thanks , But Update Score returns numeric value ( 1, 2 , or 3)

and result should be success, failed, suspect based on numbers returned, match dint work here

correct me if wrong.

Re: Dimension to be set with static values

GaryGiles — Sun, 13 Dec 2020 13:24:49 GMT

If Update Score is numeric, you want to use the pick function.

Pick([Update Score], 'Success', 'Suspect', 'Failed')

Re: Dimension to be set with static values

Vegar — Sun, 13 Dec 2020 16:16:02 GMT

Yes, pick() was what I was thinking of, not match() . Sorry for missleading you @shrutipg.

Re: Dimension to be set with static values

Kushal_Chawda — Sun, 13 Dec 2020 16:34:39 GMT

@shrutipg It is better to create field using applymap in script instead of using calculated dimension.

Map_Score: mapping LOAD * inline [ Score, Description 1, Success 2,Suspect 3,Failed ]; Data: LOAD *, applymap('Map_Score', Updated_Score,'NA') as Description FROM table;

Now you can use Description field in Dimension.

Re: Dimension to be set with static values

shrutipg — Mon, 14 Dec 2020 20:45:56 GMT

Thanks , it has worked 🙂

but still not able to add this logic to dimension.

It worked when i added the calculation as measure