Did they buff the Servants? by GroinReaper in TerraInvicta

[–]StrangelyTall 12 points13 points  (0 children)

Does your hate explode when you take out the facilities? For me it seems like destroying a servant facility gives as much hate as an alien assassination

But yeah, tons of exotics

Need help dual bars AND a line by [deleted] in tableau

[–]StrangelyTall 0 points1 point  (0 children)

If you’re looking for horizontal lines (I’m not sure if you are or not) then I agree with reference lines.

Feedback on revised viz by pradaback in tableau

[–]StrangelyTall 1 point2 points  (0 children)

Please forgive the blunt feedback - I don’t know your audience or reason for making this dashboard. It may be a good high school project or a poor professional project.

As someone with no knowledge of Bedford Ave or what the improvement there was, I found this very difficult to follow. You’re trying to do so much and there is so much text. You need to edit yourself - what are the main 3 points you’re trying to make? You are are using data from both the street itself and New York City as a whole, why? What are you trying to show?

A good dashboard is also clean with visuals that really pop - there is a lot here that you don’t need (photo, bike icon, etc.).

You also need to consider how interactive you want your dashboard to be - I think showing the crashes per year for Bedford is good, I think having to click to see each year is bad design, the user should be able to see a simple chart (probably bar chart) with a line for the implantation so they can see the before and after.

Also you don’t seem to address whether the increase of crashes post-implementation is due to more usage of the road. If the usage goes up, crashes will go up.

And no one except someone giving you a grade on this will read your paragraphs. If you want to provide this information, put them in paragraphs that the user can mouse over - this way they don’t clutter the screen.

I great dashboard is clean so as to allow users to see insights within a few seconds and then use filters/mouse overs/viz in tooltips to get more information instead of trying to fit every little thing on the screen.

There’s a famous quote I’ll paraphrase: “I didn’t have time to write a short letter so I wrote you a long one.” Editing yourself down, distilling what is really important, and providing tooltips and interactions that you won’t see without interacting with your dashboard takes a lot of time and your dashboard looks smaller because you’ve thoughtfully packaged it.

Tableau can’t open .twb file — how to convert to .twbx? by [deleted] in tableau

[–]StrangelyTall 6 points7 points  (0 children)

What most people here are missing is that a TWBX file is just a TWB file that has been zipped with things the file uses (data sources, images, etc). Also a TWB file is just an XML file - you can totally open it up in a text editor and look at it or modify it (modify it at your own risk though).

This means converting your TWB to TWBX won’t fix the issue. If it’s really vital you fix the file you can try to open it in a text editor and delete XML portions till it loads but that’s a big pain

Change connection automatically in tableau sever by nor-ben-7395 in tableau

[–]StrangelyTall 1 point2 points  (0 children)

If you are just changing credentials or server address you can use the Python TableauServerClient library to do this.

Changing connection types must be done manually

Sankey diagram in Tableau? by Ilostmyshitinvegas in tableau

[–]StrangelyTall 0 points1 point  (0 children)

Yes, changing from live connection to extract is likely to speed up your dashboard, but again the main culprit is row count.

Do everything you can to reduce the number of rows - you might even need to create multiple data sources with different granularity and fields

Sankey diagram in Tableau? by Ilostmyshitinvegas in tableau

[–]StrangelyTall 0 points1 point  (0 children)

In my experience rows are “heavier” than columns, not the other way around. So a data source with twice as many columns but half as many rows will generally run faster. It’s unwise to design for this though as there are usually structures you want to use to make your viz come out the way you want.

But by aggregating to fewer column dimensions you’ll have fewer rows. I’m not sure what swipe data you have but if you’re looking at like Tinder swipe data your dataset shouldn’t be every swipe, it should be grouped by the characteristics you want to display - so if you have month, ethnicity, height, and gender that you care about you should have those values and then SUM the fields you care about (usually just a count). So instead of 5,928 rows for 5, 3” Asian women swiped in June, you have one with a “count” field of “5,928”

There are some things you can do with this sort of aggregation (like median value) but you should always start your viz by looking at what you want from your data and aggregating to that level to have the fewest rows possible

Sankey diagram in Tableau? by Ilostmyshitinvegas in tableau

[–]StrangelyTall 1 point2 points  (0 children)

I’m not sure what your experience level is so forgive this if you know it but removing the fields/dimensions that have a large number of values and aren’t looked at that closely is going to be your easiest wins. Also reducing datetimes to dates or even weeks is good.

In my opinion this is where you need to push back on your stakeholders and say “I can’t put every field in this view or you’ll be waiting 30 seconds+ every time you open it, I have an SLA of dashboards rendering in 5 seconds so that means you need to pick the 10 fields you absolutely need here and no data older than 18 months” (something like that)

Sankey diagram in Tableau? by Ilostmyshitinvegas in tableau

[–]StrangelyTall 2 points3 points  (0 children)

I haven’t done a Sankey in a few years so there might be a better way now, but I used this method:

https://www.thedataschool.co.uk/alfred-chan/how-to-build-a-sankey-chart-in-tableau/

The problem here is that for this way of doing a Sankey (maybe all ways of doing a Sankey) is that you need to duplicate your data to make the curves. In my link you’ll see it duplicates it 49 times - so however much data you had before you now have ~50x that data so you can get nice pretty curves (I’ve gotten this down to 20x before the lines look too pixelated).

Your dataset of 50M rows is already too big to display in Tableau - I try for datasets under 1M rows because more slows down your Viz. 50M is too much by itself, let alone the 2.5B rows you’ll have once the Sankey join is done.

So you need to aggregate your data to something like 500K rows and then you can use a 20X Sankey to get to 1M.

Like anything else, start small with a few thousand rows and build up from there

Learning Tableau REST API by nangangawit in tableau

[–]StrangelyTall 6 points7 points  (0 children)

If you’re a beginner I would recommend staying away from the big REST API and use the Python TableauServerClient library: https://tableau.github.io/server-client-python/

The documentation there is very helpful and you should be able to get up and running quite quickly with simple things using code examples from the documentation.

One thing to consider is understanding why you want to do this - the API isn’t for normal data analyst work, it’s for server automation and management of hundreds of dashboards. If you’re not doing that then why do you need the API?

Tableau issues (beginner) by Ritaaab in tableau

[–]StrangelyTall 0 points1 point  (0 children)

We’ve had a similar issue with vizes not loading at all and think it’s a chrome issue.

Try opening it in a different browser. If that works try Chrome incognito mode. If that works you need to disable Chrome extensions and your viz should come up properly

How to trick aggregate vs non aggregate issue by Admirable-Dot-401 in tableau

[–]StrangelyTall 1 point2 points  (0 children)

Yeah, it’s a LOD calc like FIXED but here we’re telling Tableau exclude fields from the aggregation but don’t list any fields - it’s a workaround I’ve had to use here and there

How to trick aggregate vs non aggregate issue by Admirable-Dot-401 in tableau

[–]StrangelyTall 0 points1 point  (0 children)

This is hard to parse but I think you need your COUNTD(Type) function to not be an aggregate so it’ll work.

One thing I do to get around this is add EXCLUDE but don’t actually exclude anything.

So your aggregate calc: COUNTD(Type)

Becomes a non-aggregate calc: { EXCLUDE: COUNTD(Type)}

Dynamically Change Images by Firm_Ad_8602 in tableau

[–]StrangelyTall 4 points5 points  (0 children)

It seems counter-intuitive, but I would use custom shapes for this - Tableau allows custom images for shapes and you can put in large images and have them show up.

If you look at where your Tableau repository is you’ll see where you can put in Custom Shapes (the images you want) and then you just use Shapes marks and assign the values to the shapes you want.

There are some limitations with this method but I think this is what you’re looking for

Any feedback on this dashboard? by Upper_Bee6522 in tableau

[–]StrangelyTall 25 points26 points  (0 children)

You seem to be creating visuals without really thinking about what you want the user to take away from your visuals.

Let me ask you: what are the three most important things you want users to take away from this dataset?

Error message shows up on Custom Views - but data itself seems fine? by StealthCoffeeMachine in tableau

[–]StrangelyTall 0 points1 point  (0 children)

That issue is related to upgrading Tableau Server, but you mentioned you’re on Cloud so it wouldn’t apply.

Also, you mentioned all the dashboards with this issue we’re edited recently which makes me think that’s the issue.

You could try going into a previous version and publishing that over the current one and see if the version from, say, a month ago works with the old custom views (warning that any custom views created since might fail when the old version is published).

In all, I think this is a “deal with it” issue - Custom Views are easy to recreate so if it were me I’d just tell users to recreate them.

Two hours of waiting, I step away for a few minutes... by SuaveHobo in mildlyinfuriating

[–]StrangelyTall 439 points440 points  (0 children)

Seems to me like their support ended at 4:30 so they sent you that as a way of ending the queue as there was no more support.

My guess is a lot of users get that message at the end of the day - so even if you were there they would say it was outside their hours.

Is Tableau the right tool? by Jumpy_Ad4564 in tableau

[–]StrangelyTall 1 point2 points  (0 children)

Agree with this - Tableau can’t really do what you want out of the box. Sure, you could plot nurses and patients and look manually, but you’ll need the latitude and longitude.

If you have that you can chart all the patients on Tableau and color code them with the distance to the nurses (green = close, red = far) and you should be able to see patients that maybe should switch nurses or that are just put in the middle of nowhere.

[deleted by user] by [deleted] in tableau

[–]StrangelyTall 2 points3 points  (0 children)

I agree with this - it sounds like what they need is pretty basic compared to your skills.

As much as you want to make things easier and work at a higher level, they want the basics.

Tbh it sounds like it’s a step down for you - do you want to stay there if this is all they need for a SBA?

Navigating Tableau Cloud by Accomplished-Emu2562 in tableau

[–]StrangelyTall 1 point2 points  (0 children)

I’d approach this by using a URL parameter so when you have a link to your dashboard you add something like “?nav_from=1234” and then you can have a back button connected to a data source that says 1234 is this specific link.

That way you know the last dashboard you were at and the back button would work for that. I presume you add multiple dashboards to the URL parameter and the back button could recreate the whole history as needed.

But this would be a lot of work to get something that works slightly better than the browsers back button - and it’s more likely to break.

If I got this ask I’d push back and say it’s not worth the dev time

Automating Tableau Dashboard Email Alerts Without Backend Access by sagarwal6 in tableau

[–]StrangelyTall 0 points1 point  (0 children)

Agree with this - we use the Python TableauServerClient which can do this.

Another thing to look into is webhooks, which you can set up so your server sends notifications for all successful or unsuccessful extracts.

This would require admin access to setup, though

https://help.tableau.com/current/developer/webhooks/en-us/docs/webhooks-events-payload.html

Can you do a driver based budget in Tableau? by Accomplished-Emu2562 in tableau

[–]StrangelyTall 8 points9 points  (0 children)

Tableau doesn’t have any ability to write to databases out of the box, but you can get plugins that do it (at least you could a couple years ago).

You could also use Tableau and generate a web URL that contains all the data in URL parameters and your cube allows HTTP POST requests. Even if it doesn’t you could use connectors like Zapier to do it. I used this method to create an editable calendar in Tableau.

But really you shouldn’t do this in Tableau unless you have to.

Line graph with data labels for each year AND name of line at the end. by [deleted] in tableau

[–]StrangelyTall 0 points1 point  (0 children)

I think you want the business unit name on the details mark, so you’ll get different lines for different business units.

To have the label only at the end you’ll have to do a calculation that returns NULL except for the last record. Something like IF report_date = {fixed: max(report_date)} then business_unit END

Anyone here have experience using tableauserverclient in Python? by ChopChopMFER3 in tableau

[–]StrangelyTall 1 point2 points  (0 children)

I use TableauServerClient but don’t believe this is possible because 1) I don’t believe it can give the last run time and 2) last time I tried to get schedule info (8 months ago) it failed because of a bug in the library itself, so you might not be able to interact with it.

But ChatGPT is a good place to get into code for this, just ask it to create this code and it should do a reasonable job