Progress Bar Gauge visuals
Is there any way to change the visuals of the Progress Bar Gauge?
I want to display my data as a percentage but would like to use the visuals of the Filled Gauge rather than the Progress Bar Gauge. I attempted to create my card using the Filled Gauge option but it seems to only show whole numerical values rather than percentages.
Best Answer
-
Case statements are helpful in situations like this where you want to conditionally add things together.
SUM(CASE WHEN `IsRead` = 'True' THEN 1 ELSE 0 END) / COUNT(`Username`)
Essentially we're saying give me a 1 if IsRead is True otherwise give me a 0 and then adding all the values together.
This should allow you to calculate your percentage without having to process it through an ETL and stripping out the False values.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hi @Hedger
Have you tried formatting your column as a percentage in the Filled Gauge card column properties?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hi @GrantSmith
Yes I tried that but it just changed the numerical value from 1220 to 1220% out of 1750%
Data wise the Progress Bar converts the values perfectly to the percentages it just looks a bit boring
0 -
Ah, so your data isn't a percentage but an actual number. Have you tried using a beast mode to calculate your percentage and use that as your value? Your target would need to be a percentage value as well so they're on the same scale.
I don't know the fields you're using but a simple beast mode like the following should work (just change your numerator to be the column which identifies where you are and the denominator to be where you need to be):
SUM(`Available`) / SUM(`Total`)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
You can also just set the target value under your chart properties: General > Target Value. If you're wanting 100% use 1.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
It may be a little more complicated than that
Both the columns I am working with are text columns. One is named IsRead and contains True or False the other columns contains unique usernames.
I attempted to use a Beast Mode to count the total True statements and ignore the False statements but I'm fairly new to Domo and Beast Mode so couldn't get this to work so instead I removed the False statements from InRead so they were blank in the ETL. I then did a count of for that column so it totaled the True statements then did a Count of the Username column for the Max Value to get the total number of users. This calculated the percentages correctly
If there is a way to recreate this using Beast Mode in the Filled Gauge that would be perfect but I just don't have the knowledge of Beast Mode statements to pull it off.
0 -
Case statements are helpful in situations like this where you want to conditionally add things together.
SUM(CASE WHEN `IsRead` = 'True' THEN 1 ELSE 0 END) / COUNT(`Username`)
Essentially we're saying give me a 1 if IsRead is True otherwise give me a 0 and then adding all the values together.
This should allow you to calculate your percentage without having to process it through an ETL and stripping out the False values.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Thanks @GrantSmith that seems to have worked
I wasn't far off with the Beast Mode statement. Just missed the / COUNT(`UserName`) at the end.
Thanks for all your help.
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive