Budget Amount and Gauge Card Setup
Hi,
We have 4 sales regions, each with a different budget amount. I want to replicate a report in Tableau that has dials showing how much each region has used of their budget month to date and a Total one showing them all combined. Each row of the dataset details an expense for a labeled region. The budget amounts are not stored anywhere.
1) Should I add the budgets to the dataset as a consistent column or make a beastmode? They may change quarterly.
2) I want to see the total $ amount spent and % of usage MTD for each region inside the circle. I have not seen this done for a donut, is it just possible in a filled gauge? How can I get the % to show?
3) Does each region need to be its own card, or can all the gauges be on one card?
Thank you for your help,
Angela
Answers
-
Angela,
Store your budget in a Webform or Google Sheets (two columns, amount and region name) then append (UNION) that data to your transactions. This way when the Budget amount needs to change you can just alter a webform. Very easy.
2) I want to see the total $ amount spent and % of usage MTD for each region inside the circle. I have not seen this done for a donut, is it just possible in a filled gauge? How can I get the % to show?
Consider a different visualization. If you had Spend and Budget or Spend and % of Budget Spent in a table card or a flex table, you'd communicate the same information in a more concise way. A gague is nice eye candy, but if you just had the donut it doesn't actually communicate the data with the same specificity of the % value you're trying to calcualate.
3) Does each region need to be its own card, or can all the gauges be on one card
See above recommendation to use a table card or a flex table or a bullet chart even.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thanks Jae!
The Webform is working out great!
For the visualization, my manager prefers the donut or the gauge since the flex table with the bar or line charts show the trend instead of the current status, which is what he is focused on. I do really like the amount of detail it holds in a concise space. Can the flex tables have a gauge for the visualization portion? I could not find any documentation for that combination.
Thanks, Angela
0 -
Hi @AJ2020
Flex tables can only support a bar chart or a line chart for the visualization. If you must use a gauge and can't use a flex table then you'd need to create a dashboard with all of the different visualizations / cards you'd need.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hi @jaeW_at_Onyx and @GrantSmith ,
I did some poking around with the flex table and think the "Horizontal Single Bar" graph in the flex table would be a good solution, but I cannot figure out the correct fields for the single bar. Ideally, the table would look like the below with the chart showing the % of the budget for that region used. Are custom columns like the last 3 shown possible? How close can I get to this?
Thanks,
Angela
0 -
Hi @AJ2020 ,@jaeW_at_Onyx and @GrantSmith ,
I did try to find a solution for the above posted problem and I was able to get it done using a HTML table. Below I am attaching a screenshot for the table card and beast mode using which I have created the card.
Beast Mode for Graph Column :
CONCAT(
'<div>
<div style="width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;Text-align:left;float:left;color:#5D5D5D">
<b>0%</b></div>
<div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">
<b>20%</b></div>
<div style="width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;Text-align:left;float:left;color:#5D5D5D">
<b>40%</b></div>
<div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">
<b>60%</b></div>
<div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">
<b>80%</b></div>',
/*<div style="background-color:#ffffff;Text-align:left;Width:',(`Budget` / `Budget`)*0 ,'%;float:right">
<b>100%</b></div>*/
'</div><br>','<div style="background-color:#224D75;height:10px;width:',(SUM(`Used`) / AVG(`Budget`))*100 ,'%"></div>')
Beast Mode for %Used Column :
case
when (SUM(`Used`) / AVG(`Budget`)) * 100 > 100 then CONCAT('<font color=#fa5e5e>','<b>',ROUND((SUM(`Used`) / AVG(`Budget`)) * 100,2),'%')
when (SUM(`Used`) / AVG(`Budget`)) * 100 < 100 then CONCAT('<font color=#226F78>','<b>',ROUND((SUM(`Used`) / AVG(`Budget`)) * 100,2),'%')
end
Do let me know if you find this useful.
-
Thanks,
Anas Ahmed
6 -
@AnasAhmed Thank you for sharing this!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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