CODEWITHSUNDEEP
tableau-api
Kapil Lehar
Kapil Lehar

Reputation: 81

Sorting Date Field in presence of another date field in Tableau

I have a tabular report in tableau, in which im trying to sort the new ship date in descending order.However the new ship dates are being sorted based on orignal ship date. So if I have more than 1 orignal ship date then all the corresponding new dates are sorted for that orignal ship date set only. I know this looks like a minor issue but im not able to figure out how I can make sure that new ship date is sorted independently.

Here is a screenshot

enter image description here

Sample Output :

enter image description here

Upvotes: 0

Views: 1853

Answers (1)

Fabio Fantoni
Fabio Fantoni

Reputation: 3167

You just have to create a combined field starting from the 2 dates (select both right click and then click create combined field)

Drag it as first value in the row shelf (you can also do not show that header).

Then Sort that value according to New Ship Date like in the screenshot below:

enter image description here

Upvotes: 3

Related Questions