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.” -Superman
______________________________________________________________________________________________0 -
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.” -Superman
______________________________________________________________________________________________0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有