Monthly Percent Change in Opportunities
I am trying to create a line+grouped bar card where date is set by month to show the % change in opportunities overall at the same times as the count of opportunities.
The grouped bars measure how many opportnities were created by channel i.e., each bar represents how many opportunties came from digital, referrals, etc.
The light blue trend line in the attached image currently shows the total number of opportunities and as a result it is simply the sum of all opportunities created from different channels.
What I want to do— and I am not even sure if it's possible— is to use the datapoints of the line to calculate the percent change in opportunities each month. I know that there can be two measures for the y-axis, and I need the left to be the % change and the right hand side to be the count of opportunities. Setting up the axes is not my question, but rather how I can use cases for the month to calcualte this. The issue is that I do not have a measurement for total number of opportunities by month; it is being generated when I set the COUNT of opportunities into the graph
pseudo-code which describes what I need:
"percent change this month"
100*[(count all opportunities in thismonth - (count of all opportunities in thismonth-1)) / count of all opportunities in thismonth-1]
Comments
-
Hi,
Anyone help out with this request?Thanks,
0 -
Hello mfaas,
Thank you for reaching out to Domo Support in regard to your card. In order to assist you as much as possible, could you please provide me with a direct URL to this card within your Domo environment? Also, could you please specify what the expected values for these months would be?
If this is considered a high priority, then please call our number and reference the following ticket number:
Ticket: 05665906
1-801-805-9505
Have you been looking for a 1-stop shop for all your support cases? This message and all updates to this case can be tracked in the Customer Portal at support.domo.com. This portal makes it easy for you to track, update, and create all your support cases!
- Domo Technical Support
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Should I send the link as a direct message or post it on this post? Will you have the permissions to look at the card?
0 -
Edit: post sent as direct message
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive