topic Re: Filters issue with Calculated Dimension in Connectivity & Data Prep

Filters issue with Calculated Dimension

nvrphanikumar — Thu, 06 Sep 2018 02:45:15 GMT

I have this calculated dimension.

Basically,when a user makes selections on MyLv16, i would like to show MyLvl6Directs values

if they selected MyLv15,Then MyLvl5Directs

I was able to confirm that,Its showing the right values from right columns.

But when a selection is made, search bar gets messed up displaying all columns in the calculated dimension.

Example,If i select values from MyLvl4Directs , It selects all the dimensions as filter selctions in the selection bar.

Am i doing something wrong here ? Any suggestions please?

If(GetFIELDSelections(MyLv16)>1,

MyLvl6Directs,

If(GetFIELDSelections(MyLv15)>1,

MyLvl5Directs,

If(GetFIELDSelections(MyLv14)>1,

MyLvl4Directs,

If(GetFIELDSelections(MyLv13)>1,

MyLvl3Directs,

If(GetFIELDSelections(MyLv12)>1,

MyLvl2Directs,

If(GetFIELDSelections(MyLvl1)>1,

MyLvl1Directs,

[Directs Only]

)

vunguyenq89 — Thu, 06 Sep 2018 06:39:02 GMT

Can you share a sample app to quickly demonstrate the issue?

shraddha_g — Thu, 06 Sep 2018 06:48:42 GMT

Try

If(GetSelectedCount(MyLv16)>1,

MyLvl6Directs,

If(GetSelectedCount(MyLv15)>1,

MyLvl5Directs,

If(GetSelectedCount(MyLv14)>1,

MyLvl4Directs,

If(GetSelectedCount(MyLv13)>1,

MyLvl3Directs,

If(GetSelectedCount(MyLv12)>1,

MyLvl2Directs,

If(GetSelectedCount(MyLvl1)>1,

MyLvl1Directs,

[Directs Only]

)

nvrphanikumar — Thu, 06 Sep 2018 11:17:18 GMT

This has the same behavior as well.