Ability to Group by a Logical Column across multiple dimensions
My use case is I want to build a card based on 3 Dimensions,
2- Solution Play (tagged to the Opportunity)
3-Logical grouping (Engagement Stages).
|Engagement Stages (Grouping)||Logic|
|Consideration (C)||If an Opty exist in Stage 0, Stage 1, Stage 2|
|Negotiation (N)||If an Opty exist in Stage 3, Stage 4|
|Vendor Selection (VS)||If an Opty exist in Stage 5|
|Closed Won (CW)||If an Opty exist in Stage 6 and contract booked|
I would want a report like,
|Target Account||Sol Play1||Sol Play2||Sol Play3||Sol Play4|
|Bank of America||C,N||C,CW||VS||VS,CW|
Bank of America has an Opty In Stage 1/Stage 2 (consideration -C)across Sol Play1, Sol Play2.
Bank of America has an Opty In Stage 3/Stage 4 (Negotiation-N) across Sol Play1
Bank of America has an Opty In Stage 5 (Vendor Selection -VS)across Sol Play3.
Bank of America has an Opty In Stage 6 (Closed Won-CW)across Sol Play2 and Sol Play4.
The grain of the data is at Opty Level(Opportunity ID).
I'm wondering how to build my card.
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 726 New to Domo
- 85 Dojo
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 302 仲間に相談
- 664 ひらめき共有