Sort and Hide in a pivot
Hello Team , Pls check below formate and Q's and let me know the solution ASAP
1) I want to order the data in a period column from Jan to Dec , it's calculated filed based on Date column from the data set. When I sort it's going by alphabatic order instead of 1, 2,
2 ) How to hide a row in pivot.
Sample Example :
Period | 19-Aug | 19-Jul | 19-Jun | I want to order this data, it's calculated filed based on Date column from the data set. When I sort it's going by alphabatic order instead of 1, 2, 3 | ||||||||||||||||||
Company | Amount | Amount | Amount | Amount Total | I want to hid this row in pivot | |||||||||||||||||
ABC | 1234 | 1242 | 356 | 55454 | ||||||||||||||||||
DFD | 12121 | 78754 | 231 | 454 | ||||||||||||||||||
ERE | 2434 | 453 | 3434 | 45454 | ||||||||||||||||||
Thanks
JK
Comments
-
Are you using the Pivot tables? You should be able to use the actual date field as your Columns and then select "graph by" Month.
I'm not sure about your second question. I don't think there is a way to hide those labels.
1 -
Thanks .Graph by Month will give me 2019-Jan but I want Jan-19 like that , I used calculation field to get values like Jan -19 as string , when I sort it goes by A,B order.
2nd question is to hide the name of the column which is a measure which is called amount in my example.
Thanks
0 -
You should be able to sort by just placing the date field in the sort section. Even if you are using the beast mode calculation as the label.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 104 SQL DataFlows
- 640 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 769 Beast Mode
- 72 App Studio
- 43 Variables
- 718 Automate
- 185 Apps
- 462 APIs & Domo Developer
- 57 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive