#Tableau

[@cococnk388]

Gréât trick as usual

[@davebluiis8708]

thanks for all the amazing content!
can you please show how to sort a table by more then one column?
in sql one would do order by 1 asc,2 desc etc
how do one do it in tableau?
Thankss!

[@vizwiz]

Can you be more specific?

[@davebluiis8708]

@@vizwiz absolutely.
so lets say we have a table ,first column is a name of a person
second column is height
third column is weight
so for example
name, height, weight
joe,180,100
jane,180,65
jeff,170,88
jon,165,99
jerry,180,101
i want to sort or order the names by the first column,however>
we can see that the height column have 3 cases of equal values, in this case id like the names to be sorted by the 3 column, the weight
end result would be>
name, height, weight
jerry,180,101
joe,180,100
jane,180,65
jeff,170,88
jon,165,99
we can see that the table is sorted by the height column and in case where the height is equal we sort by the weight.
i hope i explained plainly :)
Thanks!

[@vizwiz]

@@davebluiis8708 In this case, I would either use two rank calcs or I would duplicate the name field, put that in the column as well, then do a nested sort. The first name by height, the second name (the copy) by weight. Then you can hide the extra column.

[@joefromdc]

Thanks for the video. If possible can you please provide some help. I am trying to calculate the total forecast for this year right now 1/1/2022 to 3/31/2022. Than 4/1/2022 to the end of the year. Thanks for any help 😭 I can not seem to grasp date calculations well