facts, tableau can not make range date from parameter

-

 today 2/7/2023,

i use brand new tableau 2023.2

i have issue about tableau date, so i have data transaction, but the date is not complete, the date would be there if there is transaction. so on the tableau would be not complete and we can not flag where is the true (has transaction) and where is the false(there is no transaction) since the data is not complete.

example range date
i thought there is 2 ways to solve this,
  1. by using parameter
  2. restructured data source

nah, sadly tableau can only make 1 day date, tableau can not make date field coming from paramter so there is date would be full.

so, now to solve this i restructured the data source by using recursive programming to generate full date (which i called reference date) and using full outer join to join the source data to reference date.

thank you

SUPPORT MY IDEA

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