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.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