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?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
If it's going to be accross multiple accounts, I would do a stacked bar instead:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 460 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 187 Visualize
- 251 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive