Content in Tableau Community Forums

Shorcut back to project folder when in dashboard view

tableaucommunity@tableau.com — Fri, 14 Oct 2016 13:14:03 GMT

Quite often i browse throught workbooks within a project folder. I go via workbook, select a view, and see if its updated or anything is due to be fixed. When finished looking at a single view, i need to take to steps to get back to the project.

First: Back to workbook.

Second back to Project.

Then i can check the next workbook. When every click has a couple of seconds lag or more (not sure who to blame for that though), this actually frustrates me a bit, even though is is a minor thing. I can be browsing through lots of workbooks in different project folders. It seems like an user friendly option to have something like this

It would have saved me a lot of time anyway.

Why does my shape settings change when i refresh data source or publish?

tableaucommunity@tableau.com — Thu, 12 May 2016 09:25:02 GMT

I have this dashboard that i am pretty happy with. After some work i managed to create som "alerts" in my dashboard with arrow shapes like this:

But then, when i refresh the data source, the shape go back to default. And it ends up like this when i publish the dashboard... Not really what i was looking for, now was it...

Dashboard after refreshing data or publishing:

I bet there is an easy solution/explanation here, but i cannot find it. Any help or fingers pointed in the right direction would be greatly appreciated!

BTW: The calc fields that defines shape is this:

if [Table calc totalt]> 0 then 'Oppgang' elseif [Table calc totalt]<0 then 'Nedgang' else null end

with table calc totalt beeing this:

(ZN([Calculation4]) - LOOKUP(ZN([Calculation4]), -1)) / ABS(LOOKUP(ZN([Calculation4]), -1))

Market basket analysis - how many did only buy the one product?

tableaucommunity@tableau.com — Mon, 04 Apr 2016 06:14:44 GMT

Hi!

Been browsing through the market basket kb and forum, and it has gotten me quite a distance. I have a classic market basket situation; I have been self joining sales for a given period of time to see "If you buy product A - what other products do you buy?". That question I can answer with a classic matrix like in the market basket knowledge base article. So I know that 50 % of the ones buying A also buys B. And 50 % buys C. But I want to answer the question: How many customers bought product A only? This part I havent been able to incorporate in a good way. Ideally one would want an additional column with "No other products", but I guess a separate view aligned in a dashboard will do the trick. Any good hints as to how i should approach this will be appreciated.

EDIT: The issue is updated in my reply to Joshua. It was a bit more to it.

Fred

Appending tables - union all with 3 tables

tableaucommunity@tableau.com — Fri, 21 Dec 2012 14:15:26 GMT

Hi!

I have an excel spreadsheet with 3 different sheets. Columns are the same, but content are different (a clientID would be found in one of the sheets only.) The amount of data makes me unable to append them in excel. Using the union tip in the FAQ section, i manage to append two tables, like this:

SELECT [Bankkunder$].[BANK] AS [BANK],
[Bankkunder$].[KUNDENUMMER] AS [KUNDENUMMER],
[Bankkunder$].[POSTNUMMER] AS [POSTNUMMER],
[Bankkunder$].[POSTSTED] AS [POSTSTED],

"Bankkunder" as [Type]

FROM [Bankkunder$]

UNION

SELECT
[TABLEB$].[BANK] AS [BANK],
[TABLEB$].[KUNDENUMMER] AS [KUNDENUMMER],
[TABLEB$].[POSTNUMMER] AS [POSTNUMMER],
[TABLEB$].[POSTSTED] AS [POSTSTED],
"TABLEB" as [Type]

FROM [TABLEB$]

And this seem to work nicely. But how do i get my third table added? I tried to add another union, similar to the ones above, but didnt seem to work. And SQL is not really something i know.

Any help would be appreciated :-)

Fred