I need to create 3 different clients groups starting from a 'value' field. Let me explain myself: given a client name ('client'), and their revenues ('revenues'), I need to split them in:
- clients with <1000$ revenues
- clients with revenues >1000$ and <10000$
- clients with revenues > 10000$
Is it possibile to create the groups as a BI user? I don't have access to the administration area.
Thanks a lot in advance,
Have a look at Bins. You can do this within Answers; no admin access needed.
OBIEE in IL: OBIEE - Grouping measures and counting group members
Thanks a lot. You just taught me something new. I had resolved this problem, using a CASE WHEN, but bins seems to be a better way to approach it.-