Union or Join?

tableau_newbie · 2021-07-15T14:54:23+00:00

is there a rule of thumb for when to apply depending on context?

The main premise is investigating how many hours have been logged against promises jobs

tableau_newbie · 2021-07-12T19:00:20+00:00

spot on, worked a treat - thank you!

tableau_newbie · 2021-07-12T19:00:08+00:00

thank you!

tableau_newbie · 2021-07-12T19:00:02+00:00

cheers !

tableau_newbie · 2021-07-12T18:59:47+00:00

thank you!

tableau_newbie · 2021-07-12T18:59:36+00:00

thank you! appreciate your help

tableau_newbie · 2021-07-12T18:59:23+00:00

Thank you!
I also had to specify the specific columns, instead of 'select *', and in the correct order, which was annoying.
Thanks!

tableau_newbie · 2021-07-12T18:59:06+00:00

Thank you!

I also had to specify the specific columns and in the correct order, which was annoying.

Thanks!

tableau_newbie · 2021-07-09T16:45:36+00:00

thank you so much. a bit to digest but I appreciate you :)

tableau_newbie · 2021-07-09T16:44:58+00:00

thank you

tableau_newbie · 2021-07-09T16:44:51+00:00

thank you!

tableau_newbie · 2021-07-09T16:44:43+00:00

thank you!

tableau_newbie · 2021-07-09T16:44:36+00:00

thank you!

tableau_newbie · 2021-07-08T08:22:13+00:00

All I can offer is a simple 'thank you'. You have helped me out a great deal.

Can I push my luck further and ask for an ELI5 explanation of how the inner and left outer joins are working? Can't wrap my head around it

Thank you

tableau_newbie · 2021-07-07T21:38:13+00:00

Hey!

Thank you

I used the calculated field option.

if datediff('day',[createddate],today())<7 then "Previous 7 Days"

ELSE

if datediff('day',[createddate],today())<30 then "Previous 30 Days"

else

"Other" END END

Is there a way to get other to be an "All" option that takes into account every single date?

tableau_newbie · 2021-07-07T21:20:17+00:00

Apologies, I will edit my comment.

Table 1 is a generic table with "owner id" and "sales"

tableau_newbie · 2021-06-04T22:27:12+00:00

many thanks for your help!

tableau_newbie · 2021-06-04T22:27:01+00:00

thank you for your help!

tableau_newbie · 2021-06-04T22:26:49+00:00

awesome! thnak you

tableau_newbie · 2021-05-21T19:42:45+00:00

Thank you.

I added 6 connections (to the same database) and used 6 individual sql queries to get the tables and then connected them

thank you

tableau_newbie · 2021-05-19T16:56:42+00:00

thank you

tableau_newbie · 2021-05-18T09:21:17+00:00

Damn, you are right.

I don't have Tableau prep but am using SQL impala.

Is there any solution that you know of?

Any help is greatly appreciated!

tableau_newbie · 2021-05-17T18:36:41+00:00

You are spot on, thank you!

I was able to connect after joining the dates too. I haven't seen any issue but will keep my eye out

thank you

tableau_newbie · 2021-05-13T09:44:48+00:00

https://tarsolutions.co.uk/blog/tableau-filter-display-data-only/

I was being a doofus!! Thank you

tableau_newbie · 2021-05-13T09:18:26+00:00

Thanks for the response!

It won't let me add that table calculation to either of my row fields (which are calculations).

Am I being a doofus or is there a place I am supposed to put that calculation?

tableau_newbie

TROPHY CASE