Select the position of the totals row on a sumo pivot
There are 2 cards, both sumos with almost identical fields: Y-Axis by Customer, X-Axis by Date, Values are a count of a text value. These are the same between the cards, but one card has a row of totals at the top and the other has the totals at the bottom. How can I change these positions? I would like them both to appear at the top.
Best Answer
-
So that top row on the "What we want" image is actually a count of the blank or null values in your pivot.
To get your second example to do the same behavior, you would need to do something like this to your data:
SELECT `CustomerName`, `Date`, `SubmissionID` FROM CustomerSubmissions
UNION ALL
SELECT '' AS 'CustomerName', `Date`, `SubmissionID` FROM CustomerSubmissionsThis would "re-select" the same fields, but with blank customer names, and append them to your dataset. That way when you do your pivot, it would show that top blank row and it would be a 'Count' of the top blanks by each date range. That should mimic the behavior you're seeing.
Let me know if you have any questions.
Sincerely,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Answers
-
I'm not aware of a way to move the total from the top or bottom.
Is it possible that you're looking at the Subtotal section as shown in the screenshot from this Pivot View section here? https://knowledge.domo.com/Welcome/Domo_User_Interface/12Sumo_Editor_Layout#Pivot_View
Or is it the Grand Total row itself that you have at the top of Sumo card? Any chance you could include a screenshot of the behavior your wanting?
Sincerely,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
I have attached 2 images. The first is what we are looking for: the top row containing the aggregated totals within each column. The second is not shoing those totals, but the structure of the card is identical, they just use different datasets.
0 -
So that top row on the "What we want" image is actually a count of the blank or null values in your pivot.
To get your second example to do the same behavior, you would need to do something like this to your data:
SELECT `CustomerName`, `Date`, `SubmissionID` FROM CustomerSubmissions
UNION ALL
SELECT '' AS 'CustomerName', `Date`, `SubmissionID` FROM CustomerSubmissionsThis would "re-select" the same fields, but with blank customer names, and append them to your dataset. That way when you do your pivot, it would show that top blank row and it would be a 'Count' of the top blanks by each date range. That should mimic the behavior you're seeing.
Let me know if you have any questions.
Sincerely,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive