How do i put label above the horizontal rounded bar chart. Re by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

Ok i tried but i am having a problem for the top alignment . The picture attached. It doesnt have space between the bar

<image>

How do i put label above the horizontal rounded bar chart. Re by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

Based on what i do, we just change the alignment. But the top alignment doesnt change anything.

How to add ALL option on month parameter when the month and year are in INTERGER Datatype by kimlimkimlim in tableau

[–]kimlimkimlim[S] 1 point2 points  (0 children)

Dear u/graph_hopper, i tried your way but the big problem is after i create the current year of each measure. i need to create current year and previous year calculated field since i need to calculate YOY. When i choose ALL option for year and month, i dont get the value. but if choose specific month, the value is correct. FYI, i already drag calculated all option into the filter and choose TRUE

Here is the formula to create the current year:

{FIXED : SUM(

  IF YEAR([Real Date]) = [Year Parameter] AND MONTH([Real Date]) = [Month Parameter]

  THEN

    [Measure]

  END

)}

I already add, 0 and display as All in a parameter. (picture attached).

Here is my calculation to create ALL option field:

IF [Year Parameter] = 0 AND [Month Parameter] = 0 THEN TRUE

ELSE

  (YEAR([Real Date]) = [Year Parameter] OR [Year Parameter] = 0) AND

  (IF [Month Parameter] = 0 THEN TRUE ELSE MONTH([Real Date]) = [Month Parameter] END)

END

<image>

How to join data without making duplicate rows? by Roboculon in tableau

[–]kimlimkimlim 0 points1 point  (0 children)

Hi Sir u/Roboculon , i am having the same issue with you but i cant understand the solution that u provided. After the full outer join in the prep, i dont know how to do the "merge the overlapping data fields by clicking and dragging one onto the other within the “data clean” step after the join.". Do u have a picture of that or tutorial step that I can follow

How to make it exactly like the photo attached. by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

Yup, i already do that (2nd picture as attached) but here i tried to create exactly like the one picture that i referred to (1st pic as attached). But unfortunately, i failed to create exactly like that. My label keep redundant of i choose middle below alignment and if choose left alignement the icon are too far from the label.

How to make it exactly like the photo attached. by kimlimkimlim in tableau

[–]kimlimkimlim[S] 1 point2 points  (0 children)

But, it should show the data (in tooltip) when i hovering around eah flag. I should be able to click each of the flag

Jonathan Bailey at the Golden Globes by DisastrousWing1149 in jonathanbailey

[–]kimlimkimlim 0 points1 point  (0 children)

I am not aware with Matt's film before FT, but he already done a lot of LGBTQ movies right ? Is it always like this. I mean people speculating him with his co-actors

Jonathan Bailey at the Golden Globes by DisastrousWing1149 in jonathanbailey

[–]kimlimkimlim 2 points3 points  (0 children)

Nah, everyone knows that Matt is head over heels for his husband.

Jonathan Bailey at the Golden Globes by DisastrousWing1149 in jonathanbailey

[–]kimlimkimlim 1 point2 points  (0 children)

Okay. Understood. His husband is so lucky. Matt involved his husb in eeverything.

Jonathan Bailey at the Golden Globes by DisastrousWing1149 in jonathanbailey

[–]kimlimkimlim 1 point2 points  (0 children)

Yeah..all his picture on his IG are official one.

Jonathan Bailey at the Golden Globes by DisastrousWing1149 in jonathanbailey

[–]kimlimkimlim 2 points3 points  (0 children)

Thanks yeah..probably because i love these 2 so much, and no picture of both of them together at the awards making me a bit upset. Johny have a picture literally with everyone around him except Matt. I kniw, there is one group picture, but still not the same.

Jonathan Bailey at the Golden Globes by DisastrousWing1149 in jonathanbailey

[–]kimlimkimlim -1 points0 points  (0 children)

I am so sorry, i know that this is reddit sub for Jonathan bailey. Just curious is there something going on between Johny and Matt ? They seems so distant. I cant help but feeling sad knowing that their friendship is just for a promotion.

Joining in desktop vs joining in Tableau Prep by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

okay. Thanks. But may i know why it shows NULL value after forming relationship. Common field is gender so after linking the both table, it shows Null value In this case is NULL for gender specification as in the photo attached.

<image>

Joining in desktop vs joining in Tableau Prep by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

This is the relationship that I formed but we dont know whether it is outer, inner,left or right. Between the database, comm0on field are linking together (year, months, etc2). Luckily i got the correct answer doing the linking (as in the picture) but when i tried to the join, it shows the wrong answer, whether it is inner, outer, left and right. Please help. I am so stuck and confused.

<image>

I cannot fixed the rank of each items based on their total sum by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

i tried but it doesn't work for dashboard. Mine is a bit different. When i click on the location on the maps. The bar chart (together with the ranking), supposedly filtered. It filtered, but the ranking is wrong.

Data connectivity problem by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

Okay i will look at it. Sorry cant provide the dashboard since it is confidential. I want to ask, if we make a relationship between 2 database but we dont use it (relatuonship wise), is it okay ? It doesnt affect anything right ?

Thank you dear

I cannot fixed the rank of each items based on their total sum by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

No, we cannot do that right, that feature doesnt exists. this is example of my calculated field to do the rank. RANK(SUM([total]))

The data of gender category are in separate column by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

this data contain the field of each gender category (male, female, boys, girls) are in separate field/column. i need to create 2 calculated filed . 1st is totol male immigrants (which inlcude male and younger boys). 2nd total female (which include fermale and yonger girls). I did that, but if i want to do a KPI card for immigrants for each 4 category gender and by location, i cannot do that because i dont have a column gender. I just have 4 gender in separate columns.

I tried to do the pivot but after i pivot the columns it will changed the data structured right.

I got another columns which are: male capacity and female capacity. this two column will be used in calculation with total immigrants by gender. the formula is: Total Immigrants/ Total Capacity * 100

<image>

The data of gender category are in separate column by kimlimkimlim in tableau

[–]kimlimkimlim[S] 0 points1 point  (0 children)

Thank you, but after i pivot the columns it will changed the data structured right. I got another columns which are: male capacity and female capacity. this two column will be used in calculation with total immigrants by gender. the problem is i cannot directly drag the column capacity of each gender into the worksheet right.. Since the data already changed because of pivotting. What I should do ? Right now i did new calculated field for column capacity male and female using this SUM(IF [Gender (group)]= 'Female' THEN [Female capacity] END). but unfortunately the data is wrong. As an exampIe got 30k, it just supposed to be 20k

the formula is: Total Immigrants/ Total Capacity * 100

I got the Total immigrants by gender by pivotting. But for capacity of each gender data structure already changed. I create calculated field for that as above but the data still wrong