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]
Anyone help out with this request?
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:
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 message0
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 80 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive