Forum Discussion
sorting columns
Check the datatype of your 'batch sort' field. It should be Number.
Usually if the data type of sort field is Text, then it sorts as you have shown in the screenshot
160475 Thanks for sharing your query. For sorting the data correctly follow the steps below:
1. Goto the data view
2. Change the data type of BatchSort to Number
3. Select the column (i.e. BATCH) and then click on the dropdown "Sort by column"
4. Select BatchSort column from the drop down
5. Now, goto the report view and the data should be sorted as expected in the table visual
NOTE: If the data is still not sorted, then you need to perform additional step, on the table visual select the Sort By as shown in the below snapshot.
|
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you ! Good Luck 👍 |