Forum Discussion
Custom dimension based on measure
Hi all, I am attempting to create a dimension to use on a bar graph. Where I am having x axis being a categorization/buckets of a calculation done by a measure. What I want to do, is to categoriz...
CoreyP
Solution Sage
Solution SageI think what you need to do is called binning. However, you can only bin a calculated column, not a measure. So, you'll need to create a summarized calculated table to use, rather than your measure.
Hi Corey. Thanks for your suggestion. I tried creating a calculated column, but I didnt give me a satisfactory result. Tried something like: if measure 4 < 4% and > 2% then "2-4%". But it seemed like it evaluted the entire column and not each row.