alias - Tableau: How to edit aliases, if I use only one source? -


i know can change aliases if have primary , secondary source in use. however, while using 1 source (excel), there's no option 'edit alias'. there alternative, i.e. create calculate field?

specifically: need keep months in order, don't want display digits instead of months names. want change {2;3;...;11} {"october";...;"june"} on axis.

i assume have data similar - @ least regards month_number , month_name.

enter image description here


there few ways want...

option #1 - sort field:

  • right-click on month name field , select sort. within popup, under sort by, check "field" , select field contains number of months. aggregation can minimum or maximum - benign long showing data @ month grain (which are).

enter image description here

option #2 - use , hide number field header:

  • make sure month number field discrete dimension place before month name field on shelf (rows or columns).

  • right click on month number field , un-check 'show header'.

enter image description here

option #3 - create calculated date field:

  • create new calculated field , reference month number field within makedate() function.

enter image description here

  • use new field date , benefit features tableau provides date - including proper ordering.

enter image description here


Comments

Popular posts from this blog

magento2 - Magento 2 admin grid add filter to collection -

Android volley - avoid multiple requests of the same kind to the server? -

Combining PHP Registration and Login into one class with multiple functions in one PHP file -