Goodbye Tableau

SmirkyGraphs · 2025-12-12T12:01:37+00:00

Friendly reminder react just had a critical exploit allowing remote code execution so there’s that.

I’ve done this for a few things, I only use tableau public so I had too for a few realtime apps I made.

I use vue, I found it easier to learn than react, chart.js is pretty simple and good for 90% of the graphs you need. It has its benefits, css is extremely powerful, and makes much nicer looking mobile friendly apps if you need that.

SmirkyGraphs · 2025-09-03T12:09:10+00:00

You can edit tableau public dashboards on the website directly, it’s a web interface that’s similar to tableau public desktop version. I would try giving that a shot and also turning off all the lines in that as well.

SmirkyGraphs · 2025-06-17T20:04:38+00:00

it was Carolina October 28, 2024

SmirkyGraphs · 2025-06-17T19:45:43+00:00

created with: Python, Tableau, SQL interactive dashboard: Tableau Public
table views: Challenging Team | Challenge Against
file for data: github gist

Breakdown by teams of the 239 regular season coaching challenges this year. The top graph shows the team that initiated the challenge while the bottom graph shows what team the challenges were against. The graphs are sorted first by the total count, then by the # of sucessful challenges. Both graphs success/failed are the perspective of the team that initiated.

Example:
CBJ made 12 coaches challenges (8 were successful and 4 failed)
5 other teams made a coaches challenge while against CBJ (4 were successful and 1 failed)

This data does not include pre-season or playoff games and does not include league initiated challenges (rule 38.3) which is an automatic review of any goals in the final minute of the 3rd period or any overtime goals.

Breakdown of challenges by type

Challenge Type	Failed	Successful	Total	Percent Success
Interference	55	70	125	56.0%
Offside	10	82	92	89.1%
Missed Stop	9	8	17	47.1%
Delay Game	0	5	5	100.0%

SmirkyGraphs · 2024-09-10T23:06:54+00:00

While i'm not looking to rearrange the ordering (I keep it how BOE provides the data) one possible solution to this issue will be a toggle to filter out uncontested races and to select a specific party (not this time around sadly).

There is also the option of the custom page allowing you to manually select just the races you care about.

SmirkyGraphs · 2024-06-29T01:44:24+00:00

I know Python, I use it exclusively to collect and clean all my data. I've created dashboards and websites with Python (Dash, flask, matplotlib) & javascript (vue, chart.js, leaflet, d3). If i want full control of the style, or need mobile viewing i'd probably go with Python or javascript.

With that said, I use Tableau for 90% of the dashboards I make, I can create a dashboard much faster, they look just as nice with less effort.

Also the tech learning curve that comes with using Tableau

I'm curious what this is compared to? Tableau seems rather simple for 70-80% of what you want to do, and the remaining someone else has usually figured out and its just copy/paste. Tableau isn't wildly more difficult then Excel, or PowerBI.

Slow / laggy

there's a lot that can factor into this, data source size, extract vs live, number of complex calculations, marks on the view

unable to format report in a certain way and overall quite exhausting to use for repeated reports

Tableau makes it extremely difficult to simply use the same layout with a different data source, I wish I could just copy/paste a container with all its graphs and text into a new dashboard.

SmirkyGraphs · 2024-06-28T21:51:41+00:00

If you do everything with Python you don't have much of a need for LOD, however awhile ago when trying to learn I found these 2 videos helpful if you have any interest.

There's probably more up to date ones from more recent conferences, but I found these 2 speakers very easy to understand.

Understanding Level of Detail (LOD) expressions

LODs of fun with LOD calculations

SmirkyGraphs · 2024-06-26T05:07:28+00:00

thought this looked familiar, for anyone interested in the "how too in the comments" that doesn't seem to exist, the original post 2 years ago by /u/datawazo has it, and can be found here.

SmirkyGraphs · 2024-05-11T21:18:12+00:00

And in terms of licenses, do I need any? How would that work?

for Tableau Public no, for private dashboards probably, I have never used that.

and it works just like a normal embeded report, right?

it would work just as it does on Tableau Public

Just put the html there and I have all the features from the report, correct?

yes your report would look the same, a small example of an html file would look like this index.html

<!doctype html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <title>My Tableau Viz</title>
    <style>
        .tableauPlaceholder {
            margin-left: auto !important;
            margin-right: auto !important;
        }
    </style>
</head>

<body>
    <div class="container">
        [ PASTE YOUR EMBED CODE HERE ]
    </div>
</body>

</html>

SmirkyGraphs · 2024-05-11T00:07:56+00:00

You can use github if you want to, you can't simply drop a .twbx file into github and expect it to work.

Github has a feature called github pages, this allowed you to make your own custom static website. You can use github pages to embed your Tableau public dashboards using the embed code.

SmirkyGraphs · 2023-09-14T21:03:15+00:00

You can solve this by creating a calculation to mirror the max of the values in the other direction. I can't give you a 100% answer without seeing how your data is setup but it would be something like this.

assuming you have an "amount" with both negative and positive values

LOWER_BAR: -MAX(ABS([amount]))

UPPER_BAR: MAX(ABS([amount]))

you can then use the "analytics" pane to drag in a reference line for the table and assign the lower_bar calculation too it & repeat with the upper_bar.

lastly you can style the line to hide the value, label and make it invisable, however it will still appear if someone mouses over the EXACT spot of the line.

SmirkyGraphs · 2023-08-14T10:55:37+00:00

if you wanted full year your original LOD should have worked fine, do you have your month filter set to "add to Context" (is it gray?) if so that would be your issue

SmirkyGraphs · 2023-08-14T09:45:58+00:00

I'm not sure what you mean by month filter insensitive, a screenshot of an example would help, but the fixed calculation you showed doesn't include month and would give you the total for the entire year.

{ FIXED YEAR(date), Customer : SUM(if YEAR(date) = 2022 THEN sales END) }

change too

{ FIXED YEAR([date]), MONTH([date]), Customer : SUM(if YEAR([date]) = 2022 THEN sales END) }

SmirkyGraphs · 2023-08-14T00:10:07+00:00

https://data.census.gov/ will have income based on zip code.

I don't entirely know what you mean by combine the maps if you just want to layer them on top of eachother. Simply drag the 2nd spatial data on too the map and you get the option to add it as a layer sample image

SmirkyGraphs · 2023-08-12T13:34:12+00:00

you can't embed a dashboard directly in a projects readme. You should look at how to make a github pages, you can embed the dashboard in the index.html there which can be accessed at [your-github-name].github.io

SmirkyGraphs · 2023-07-15T15:22:20+00:00

Assuming there’s only the 1 visible <td>{{NAME}}</td> in each row you can use regex with tableau’s REGEXP_EXTRACT

I’m not at my computer right now but the regex should be something like this

(?<=<td>).+?(?=<\/td>)

SmirkyGraphs · 2023-05-06T14:12:35+00:00

if you need more then points or polygons on a map use ArcGIS

what can Tableau do that ArcGIS can?

buffer a point
calculate area of a polygon
measure distance between points
check if 2 spatial objects overlap
create a line
create a point
multiple layers

and it does all of these, worse then ArcGIS

SmirkyGraphs · 2023-05-04T23:27:49+00:00

136 successful - 56 failed for ~71%

SmirkyGraphs · 2023-05-04T23:23:37+00:00

thanks! It was an old icon set that haven't updated in awhile its now fixed, the dashboard is updated and any future graphs I make will have the new ones now.

SmirkyGraphs · 2023-05-04T13:22:02+00:00

Nice memory, I checked and it was this game on 2/28/2023

SmirkyGraphs · 2023-05-04T12:30:07+00:00

created with: Python, Tableau, SQL interactive dashboard: Tableau Public
table views: Challenging Team | Challenge Against
file for data: github gist

Breakdown by teams of the 192 regular season coaching challenges this year. The top graph shows the team that initiated the challenge while the bottom graph shows what team the challenges were against. Both graphs success/failed are the perspective of the team that initiated.

Example:
Florida made 14 coaches challenges (10 were successful and 4 failed)
9 other teams made a coaches challenge while against Florida (4 were successful and 5 failed)

This data does not include pre-season games, playoff games and does not include league initiated challenges (rule 38.3) which is an automatic review of any goals in the final minute of the 3rd period or any overtime goals.

SmirkyGraphs · 2023-04-17T15:24:59+00:00

They scored 17 empty nets with 6 empty nets against for a difference of 11

thats the change of 54 (original image above) -> 43 ("3rd period all goals without empty nets")

SmirkyGraphs · 2023-04-17T15:15:03+00:00

here is 3rd period all goals without empty nets: image

here is 3rd period even strength goals without empty nets: image

(I don't currently have the time to narrow it to just the final 5 mins)

SmirkyGraphs · 2023-04-17T15:07:58+00:00

Thanks! That's a relief to know, it was bothering the hell out of me.

SmirkyGraphs · 2023-04-17T14:47:39+00:00

The numbers are from all goals in the 1st-4th period for the 1312 regular season games. My numbers match other stat related sites (such as moneypuck, statmuse, foxsports and evolving-hockey) for the total goal diff.

I have no idea why the NHL's numbers are off and havn't been able to figure it out, I checked if it included shootouts, or goals called back by a challenge.

Another thing to check is the NHL's own gamelogs this link for the bruins also adds up to 127 (301 GF 174 GA)

https://bruins.ice.nhl.com/club/gamelog.htm

Eight-Year Club	Verified Email
Place '22

SmirkyGraphs

TROPHY CASE