Avg. Created Opportunities
Hi,
I'm trying to create a Beast Mode calculation that will let me see the average opportunity by month (distinct by year) over all time (not actually broken out by month, but by individual who created them).
Currently I have this, which counts as several years being the same month. How do I group them easily to be distinct? i.e. Jan 2016 is distinct from Jan 2017
So:
COUNT(DISTINCT`License Sales Opportunities-Id`)/
count(DISTINCT Month(`License Sales Opportunities-CreatedDate`))
Thank you!
Best Answer
-
In the last distinct count, if you replace the month with something like this to capture year
Concat(Month('Sales'),Year('Sales'))
That should allow you to keep your months distinct between years.
Let me know if you have any other questions,
Valiant_Ronin
0
Answers
-
In the last distinct count, if you replace the month with something like this to capture year
Concat(Month('Sales'),Year('Sales'))
That should allow you to keep your months distinct between years.
Let me know if you have any other questions,
Valiant_Ronin
0 -
Worked like a charm, thanks!
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 74 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive