Use Gauge : Target + comparison

Hi all,
I am using the Gauge to show my sales results.
But I want to show both a target point and compare it to last month.
Normally the line from previous month is the targetpoint but I want to adjust this.
Is this in any way possible? I also looked at the Comparative Fill Gauge but doesn't seem like the way to go.
Thanks in advance!
Comments
-
I've had success with the Filled Gauge chart type since there is a Target Value field you can use.
- To show last month's sales, use the date options in the card to select "Previous Month" as the timeframe (note that this will only work if you have a Date/Time field in your dataset). Then put your sales field in the "Gauge Values" spot
- To set a manual target, I usually create a Beast Mode with an average function around the value I want. If my goal is 13, I will enter "AVG(13)" in the Beast Mode to avoid aggregation issues. Then I drag the Beast Mode into the "Target Values" spot. Then it will show the target you set in grey.
1 -
Thank you for your reply @MichelleH
I think you might have misunderstood me (or I did).
I attached an image of what I am trying to accomplish.
So although I have 48 sales compared to 54 last month my target is 45.But with the normal gauge I cant compare to last month.
And with the period over period gauge I cant set a target point.
Hopefully it's more clear now ?
0 -
I see, you're looking for a month over month comparison with a target? You can try a Comparative Fill Gauge (Basic) chart like this:
This chart type doesn't seem to like aggregate Beast Mode calculations when I tried it, so it may require an ETL to summarize the data into a single line.
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 665 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 97 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive