Showing percentage gains in bar charts
Comments
-
I'd also be very interested in this, particuarly as a hover option!
0 -
The best way to accomplish this is to use a grouped bar + symbol card type. You can then create a beast mode to calculate the difference between the revenue/bookings. With a bullet chart, the y axis will be the bullet (the percent change in thie case), then then you'll set two series, one as revenue, and one as bookings.
If you have any additional questions, or need help on the beast mode, please let us know.
**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"
Click here to enter to win a free pass to Domopalooza1 -
Would love to jump on the phone and walk through your suggestion quickly. I think I 1/2 understand..... ?
0 -
@fanzini I'd be happy to do that, however today will be challenging just from schedule standpoint. Can we work through as much as possible here, then look for a time to have a call? If you can help me understand your questions in the forum, I'll do my best to work through them here.
Just to give you a little more insight using dummy data, this is how you'll utilize that card for your purpose. The last two series will be your bookings and revenue. The Y axis will be the beast mode that looks at the percent difference between the two.
**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"
Click here to enter to win a free pass to Domopalooza1 -
Hi! I work with Franco and would like to jump in here. I have the chart set up but am having difficulty with the beastmode. Could you help me? I'm looking to see the difference of the two bars, but they are of the same metric (bookings). It's a grouped bar chart, sorted by quarters and I would like to know the year over year comparison. ex. % change from FY15Q1 to FY16Q1.
0 -
Actually, nevermind! I got it! ?
1 -
We have beast modes for our custom FY bookings #s, so where I state the bookings, I actually inserted our beast modes there. To make this short, I've just abbreviated as everyone else's calcs should be different. Also, you would need to set your axis type to percentage. If you don't, you would need to add (*100) at the end of this formula.
(
(Sum
(FY2 Bookings)
-
SUM
(FY1 Bookings)
)
/
SUM
(FY1 Bookings)
)
1
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
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 728 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