Negative numbers (trending upward for positive direction, vice-versa for negatives??)
Not sure if this would be considered the same as/similar to this inquiry from a few years ago (https://dojo.domo.com/t5/Card-Building/How-do-I-add-a-trend-line/m-p/6573#M344) but we haven't been able to locate a Regression Line section in chart properties within Analyzer to try that (deprecated?).
What we're looking to do is "reverse" the positive/negative progression of the line value scale - instead of trending in a downward direction as the number increases or upward when it decreases, we'd like it to trend opposite depending on what's happening.
EXAMPLE: between March 2018 and April 2018, it went from $41k to 65k and the line trended downward but we'd like it to go in the other direction - then, between April 2018 and the current month (May 2018), it goes from $65k to $15k but that's actually a negative direction, so we'd like it to trend downward instead of up. In both instances, they are negative numbers so we want that aspect to remain the same, just have them trend in the opposite direction.
Does that make sense?
Best Answers
-
My suggestion would be to just remove the negative number. Rather than showing -65k, have it show 65k. The "Negative" can be assumed based on the title of the field. This would get tricky when you have an actual positive value because it would then show negative.
However, that is the only way that I can think to flip the direction of the line. You could modify the currencty prefix setting to "-$" to possibly reduce the confusion.
1 -
Thanks, @ST_-Superman-_, that was a consideration but the manager requesting this wanted to keep it as negative. I'm hopeful that changing the Min/Max in Value Scale (Line) will provide what they want. As always, appreciate the quick response!
0
Answers
-
My suggestion would be to just remove the negative number. Rather than showing -65k, have it show 65k. The "Negative" can be assumed based on the title of the field. This would get tricky when you have an actual positive value because it would then show negative.
However, that is the only way that I can think to flip the direction of the line. You could modify the currencty prefix setting to "-$" to possibly reduce the confusion.
1 -
Please disregard, found that changing the Value Scale Lines (i.e. reverse) would provide what we're looking for. Sorry for not playing around with that more before posting!0
-
Thanks, @ST_-Superman-_, that was a consideration but the manager requesting this wanted to keep it as negative. I'm hopeful that changing the Min/Max in Value Scale (Line) will provide what they want. As always, appreciate the quick response!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive