Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys, I am having a trouble trying to make it appear the "item_id" from the state "Healthy_Food_State", in the chart "Saving" (in the third blue box in the table...
the item_id that are supposed to appear are like D,E,F,G...
Can you guys help me out with this set analysis?
Hi.
It's incorrect syntax. Use square brackets to get the alternate state.
Also for calculated dimension you have to use aggr() function.
aggr(only({$<item_id=[Healthy_Food_State]::item_id>}item_id), item_id)
Thank you, but it is not showing what I want...
The selection is: "Hamburguer" in the first blue box, and then "Hamburguer Replacement" in the second blue box...
If you then put the "item_id" in a list, you will see in the "inherited" state the number 1 only, if you change to "Healthy_Food_State", it will show F,E,G,D... It seems that the field in the Healthy_Food_State is not being shown....
Do you know how to make that work this way?