Show only Max Values in a chart
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?
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
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
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 466 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 80 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive