Show only Max Values in a chart
Hi,
I have a line chart like the one below. For each of the trend lines, I want to show the value when its the max value in that trendline.
For example, in the bottom most trendline, I want to show the value only for "2021-02-09" as its the highest value in that trendline.
Is this possible in Domo?
Answers
-
I'm pretty sure you will need to determine your max value in Magic ETL first by using the group by tile and then join it back to the main dataset so that you have the date that the max value occurred on for that type.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hi @b_rad
Are you wanting just the single point displayed or that value for all of your dates?
If you want it for all of your dates you could utilize a window function to calculate the maximum value.
MAX(SUM(`value`)) OVER ()
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
case when max(amount) = max(max(amount)) over () then 1 else 0 end
would identify the day with the max amount. but i feel like this
would give you the max max on every date. only downside of doing it in ETL is you have to carefully consider, do you want the max for all time or for the range of data you're looking at (which would necessitate
ssecitate the use of windowed functions in Anlayzer, talk to you CSM as it is a feature switch that must be enabled.
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"0
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
- 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