New Pivot Table: Showing highest number per row
Good Afternoon, Experts!
I am enjoying the new pivot table in Analyzer view. I am creating a card where you will be able to show week over week period of sales data listing out all the stores in my data set (see table 1.1).
What I am trying to do is:
- For the given week, have a condition to look for the best week ever for each row and color that row.
- You can do this with excel using the MAX function.
I cannot seem to figure out how to do it. There is the color rules property that you can do conditions but you cannot add in functions to parse for this. Please let me know your thoughts and an approach to a solution.
Thank you all!
Table 1.1
Comments
-
Are you part of a beta or something for the pivot tables? I've been waiting to use it since it was announced and have been bugging my account manager asking when it's coming.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**1 -
Yes, I am part of the beta team. I thought they would have rolled it out later but that does not seem like that was the case.
All that to say, we lucked out, I guess. ?
@guitarhero23 : assuming this was not a pivot table, and let's say a regular table in analyzer view, is there a way to do what I am asking for? Have you done something like that before?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 60 App Studio
- 41 Variables
- 687 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive