Ability to Group by a Logical Column across multiple dimensions
Hi,
My use case is I want to build a card based on 3 Dimensions,
1- Account,
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 |
Meaning,
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.
Thanks,
Chandramouli
Comments
-
One question on your data. For the 'Solution Play' dimension, is this a variable for each account or does each account have the same number of solution plays?
0 -
The data is at Opty Level, and the Opty is tied to an Account and a Solution Play. So basically a Solution Play is tied to an Opty. There are totally 18 Solution PLays in all.
0 -
This is how I would reccomend building the card.
This allows you to see the total number of opportunities (by engagement stage). You can also use the quick filter to select specific solution plays. I added total opportunity value as the summary number.
I think this is a better visualization than a table with 18 columns (one for each solution play).
Just my 2 cents. Is this data going to be consumed looking at each account individually? or would you be looking accross all accounts in a territory?
0 -
If it's going to be accross multiple accounts, I would do a stacked bar instead:
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive