tableau can not use hierarchy on the calculation field

-

hello, today 29/12/2023

i'm using brand new tableau 2023.3

i'm oftenly using hierarchy feature when i'm using the identity such as region, state, zip code etc while building a dashboard with tabular mode display.

hierarchy is helpful feature, it can be simply the dasbhoard and it can make clean dashboard, so the complex dashboard can be simple and clean style.

complex dashbaord need some other feature such as parameter as inputed variable from user, so imagine when i am working with 2 identity like outgoing identity and imcoming identity and it has different value each other. it would be nice when it is controlled by paramter, so user can be easily to choose value whether it is coming from outgoing or incoming value.

but here the issue:

tableau can not use hierarchy as value on parameter calculation field

imagine i have 4 level hierarchy, such as like country>region>state>zipcode

i must make at least 4 parameter calculation field:

  1. parameter calculation field for country outgoing/incoming
  2. parameter calculation field for region outgoing/incoming
  3. parameter calculation field for state outgoing/incoming
  4. zipcode calculation field for zipcode outgoing/incoming
the idea is,
tableau can use herarchy as value on the parameter calcualtion field

if the idea is working then, it only needs 1 parameter calculation field,

paramter calculation field for hierarchy outgoing/incoming

it would be like trees which bring its element


thank you, 

bandung 29 december 2023

zikri nurzani 

Location: Bandung, Kota Bandung, Jawa Barat, Indonesia

Comments

Post a Comment

Popular posts from this blog

sorting multiple measure value on tableau, works!

-
Image
tableau sorting the data based on column priority, so to sort multiple measure value just do: i have 1 discrete and 2 continuous value: kcp as discrete pertumbuhanhari% as value 1 pertumbuhanhari as value 2   i want to sort kcp by pertumbuhanhari% ascending first andthen pertumbuhanhari descending second step: 1. change continuous value into discrete value 2.  move the pertumbuhanhari% into first row and then pertumbuhanhari as second row and nama kpc as third row  by default it would be all ascending sorting 3, sort the pertumbuhanhari into desc, by right click on pertumbuhanhari column, andthen choose sort by Nested, andthen choose descending on sort order, and then choose field name which is used, ok 4. FINISH, 
Read more

reset many filters with one action click tableau

-
Image
today 24/6/2023, i use tableau 2023.2 version.  sometimes when we have a lot of filter on the dashboard need to come back to default filter ex: ALL, it is hard to click one by one filter to reset it to ALL, imagine we had 4 or 5 ot even 6 filter, it is hard to deal with it. many filter on dashboard luckly 3rd party has it, you know tableau has extension to deal it, it is FILTER BOOKMARK. filter bookmarks' logo with filter bookmarks, just one click it would reset all filter into default like we start ex: ALL. to do it : go to extension on dashboard search 'filter bookmarks' add it on dashboard configure it (explanation below) finish configuration button style        : to let the result being button with text on it label                     : title text on that button just uncheckbox (ignore) the options formatting  background color: it is background color text button color:it is button color text bu...
Read more

tableau needs upgrade: control parameter by specific user

-
Image
hello, today is 28th december 2023, im using brand new tableau 2023.3 i'm oftenly using parameter on my dashboard, paramter is used for variable inputed coming from user, but this is real question is? who is the user? since tableau can do separate role user perfectly, which can adapt the display with what the user on (it is called user filter) role user access i'm thinking that tableau should upgrade the future, the idea is: paramter can control by specific user otherwise it would be default value, example of boolean value coming from parameter It is importanting tableau to do becasue the feature that tableau can do already awesome, but it would be more perfect if the specific user can set the value of parameter, so the goal is specific user can set the value and specific user can not do it. it would be more efficient for developer, so developer must not use extenal source data (such as like spread sheet) to update data as variable for specific role/user  thank you,  Bnadung, ...
Read more