Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SWITCH(SELECTEDVALUE

Hi,

I am using dynamic stacked by.

I have created a column which takes user input and I use this value to stack by the 100% stacked bar chart.

I have two tables involved here:

The primary table from where the measure HC_HCorFTE_ED is coming, and I have a seperate table (Age_OrgTenure_PosTenure) to get the user inputs:

Age, Time in company and Time in role.

I do not have any relationship setup between these tables.

The problem is from the output of the below calculation, I always get the TimeInRoleGroups or whatever I put in the "else" part of the SWITCH statement.

Can anyone give me a clue what could be the reason ?

Thanks

 

Need Help
Show and Tell
Tips and Tricks
  • AntonioM's avatar
    AntonioM
    4 years ago

    Hi, 

     

    The problem is that the calculated column is calculated at refresh and then remains constant, independent of any filters in the report itself. That means no matter what changes your user makes (including selecting from slicers) the data in that column won't change.

     

    As it ignores slicers, it's giving you the result for if there is no selectedvalue, so always the 'else' part. 

1 Reply

  • AntonioM's avatar
    AntonioM
    Solution Sage
    4 years ago

    Hi, 

     

    The problem is that the calculated column is calculated at refresh and then remains constant, independent of any filters in the report itself. That means no matter what changes your user makes (including selecting from slicers) the data in that column won't change.

     

    As it ignores slicers, it's giving you the result for if there is no selectedvalue, so always the 'else' part.