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.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
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.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive