Sunday, 16 February 2014

Sorting in Tableau

Sorting:-

In Tableau, sorting a data view means arranging dimension members in a specified order. Tableau supports computed sorting and manual sorting.
• Computed Sorting
• Manual Sorting


Computed Sorting:-

Sorting dimensions in a computed manner follows these rules:
• You can sort any discrete field after it has been placed on a shelf (except the Filters shelf).
• Each dimension that appears on a worksheet can be sorted independently of any other dimension.
• The shelf location of the dimension determines the component of the data view that’s sorted. For example, if the dimension resides on the Columns shelf, the columns of the data view are sorted for that field. If the dimension resides on the Color shelf, the color encodings are sorted.
• Sorts are computed based on the values of the filters and sets in the view. Refer to Groups for more information.
• Sorted fields are identified with bold names.

Continuous fields are automatically sorted from lowest number to highest number (as indicated by the axes) and you cannot manually change the sort. However, you can reverse the order of an axis using field specific formatting.


Manual Sorting:-


  • Manual sorting allows you to rearrange the order of dimension members in the table by dragging them in an ad-hoc fashion, giving precise control over how items appear next to one another in tables and in legends. It also gives you control over the order in which data is drawn on the screen. This control is useful when comparing specific pieces of data or interpreting overlapping data. Manual sorts can only be applied to discrete fields including a discrete measure.
  • There are two ways to manually sort the data in a view. You can either select items in the view and use the Sort toolbar buttons or you can drag and drop headers in the view.
Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks