Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SWITCH(True()) Measure Incorrectly Categorizing due to overlapping '&&&' conditions

Hi All,   I am using the following measure to bucket movement between two scores overtime under a few categories However by the looks of results, my categories seem to bucket these criteria ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi All,

     

    I was able to think through and find a way to correctly bucket my data. Turns out my data buckets needed to be defined more presicsely. ALLSELECTED was a lifesaver for me to work with my time ranges. following is the corrected version of my Select TRUE function. Hope this helps, 

     

    Thanks

     

     

     

MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous ,

 

To what I can understand you are calculating the count of values for each bucket being the bucket created by a measure is this correct?

 

Be aware that measures are context sensitive so when the context changes the calculations change has you can see no the last column that you have a Moved Up bucket (in theory on the total line the bucket should not exist).

 

can you share a sample file?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi All,

 

I was able to think through and find a way to correctly bucket my data. Turns out my data buckets needed to be defined more presicsely. ALLSELECTED was a lifesaver for me to work with my time ranges. following is the corrected version of my Select TRUE function. Hope this helps, 

 

Thanks