Skip to content

Summary

Team DataFam Tableau User Group meeting 78, hosted by Chris McClellan. Dan Chissick, BI team lead and senior solution architect at Naya Technologies (part of EPAM Systems) in Israel, a fourth-year Tableau Ambassador with 30 years in BI, presents Winning with Data: Building Games and Mastering Tableau, the session that TC26 turned down. It began with recursive parameters: a parameter action whose new value is built from the parameter's own previous value, possible since parameter actions arrived in 2019.2. Since then he has built a memory game, a Sudoku Helper, Minesweeper, Set, Number Stamper and Dobble, all of which he demonstrates. His process: pick a single-player visual game, collect the graphics, design a state parameter (a long string holding the whole game), then build the board, user actions, a randomized start, reset, finish messages, help and a mobile layout. He then walks through the techniques that make them work and that also apply to business dashboards: parameter actions updating several parameters per click, one-equals-one relationships to densify data, the true/false filter action that disables highlighting, string parsing of the state parameter with MID and REPLACE, WINDOW_COUNT to position shapes, FIXED LODs to check Sudoku rows, trellis charts with modulo and integer division, mobile layouts, randomizing on Tableau Public by combining RANDOM with a timestamp and a seed, cosine for random sizes, viz in tooltip, and dynamic zone visibility and show/hide buttons. His orienteering map memory game became his most viewed viz during the 2020 lockdowns, and he invites people to download his workbooks and pull them apart.

Listen to this TUG

Prefer to listen? This meeting is also an episode of the Tableau TUG recordings podcast.

Key points

  • Dan Chissick: a recursive parameter takes its new value from its own previous value plus what the user clicked, which is what makes games possible in Tableau.
  • Every game rests on a state parameter: one long string that records the whole state of play, which calculations parse to draw the board.
  • A single click can drive several parameter actions at once, updating counters, the current and previous selection and the list of found items.
  • A relationship on 1 = 1 to a small table of numbers densifies your data, for example to draw one to three shapes on a card.
  • To stop the blue highlight on click, create true and false fields and add a filter action from the true field to the false field.
  • MID and REPLACE parse a string parameter into cells; modulo and integer division place any object in a trellis grid.
  • A FIXED LOD with COUNTD and SUM can validate a row, column or square, as in Sudoku.
  • RANDOM on Tableau Public doesn't change between visits because the data never refreshes, so combine it with a timestamp and a seed.
  • Dynamic zone visibility and show/hide buttons handle game stages, win and lose banners, and help overlays.
  • Building games is a demanding way to practise techniques you will use in business dashboards, and download his workbooks to see how they work.

Jump to a chapter (24)

  1. 0:00 Welcome to Team DataFam TUG 78
  2. 0:53 Dan Chissick: building games in Tableau
  3. 3:19 The trigger: recursive parameters
  4. 5:40 The games so far
  5. 6:50 Demo: the first memory game
  6. 8:08 The process of building a game
  7. 12:50 The calculations behind Set
  8. 15:14 The techniques
  9. 18:05 Parameter actions and recursive parameters
  10. 21:27 Demo: the improved memory game
  11. 23:49 One-equals-one relationships
  12. 27:03 Demo: Set
  13. 28:23 Disabling the highlight
  14. 31:50 String parsing and the Sudoku Helper
  15. 36:10 Table calculations and LODs
  16. 40:46 Trellis charts
  17. 42:57 Mobile layouts
  18. 45:08 Randomizing and Minesweeper
  19. 49:50 Shapes, color and size, and Dobble
  20. 52:08 Viz in tooltip and dynamic zone visibility
  21. 55:29 Show/hide buttons and Number Stamper
  22. 57:53 Summary and the orienteering game
  23. 1:01:20 Discussion
  24. 1:07:57 Survey and close

Transcript

0:01 Chris McClellan: So welcome to Team DataFam Tableau User Group meeting number seventy-eight. This TUG aims to capture all the in-person and unrecorded presentations and give them a wider audience. So I don't really care where you've presented before, or if you haven't presented before, or a dozen times before. It doesn't matter. Uh, everyone's welcome here. We'll find a spot for you.

0:23 Get in touch, let me know what you wanna present, and we'll find that time slot that matches up with everything.

0:29 Uh, my email is team.DataFam@Gmail.com if you want to do that.

0:34 But today we're watching Dan present Winning with Data: Building Games and Mastering Tableau, um, showing how to build interactive games in Tableau and a whole heap of other stuff to do as well. So, uh, Dan, I'll hand it over to you, and you can take it from here.

0:53 Dan Chissick: Okay. So let's start with, uh… Okay. Start with an introduction, of course. I, I'm Dan Chissick from Israel. I'm the BI team lead at Naya Technologies, um, which is a subsidiary of EPAM Systems.

1:09 Um, so I'm also officially a senior solution architect.

1:15 Um, I've been doing BI for around thirty years, um, twelve of them at Naya. We are a, a Tableau partner in Israel, so much of the work is, um, connected to Tableau. I've worked with over a hundred different Tableau customers, um, consulting, developing, administrating, everything you can do with Tableau. I've, I've written and taught, uh, several or…

1:45 well, all our Tableau courses I've written. I t- I teach most of them.

1:50 I've done all the Tableau certifications.

1:53 Not all of them are current, of course. I, I just keep one of them always, uh, active.

2:00 Uh, currently I'm a consultant because I actually wrote, uh, helped write the, um, the courses for the other ones.

2:09 Um, outside of work… and I count the DataFam as outside of work because that's what I do for fun.

2:17 So I'm married with four children. My sport is orienteering.

2:22 Uh, when I was much younger, I represented my country in, in, ori- World Orienteering Championships, not very well. Uh, we weren't very good.

2:32 Um, I'm a fourth-year Tableau Ambassador. I, I've been judging Iron Viz qualifiers or, uh, been reviewing the Tableau certification exams.

2:46 I'm active on Tableau Public. No viz of the days.

2:51 My design or storytelling, storytelling skills are probably not good enough.

2:56 My, my vizs are mostly analysis, so I've got no viz of the days.

3:02 Um, I've spoken at Tableau Conference, DataFam Europe.

3:07 Um, and this presentation is actually the one that was rejected for TC 2026, which is probably good because I, uh, was prevented by the war from, uh, flying out anyway. So, uh, um, I wouldn't have been able to present.

3:25 Um, the agenda for today,

3:29 um, and we're talking about games. Okay? Winning with games, as, as it's called.

3:35 Um, how I've used games to practice and enjoy Tableau.

3:42 So we'll talk about the trigger, what, what started this, a bit, uh, a bit of history about the games that I've developed, um, the process of, uh, preparing a game, a lot about the techniques that are in use, which is what you can learn from, uh, um, from developing a game, um, summarizing it, and of course, Q&A at the end.

4:05 Um, so let's start. Um, the trigger is what I call recursive parameters.

4:14 So we know what parameters are in Tableau. Um, parameter actions came in in 2019.

4:23 And recursion, th- this is the actual definition. This is my, my original presentation on recursive parameters, which is a- actually on YouTube. Um, it's, uh… I presented it at the analytics TUG, um, and the recording is here. So there's a link where we can watch the… This presentation, by the way, will be in the sh- in the show notes afterwards.

4:46 Um, so recursion occurs when the definition of a concept or process depends on a simpler or previous version of itself. In this case, we're talking about when a new value of a parameter depends on a previ- of the previous value of a parameter. So, um, instead of just using a parameter action to place, um, some sort of value from a dimension, from a measure into a parameter, um, what I'm doing is basing the parameter on the previous version of itself.

5:23 So simplest version would be, let's say, a counter. Okay? Every time you click, the parameter, the counter increases by one, or by two, or by ten, or whatever you want, because you can base it on a, on its previous value. And we're gonna demo this, of course.

5:44 And this was the trigger.

5:47 And parameter actions were released in 2019, um, Tableau 2019.2, and I created my first memory game. This was the first game I thought of, um, and, but I will see it soon, in, uh, November 2019.

6:08 And since then I've been creating games that are quite complicated, so there aren't many of them.

6:13 Um, twenty twenty-one, a Sudoku Helper. We- we're gonna see all of these, but I'm gonna demo all of them.

6:20 Um, twenty twenty-two was the last version, the best, uh, and improved, uh, memory game, where my technique got a bit better.

6:29 Um, Minesweeper in twenty twenty-four.

6:33 Um, Set, also in twenty twenty-four.

6:37 Number Stamper, which was, uh, um, specifically requested by, um, Matthew Miller of, uh, the product. What is he? Director, manager, VP, I don't know, um, from Tableau. So he, he requested this game and, uh, got it.

6:56 Um, and the last one this year was, uh, Dobble, um, and you'll see all of them, uh, in action, uh, in a few minutes.

7:05 Um, let's actually look at the first one. So the first game is, um,

7:12 the, th- the original memory game, and we'll have to scroll down.

7:18 Um, so this is just the graphics aren't very good. I'm gonna click… I'm gonna take down the number of pairs here, because otherwise we won't fi- find anything.

7:30 Click here to start a game,

7:34 and this shuffles the cards. And let's, let's look for matching pairs.

7:41 Okay, I click it. This is just like, uh, overturning the cards in a, in a card game.

7:48 Okay, it's…

7:50 This one's crazy. Ah, good. I found… No, it's not the same one. Sorry.

7:56 Um, this one was.

8:00 Not this one.

8:03 Come on, it was one of them. Good.

8:08 Okay, so it works. I found a pair, and now they will stay uncovered until, of course, I fi- I find all of them and can go on and on and, uh, play. So the graphics here are crazy. I mean, it's very difficult with these, uh, uh, emoticons, but, uh, um, it's a nice game. And this was my first one. Um, you can actually, um… I'll just sh- shuffle it again to restart, and you can change the number of cards you start with.

8:43 Um, you can select the theme. There are different themes. So here I am uncovering flags of countries, and this was my first game.

8:58 Okay. So what's the process? How does this go?

9:03 Um, very quickly because, uh, I can't actually demonstrate this.

9:08 Um, you start with an idea. You need a game. Um, you can invent one. I haven't invented any of these games. They're all existing games.

9:16 Usually, um, you want a game that you can play alone, single player game.

9:22 Um, and that's it. Anything that's visual, that uses visuals, um, can be used.

9:30 Um, as you, as you see, I, I had a few ideas.

9:34 Then I start, uh, collecting the graphics, whatever I need, shapes, pictures. Some of them have a lot of shapes. Um, um, some of them are just two or three shapes. A background, um, logos of games. I, I collect all these.

9:52 Uh, most important thing in the game is what I call the state parameter, the state of a game. There, there's always a parameter. It's usually a very long text, um, a string parameter, very long, uh, string that contains the state of a game. What's the situation now? Even the, um, memory game you just saw, in the background, there's a long parameter which says which card is where, and is it un- and another parameter which says is it uncovered or not.

10:26 And all this goes into… This is what I call the state parameter. This is the basis for, for every game.

10:35 Um, then I develop the game board, the actual visual, which is how I display, um, the game based on that state parameter.

10:48 Um, user actions. These, this is the recursive parameters. I click, something happens.

10:55 Um, could be just like, you know, one type of click like in a memory game. Sometimes it's much, much more complicated.

11:03 Um, very difficult part is randomizing the start.

11:08 Getting it to start with a different layout, diff- shuffling the cards like you saw a minute ago where I, I click on Start Game, and it actually shuffles the cards, places them in, in new positions. Randomizing is quite complicated. I'll go into a bit more detail later.

11:28 Um, you need a reset or restart action, some sort of button to bring it back to the beginning if, uh, the user wants to.

11:38 Um, a finish message. If you finish, you've completed, you're successful, you want some sort of banner to jump up and say, "Great, you've won or lost." You can lose, of course, in these games. For example, Minesweeper.

11:56 And, um, to end it, a help, uh, um, so- some help button where you can get instructions, references to the original versions of a game, um- Uh, if necessary.

12:13 All of this, this is more or less a process of creating a game.

12:17 Usually when I create a game, takes a few months, but that's because I'm doing it in my spare time, an hour here, an hour there.

12:24 Um, there's a lot of work, but it's, it's fun. It's really fun. Once you get started and you're making progress and you start playing around, it's, it's really fun.

12:34 Okay, and at the end, I forgot this one, mobile layout. Some of the games, not all of them, um, if they're small enough, um, I create a mobile layout, uh, so I can play them on my phone, and people do play them on the phone. So, uh, um, and that really depends on the type of game. Memory, um, less, some of the smaller ones, um, you, you can play them very well on the phone.

13:06 This is a really small sample of some of the calculations that go into one of the, um,

13:18 into one of the games. This is actually the Set game, so you can see some of the calculations here. This is, uh, an Excel with a list of the calculated fields.

13:27 Um, there is, there are a lot of calculations.

13:31 Okay? So I'll, I'll just go, just so you understand. This is, um, the Set game where there are 81 cards. So this is the, this is the state, what I call the state parameter, which says which cards come up from the pack in which order.

13:49 This is another parameter which says which are the active cards, the ones you can actually see at the Mo- at, at that moment.

13:57 Um, I'll actually show the Set game because, uh, just if people don't, um, know which one it is or that haven't actually played the game.

14:09 Okay, Set is this one,

14:13 where you have to find, um, a valid set of cards and click them, uh, to create a set.

14:22 Uh, I won't go into all the rules.

14:25 Um, and let's go back to the Excel.

14:30 Um, so there are various, uh, calculations here. I highlighted a few. Time elapsed. It counts how much time has gone on from, um, uh, from the beginning, so you, you know how much time it took you. So I have a calculation for, um, how many minutes and seconds.

14:50 Um, this is one of the important calculations, for example. Um, they want to replace the set. Have I found a set?

14:59 I need to replace it, so I'm actually going to the active cards.

15:03 You can see active cards here. Active cards parameter, and switching some of the numbers to the new cards which are coming, sort of coming out of the pack.

15:16 Um, checking if a set that, if the, the cards that you, um, selected are a set. There's some logic here with the numbers.

15:27 Um, com- Eh, not really complicated maths, but you need some logic.

15:33 This is the randomizing for, for the beginning.

15:37 Um, calculating where a card is, column, row, and location. They go together to, to show you, um, which card is in which spot in the, in this matrix.

15:51 Okay, so I have lots and lots of calculations.

15:54 Um,

15:57 uh, checking if a set is a new…

15:59 There's, there's a lot of stuff here behind the scenes. Just wanted to show how complicated it, it can become.

16:08 Okay? So this is… And now, now let's go into the techniques.

16:12 Okay. So I, I basically went through the major techniques that I'm using in these games.

16:20 Um, made a list of them, and these are my, my games. Uh, I, I talked about all of them except for Tic-Tac-Toe, which is so simple. It's just I used it as a demo in my, uh, presentations on recursive parameters, but it's a very, very simple game. But the others are the ones that I, uh, already mentioned.

16:40 Um, and these are the techniques that the, that I use in the various, uh, games. So para- parameter actions and recursive parameters are the base for everything, and we'll go through all the others. Um, relationships, disabling the highlights, string parsing. There's a lot of stuff here that's very useful in regular presentations, in business dashboards, in, uh, uh, for creating KPIs, uh, calculations.

17:09 Level of detail, of course, trellis charts, mobile layouts, randomi- randomizing isn't really useful in business. But, uh, uh, that, that's probably the only one. Using shapes and color and size, of course. viz in tooltip.

17:27 Um, dynamic zone visibility, show/hide buttons. Everything can be used in regular work, in, in work, at work when we use Tableau. And, uh, of course, playing with games and, uh, creating games im- improves, uh, the technique.

17:45 Um, so before we start, uh, going through the techniques, um, maybe if there are any questions or…

17:54 From anyone?

17:57 Chris McClellan: Uh, no questions. Raj was just saying that he took a screenshot of that last slide.

18:02 Dan Chissick: Oh, okay.

18:03 Chris McClellan: With all the detail in it.

18:06 Dan Chissick: Okay, so let's start. Parameter actions are the basis for the games because games have to be interactive. You click, something happens, the parameters change values, and- And the game moves on. Um, so every click can store the click result, update the state, advance a counter or whatever. And here's an example of one of, uh, um…

18:33 This is a memory game.

18:35 One of the, um, dashboard actions, uh, dialog boxes.

18:40 Uh, you can see every click, if you, if you look here, you can see there's, uh, memory cards. That's when you click on one of the cards in the, in, in the game. So six things happen.

18:55 Okay? When you click on… This is just for a start. This is just for, um, setting everything back to zero. Memory start. Memory cards is the actual game. So you have a counter for the clicks, which advances a counter.

19:10 Um, and there are various, um,

19:15 various parameters that get new values, so it needs to remember what your previous picture was that you clicked on, what the current picture is, um, have you clicked an even number or an, an odd number of pictures, that sort of thing. Everything gets calculated in, so it knows if you found a pair of pictures, and can advance the state of the game according to that.

19:42 Um, and the recursive parameters works basically like this. Okay? I just gave one example here. The new parameter value is based on the previous value of itself, plus what you click.

19:58 So, uh, it's an example. I'm clicking on the cards worksheet.

20:03 Okay? So I have my target parameter is found pictures.

20:09 Which picture IDs, it's a string with a list of picture IDs that I found.

20:17 Okay? And the source field is add to found pictures. It's the one which you can see in the calculation.

20:24 So, um, just again, a, a small example of a logic. So it says, "If even clicks…" Even clicks is a calculation. It's calculating have I clicked an even number of pictures.

20:39 And the previous picture equals the clicked picture. So I found two pictures that are the same, the same, the same picture in a memory game.

20:50 Then found pictures plus previous pictures. So if I found something, I'm adding the ID of that picture to the list of found pictures. It's actually concatenating the, the number via… I don't think it's numbers, it's, uh, it's letters.

21:09 Okay?

21:10 If I haven't found anything, so if the, this, uh, um, um, this doesn't, uh, this is isn't true, then found pictures gets its previous value. Nothing happens.

21:24 I'm just giving it the value it had before.

21:28 Okay? So every time I click a picture, the found pictures parameter either gets no change or an additional picture that was found. That's the idea of a recursive parameter, and every game has some sort of logic that works in this way.

21:49 Okay, so let's do a memory. And, and now that we've talked about it, we'll, uh, demo the memory again. We go back to here and go to the n- the new, uh, memory game.

22:01 The last one. I actually have quite a few versions.

22:06 This is the new and improved one.

22:09 Okay, so you, you have two themes, Africa and f- African animals and flowers. We'll do the Africa one.

22:17 We have, um, a number of pairs. I will reshuffle and restart just in case. And we can look for identical cards. So

22:28 number of clicks is going up by one. This is, uh, one of the parameter actions.

22:34 Now it's got a current picture.

22:38 Now this is the current and this is the previous. They are not identical.

22:43 Um, now what… A- and again, it, it's counting. And now it's, it knows that I have an odd number of pictures clicked, so it's disappearing the previous ones, and I can go on and look for a matching pair. Oh, good, I found the lion.

23:00 And once I've clicked on the two lions, this is exactly the action that I, I display, I demo- displayed before.

23:09 The found pictures is getting its first value, um, the ID of a lion, and it's, uh… Ah, where was it? No, not here.

23:22 I found the hippo as well, and so on.

23:27 Oh, this is also…

23:29 Well, uh, that's a stroke of luck. So I've found three, uh, three pairs already, and I can, uh, go on and of course play it with, uh, 24 pairs as well, not just, uh, not just 12.

23:44 Um, this is the improved memory game, and notice that the main improvement for here is the highlighting.

23:50 So, uh, I've disabled the highlighting that we had with the emoticons earlier, um, and we'll talk about that later.

23:59 Um, okay. Next, uh, technique.

24:03 Um, and if anyone wants to, um, uh, say something, uh, ask a question, uh, it's okay.

24:11 Um, no, no problem with that.

24:15 So, um, next technique is one equals one relationships.

24:20 Okay, so, um- This is what we use sometimes, and again, it's– we use it a lot in business context as well in our data sources.

24:30 This is used to multiply your data points or densify the data. It's been used for a long time. Since we have relationships in– from twenty twenty, it's much easier to do.

24:42 So what you do is you add, uh, to your data source, you add a, a table with numbers or any data that you need. I, I actually have an Excel with numbers which I use all the time. In this case, I'm adding just– I just wanna multiply my data by three, because in the Set game, I need to display one to three shapes in each, uh, in each square.

25:11 And this is done by…

25:13 I, I need three data points in order to display three shapes. So what I'm doing is I'm creating what you might call a cross join. I'm creating a relationship with an additional table. The table has the numbers one to three.

25:27 Okay? So the, uh, the field is called– it's count one because there's another one somewhere else.

25:33 Uh, it has just the values one, two, and three. Relationships is, uh, relationship calculation, one equals one.

25:42 So when I bring this table into play, I can multiply every data point I have by three.

25:51 And

25:53 so, um, and I have some calculations that affect, uh, the number of cards that I see. So there's, uh, some logic. The num is the actual number of a card. There's some logic that says how many shapes this specific card includes. That's the count, uh, uh, calculated field.

26:14 And the count card, which is actually a filter on this, uh, on this worksheet, um, checks that count one less than equals count. So if I have one card, count one will have just one value, and I'll see one shape.

26:32 Um, if I have three cards, count one will have all three values, and I'll see three shapes. And that's the way I can, uh, display several shapes, um, on, on this matrix. Um, of course, it's useful in many other situations. This is, uh, just an example of how I use it in a, in a game. That's, uh, densifying data. It's c- it's called in, in Tableau data file, it's called densifying data quite a few times.

27:02 Uh, and you can find this technique, uh, around. It's quite, quite useful.

27:08 Okay. So I'll actually look at the Set game now.

27:12 Um, go back to my profile.

27:15 Then we, we already, uh, saw it of course, but now, now we'll actually play.

27:20 And in Set, um, there are instructions from Wikipedia, but basically you have to… And I'll start a new game.

27:32 So it shuffles, shuffles the pack.

27:36 You, you have to find, um, sets of three cards that are every feature of that. There are four features for each card. The, the shape, the color, the count, number of, uh, shapes, and the fill. The filling, um, is it empty, full, or half full.

27:58 So every one of these features has to be either all different or all the same.

28:03 So I'll just find a set here. Here, this one. One, two, and three.

28:15 Okay. So this is the set that I found. You can see all the features are the same except for the count, which are all different, one, two, and three.

28:25 And it– and the time is a, is a bug, I know about it, but let's ignore it for now.

28:33 Um, let's find another set just again for we… For example, here, this is a good one.

28:40 Um,

28:43 one, two, and three.

28:46 Okay, and this is a set. Um, the color is different in all of them. The fill is different in all of them. The count is different in all of them, and the shape is the same in all of them.

28:58 Okay? So it's a valid set. If I click on an invalid set,

29:06 nothing happens.

29:08 Okay?

29:09 Um, I won't get the set here. I have to unclick one of them, uh, two of them probably, and go and, uh, look for something which is valid.

29:19 This is the Set game, and the technique I showed before is, uh, is deciding how many shapes to show in each of these, uh, i- on each of these cards.

29:36 Okay. Um, next technique, disabling the highlight. This is a very common complaint. How do we get rid of a light blue highlight that happens when I click on a, on a cell, or on a number, or w- or anywhere in Tableau?

29:56 Okay. There are a couple of techniques that are useful. Um, the best technique, and again, I didn't invent it, of course, I picked it up somewhere. Don't even remember where, uh, who was the first to use this, is the filter true, false trick, which basically goes like this.

30:15 You have– You create two fields, one of them with a value true, and I call it true, and the other one with a value false.

30:25 And then you create a filter action from your worksheet where you don't want the highlight to happen. In this case, it's in the double game.

30:34 Um, so this is the worksheet, card one.

30:38 And the target sheet has to be that same worksheet, but not in the context of a dashboard. So here it's actually in the context of a dashboard.

30:50 Here it's the, the, the separate sheet.

30:55 Um, you put select, you put clearing your selection will show all values, and in the selected fields, you actually point the true at the false. So, um, these are two values that are never going to be the same. So it's sort of filtering by true, goes to the target sheet.

31:16 There's nothing true, so it's undoing the filter, and then so it's gonna show all the values, which is sort of… It's sort of filtering and clearing the selection at the same time, and so there's no highlighting. That's more or less how it works, and that's more or less the logic. I don't know who invented it. It's…

31:37 But it's crazy, and it works.

31:39 Okay? So when, when you click, um, nothing gets highlighted, and it, uh… I've used it in lots of business dashboards, of course, uh, and it works really well.

31:52 Um, another technique.

31:57 Um, next one, string parsing. As I said, the, the… We have the state parameter.

32:04 Um, something like this.

32:07 Okay? This is the one for Sudoku. Sudoku is a grid of nine by nine, um, where you have the numbers that you found and the numbers that you haven't found.

32:18 Okay? So, um, what's the state parameter here? It's a eighty-one-digit number. We've, uh, just put the semicolons to split up between the rows, and you can see that it actually fits. A zero is no number. So you have five, three, zero, zero, seven in the first row. Five, three, zero, zero, seven. Another four zeros. Second row is six, zero, zero, one, nine, five, and so on.

32:47 So this is the, the… what I call the state parameter.

32:50 But how do I turn this into a grid? I have to, um, I have to actually retrieve the data from here. So there's a lot of playing around with string parsing. Um, a cell here is, uh… I have the numbers one to eighty-one. This is the cell, uh, data, you could say. The, um, the ID of a cell. So I… And this is just a small example. Mid, replace, initial cells.

33:22 So I'm taking out a semicolon, so I have exactly eighty-one numbers.

33:27 And then the mid is a sort of substring. So from the, from the location of the cell, take one digit. So cell number one would be mid initial cells one, one, and that's five. That's the first, uh, um, first digit. Cell number eighty-one, the last one, would be mid, again, without the semicolons, initial cells eighty-one, one, which is the last one.

33:55 That's the nine, and that's this one. And that's just the first stage of parsing it and getting, um, getting a number into the grid.

34:06 Okay? And that, and that's, that's an example from a Sudoku. So there's a lot of playing around with string values and parsing the strings in the games.

34:14 Um, let's have a look at the Sudoku game. It's not, not really a game. It's, uh, I call it, I call it Sudoku Helper.

34:24 So this one can actually help you, um, solve

34:30 a, a Sudoku puzzle, um, and it's quite complicated. This is a basic one, but I'm gonna actually choose another one. Okay. And so I can select a few default puzzles.

34:40 I can enter a custom one. So I can enter a value in the parameter if I want to type it in from something that I found in a newspaper or something. It makes it more interesting. Let, let's take the medium.

34:54 Um, apply.

34:57 Okay. So it's changed, um, changed the grid, and it's helping me. It's showing me what numbers are valid in each, uh, um, in each square. I can see that a nine t- the nine is trivial, so I click on the nine in my, um, pad, and I can see. And okay, now I have a three here. That's good.

35:19 Put in the three. So it's, it's really helping me. There's another three here.

35:24 Um, too easy. Nine.

35:28 Um, put a nine here. There, there's lots of other functionality here. So of course you can reset. You can set a… I can set a checkpoint. Sometimes in Sudoku you have to guess.

35:39 I can set a checkpoint and go back to it later, so it'll actually save.

35:44 Um,

35:46 okay. It'll actually save.

35:49 Here's the situation that I actually saved. You can see the black numbers are the ones that were originally there. The blue ones are the ones that I entered.

36:00 Okay. So I can then return to the checkpoint.

36:03 I can turn on or off the help.

36:08 Um, and I have an indication on the side act- for what's what. So, so the, the center square is filled already, so I have a green here, a green box. But of course, if I do something wrong, let's just do something, um, incorrect. I'll put a nine here.

36:24 Okay. And I get a red, um, a red square saying that I've, I've made a mistake, because obviously you can't have nine, two nines in a row or two nines in a column.

36:35 Okay, and there's a help.

36:37 Talk about that later.

36:39 Um, so, um, this is a Sudoku, uh, helper. Um,

36:48 this is one of the complicated ones. I, I really like it.

36:53 Um, okay, next technique, table calculations.

36:59 Okay. There are lots of table calculations. They're useful in all sorts of situations. Here, for example, there's a calculation and w– and we're going back to the set shapes.

37:11 Remember, there was a count that says, do we have, um, one or two or three shapes? I've actually showed the axis here, but I want to locate them in the center. Uh, regular shapes, if you just put one or two or three shapes, they will be, um, aligned to the left.

37:30 Um, I want them in an exact, in an exact location, so I'm using a table calculation window count,

37:39 okay? To, to find out how many shapes I have in each window, in each, in each square.

37:46 So if a window count is three, then take the count. So there, there are three shapes. There…

37:54 The count, uh, the count one, the number is one, two, and three.

37:58 So I'm gonna place them at count one minus two, which is at minus one, zero, and one.

38:07 But if there are two of them, I need to place them at minus zero point five and plus zero point five, uh, around the zero. So I'm gonna take count one, which is gonna be one and two, and minus one point five. And if there's only one, I want to place it on the zero, only on the zero. So I'm gonna– there's only gonna be the one value, so it'll be one minus one, which is zero.

38:35 So I'm using a simple table, and this, again, just an example. There are other really complicated table calculations in my games.

38:44 This one is a simple one using a window count to, to, to set the location of the shapes on, on the grid.

38:55 Okay, level of detail.

38:58 Friend of, uh, of table calculations. Of course, it's one of the core capabilities of Tableau.

39:05 In this case, in Sudoku, and you solve, uh, the red, uh, squares, of course. I wanna check for each row if a Sudoku is unfinished, which is blue, invalid, which is red, or okay, which is finished, this is the green one.

39:21 Okay, so I'm doing– the calculation is fixed on the row because, um, I, I, I check, um, I need to set it for each row, and row is, uh, is a number from one to nine.

39:37 Fixed row. So if a count distinct equals nine, so I have nine distinct numbers.

39:48 Okay?

39:49 And… No, there can't be a zero here.

39:51 Okay, so I, I need count distinct equals nine, and the sum is forty-five. If the numbers are one to nine, like here, always if I have a full row or column, the sum of the numbers will be forty-five and there'll be nine distinct numbers. That's the easiest way I found to calculate it. So then I have a full, a full row.

40:12 Okay, so that's a green one. That's okay.

40:15 Else, if fixed row count distinct

40:20 is less than the count, so you have less

40:28 distinct numbers than you have numbers. So the count distinct here, you have nine, eight, eight, and six.

40:35 Count distinct is three, and the count is four, which means I have one number twice, and that's invalid. That's what I can't do in Sudoku.

40:47 So I get the invalid, and otherwise it's unfinished. There are only three s- three st- three states.

40:55 So this is why I'm using a fixed, uh, calculation, um, to check my, uh, row status. Of course, there's a similar one for column, a similar one for squares, and, uh, various other uses.

41:11 Um, another one, trellis charts.

41:16 Okay. Again, I, I can't teach this technique now. I need a whole course for this.

41:20 But trellis charts are a way we u- we use to create grids on a worksheet, not just, uh, rows and columns, but a combination of them.

41:29 Um, usually the idea is you have some data, and this is in use everywhere, okay? We c- we use it in, uh, um, business dashboards to display, uh, charts on numbers, KPIs. Here we're using it to display pictures.

41:46 Um, the idea is that each picture has an index, a number, and it doesn't have to be a picture. It can be something much more complicated. It b- can be a whole, whole chart.

41:57 Um, but here it's a, it's a picture, it's a shape.

42:02 Um, the index is a number from, in this case, one to, um, s- this one is six, six, and four, so it's one to sixteen.

42:15 Um, and for columns here is a parameter which is telling me how many columns I have.

42:24 Okay, and I, I calculate for each, each picture number index, I calculate in which column it is, index minus one.

42:34 Um, if you don't recognize this, this is a modular, um, operator. It gives you the, um, remainder when you're dividing by a number. So I'm dividing by the number of columns, which is six. I'll get a number from zero to five, a remainder. And this is integer division. It just divides the number, but doesn't give you the, um, non-integer part of a number.

42:59 So, um, index minus one zero, um, modulo six is zero. So that's column zero, and row, and again, row zero of course. But if I take, uh, a-any other number, let's say, um, picture number eight, which would be this one, would be seven modulo six, which is the number of columns. I get one, which is column one. They start from zero, so it's the second one.

43:27 And sev– And divide seven by six also gives me one, which is the second row.

43:34 So this is how I basically locate a shape or a number or any other object in a trellis chart. And this is used a lot, so most of my, uh, games have them.

43:50 Um, again, if you look up trellis charts in Tableau, there are lots of, uh, videos and blogs about it.

43:57 Um, mobile layout.

44:00 Another technique, of course, um, used going into the dashboard layout, selecting a, a phone layout and just placing stuff in a different place. So we saw the set game previously in, uh, in the desktop layout.

44:16 Now we have, um, I, I have, uh, the mobile layout next. I actually play this on my phone in the train sometimes when I'm bored, and I've simply, um, taken out some of, uh, additional text.

44:31 I've placed the, the main grid on top.

44:34 Um, the data is a bit more, um, um, compressed here. And the num– and the sets found, this part is at the bottom.

44:44 Um, but on a, on a mobile phone, you, you just see this, where you can scroll down to the sets found, and you can, uh, look at… You can look and play on the main game, and it's, uh, much more comfortable. So it's a good practice for creating mobile layouts.

45:00 Uh, and you can see by the way here in the layout, uh, mobile layout, you can actually decide which parts of a dashboard can be displayed. So there are lots of, um, dashboard elements here that are, um, unchecked. They don't have a small, uh, blue, uh, mark, so they're, they're not in a mobile layout. There's not enough space, so I simply take them out.

45:23 I, um, I uncheck them, and they're, they're not displayed. And that's how a mobile layout works.

45:32 Um, next technique, uh, randomizing. Randomizing is really difficult.

45:38 Okay. So Tableau has an undocumented random function, which gives you a random, uh, number between zero and one, uh, which works.

45:51 But I need to create a starting state, and I need to make sure the state is different every time a user clicks on Start.

46:00 So, um, usually I take, uh, the current timestamp as well, and I also have some sort of seed, and I, I create some sort of calculation because the random, um, doesn't randomize s- uh, differently each time you open, uh, a dashboard on Tableau Public. Because it's the same data source and the data doesn't update, then, um, the actual random numbers stay the same.

46:33 So if you… If you can– If you could refresh the data source, they would change, but we can't do that on public.

46:40 So I, I play around a bit with the data to get, uh, a different number, still between zero and one. And this is one from Minesweeper. So basically, I'm calculating something, uh, calculating a new random number, create mine.

46:57 Um, checking if it's less than the mine ratio. Let's say I want ten percent of my squares to be mines. So I'm just checking if this random number is less than or equals the ratio, which would be zero point one. And for each cell in the game, I'm checking if create mine. So if it's less than zero point one, then one, else zero.

47:23 Okay. So I either get a mine or I don't. But that's only the start.

47:27 I then… Oh, sorry. I then concatenate them together, um, in a, um, using the previous val– This is another table calculation, the previous value, um, function.

47:44 So, um, Minesweeper, let's say, would have a hundred, uh, um, hundred cells.

47:51 So each one is a concatenation of a previous one plus the new value for that cell.

47:58 And then I filtered them down using another table calculation, last equals zero to the last one, which will be number a hundred, and that's the value that gets placed in the state parameter at the end. Really complicated, but it works.

48:16 Okay? And that's a technique for randomizing. If everyone wants… If someone wants to create a game and gets stuck with randomizing, call me.

48:25 Okay. So let's have a look at Minesweeper, um,

48:32 which is… Which was a challenge.

48:36 Where were we? Hmm. Games.

48:38 Minesweeper was a challenge when I created it. So I can decide how many rows and columns I want, what my mine ratio is, and then I click on Create. That's the stage that we saw now.

48:53 It's created a grid- Okay? Nothing is, is visible, of course. It's not gonna tell us what we have here.

49:00 Uh, this is just showing what I can place there. And when I click start, it finds an empty space, opens it up, and now I can, um, decide to flag something as a mine or to mark it as not a mine.

49:18 So this should be a one. Not sure about this one.

49:24 This is not a mine.

49:26 Anything next to a blank space is not a mine.

49:31 Okay, and now I'm gonna make a mistake on purpose. This is a mine, and I've lost.

49:39 Okay, so again, Minesweeper works, but the randomizing at the beginning simply took this 10-by-10 grid, turned it into numbers, one to 100, and, uh, it says how many mines it is. It went for 15%, but it's randomized, of course, so it's found a bit more, 19.

49:57 And the random numbers for zeros and ones decided which of these are mines.

50:08 Okay. Using shapes, color, and size, um, another technique, of course, we use that a lot.

50:16 Uh, drawing and coloring the game board, you saw that in Set, of course, with the colors and the shapes. But here in Dobble, the Dobble game, I'm placing some sh- some shapes. I have 57 shapes here.

50:30 Um, all of them are, um, assigned to, to different numbers, card numbers, one to 57.

50:39 And the size is actually really randomized. So I just want to randomize the size on a card, so what I do is I use… I, I take a, a number, three plus cosine of… And, and this will just put something random between, almost random, between minus one and one.

51:01 So the picture number and the card number minus the card progress. These are various parameters, but it doesn't matter. Once I put a cosine on them, it's really randomizing the size between minus one and one, so it, it'll give me, um, anything between two and four. Okay? Three plus a, a range between minus one and one will give me something between two and four, so this would be a two, and the largest one, maybe this one, would be a four.

51:31 Okay? So that, that way I can randomize the size of the cards and make it a bit more difficult to find them.

51:38 So if I'll, uh, demo this, you'll actually see that the card sizes are randomizing.

51:46 Dobble is here.

51:50 And if anyone doesn't, uh, know Dobble, Dobble is a set of 57 cards.

51:56 Every two cards have just one, um, one picture which is the same. So you have to click on the id- one of the identical ones, and this one in this case, and the c- one of the cards will switch.

52:09 And then find the next identical shape.

52:13 Okay, and it's still… And again, uh, there's a bug with the time, so it's very difficult to do it.

52:18 Um, I should've clicked to start a new game. That'll be, that'll actually reset the time. And it's telling me how many I found, and it… Let's make a mistake. Let's say click on this one.

52:31 It, it's incremented my mistakes as well.

52:35 And I can continue, um, looking for what's identical here. It's the boat.

52:43 And, uh, you can continue. It's a nice game. Kids play it with cards. We play it with… We can play it on the computer.

52:54 Um, a few more techniques yet. Uh, viz in tooltip, of course. Um, adding a, a worksheet to a tooltip.

53:03 Here in Sudoku you can see how it's been done. I have actually… This is simply an enlarged version of, uh, um, of, uh, help numbers in the, in the cell.

53:15 Um, so I created, uh, a worksheet which is called Cell Helper, and it's just showing exactly the same.

53:24 But of course you can add anything to a, to, to a tooltip, shapes, lists, anything that's not regular text. You can use, uh, a viz in tooltip to add it. I actually don't use it much in the games. This is, uh, one case where it actually is in use.

53:43 And the last two techniques, um, showing and hiding stuff. Dynamic zone visibility. This is a relatively new feature. I don't remember what year it's from, '22, '23.

53:54 Where you can use a parameter to display a container or a worksheet or hide a container or a worksheet. So the Minesweeper is a good example 'cause, yeah, you have several steps. So when, when I'm in the create step, you can't actually see the grid.

54:14 After I click on create, you can see the grid and the start button.

54:20 Um, again, y- shown or hidden using the control visibility, using the, um, using a parameter which has to be Boolean, has to be true or false, which defines if you display or hide the object.

54:37 Um, and so here I'm displaying the start and the grid, and after I click on start, I'm playing. And see, you, you've seen that. That's just the grid. And when I win or lose, I'm… It, this is the actual example. You, you've already seen this, the show lose, um, text box Um, is displayed using a parameter. So there's a parameter which is called show lose.

55:04 It becomes true, and this displays the, the banner.

55:10 Okay, so this is used quite a lot in the, in, in my games.

55:15 And the show hide button is very similar. You can take any object, add a button like this one, the X, or it actually has a light bulb.

55:23 This is the original, and it can show or hide, um, a dashboard element. In this case, it's the help, uh, picture.

55:33 Um, and this is a nice technique that I also picked up from some people.

55:38 Um, so the help is actually a floating image on top of a game, which looks like a game, but it's, it's not. It's, it's an image with some text boxes explaining the game.

55:49 So, and this is, I think, my last demo.

55:53 Um, let's go to Number Stamper.

56:05 And this is in a mobile layout from the beginning because it's a small game. You have to find, um, the numbers. Let's just click on the help. So now it's displaying an image on top with the explanations, and I'm closing it. That's the show hide button. But I can start the game.

56:27 Okay. Um, I'll just, uh, do a zero, one, two…

56:33 I'm gonna guess four numbers.

56:39 And it's gonna tell me none of them. That's great because this means all my numbers are between four and nine.

56:50 Okay, I'm gonna guess another four numbers.

56:54 Ah, three of them.

56:57 And so on until you find, um, all four correct numbers in the correct place. This means that all three of these are correct, but not in the correct place.

57:08 Um, just one more click just to show you I can. Let's say nine, eight, six, seven.

57:20 Okay. So, oh, well, I'm not gonna do all the calculations. That, that, that's for playing the game.

57:25 Um, um, and of course at the end when you finish and you win, there will be dashboard zone visibility used to display a winning banner, um, when you win the game.

57:41 Okay, so let's summarize. I've gone through all the techniques. Are you still there, by the way? I'm… Or am I talking to myself?

57:48 Chris McClellan: Uh, we're all here. The chat-

57:49 Dan Chissick: Okay

57:49 Chris McClellan: … stopped because I think everyone's just so amazed with all the calculations.

57:53 Dan Chissick: Ah, okay. Okay. So let's summarize. I've gone through the techniques really quickly because everything is quite, quite a lot of the stuff is really complicated. But, uh, it's showing you how there's lots of techniques that are useful in games. I've learnt a lot from using these, from using these techniques in creating games.

58:12 But, um, I enjoy it as well. It's fun to create a game. It's, it's a real challenge.

58:18 I mean, every time I finish a game and publish it, uh, there's real satisfaction because these are really advanced, uh, projects you could say.

58:27 Um, the techniques, nearly all of them are useful, uh, except for the random function, I think.

58:33 Um, I mean, even that can be used in a business context. There, there are uses for random there in displaying stuff, but nearly everything is useful. Um, you learn how to use, uh, to, to, to work with complicated, uh, calculations and, uh, how they work, and it helps, uh, at work as well.

58:54 And of course, playing the games afterwards can be fun. I mean,

59:00 uh, people, some people play the games, and I think the best example was, uh, when, when there was the COVID, and I'll, I'll go back for a minute to my, um, my profile.

59:11 When COVID struck us, and I'm into orienteering, okay? Orienteering is an outdoor sport,

59:18 and when, when COVID struck in 2020, um,

59:24 uh, no one could go outdoors. So the sport was closed down for, for months all over the world.

59:31 And I, I had a memory game for orienteering maps, and this is, I think, my most viewed, uh, viz because people were stuck at home, so they were looking for online games related to orienteering, and this is one of them.

59:47 So lots of people were playing this.

59:50 So I… There, there are various themes I can choose. You can choose different, uh, um, different maps, and it's showing you parts of maps, and you have to find the identical ones.

1:00:01 And, and this was before I learnt how to disable the highlight, so it's a bit more complicated.

1:00:08 But, uh, people were playing this a lot.

1:00:12 This could be maybe similar to this one.

1:00:15 No.

1:00:20 I don't know. Yes, they are the same one.

1:00:23 Chris McClellan: So it's essentially the same as before but a different, um-

1:00:26 Dan Chissick: Yeah, different shapes

1:00:27 Chris McClellan: … different items. Like, yeah.

1:00:28 Dan Chissick: Different shapes.

1:00:29 Chris McClellan: Like maps rather than animals. Yeah.

1:00:31 Dan Chissick: Yeah.

1:00:31 Chris McClellan: Still cool.

1:00:32 Dan Chissick: It, it, it… I, I, yeah, these are all in the shape library and, uh, uh, assigned to shapes. Yes.

1:00:40 Um, again, it's, uh, it's fun. It's difficult, uh, but it's really rewarding. There, there aren't many real games on, real randomized games on Tableau Public, but there are a few. Some people have, uh, published some stuff. Um- And, uh, this is one of my claims to fame in Tableau, uh, creating games, and talking about recursive parameters, which was the trigger for all of this.

1:01:09 Um, and if there are any questions, thank you for listening, of course. Thank you for, for being here, and, uh, uh, allowing me to present this.

1:01:20 Chris McClellan: Um, no questions from me, but there was a lot of comments in the chat about just the, the, the complexity. But as I said, when you said, "Oh, it's…" What did you say? "Oh, it's really complicated." I'm like, "Yeah, it's really complicated. It's also really cool at the same time that you can just do that and figure out the logic behind that." So it actually reminded me a lot, even when you're doing the f- the parameter actions, um, you- you're probably old enough to remember this stuff like me, is when you used to actually be able to program mouse actions.

1:01:52 So what happens when a mouse is… When a mouse button goes down, and a mouse button goes up, and then when a mouse button is clicked, and you've essentially-

1:02:00 Dan Chissick: Yes

1:02:00 Chris McClellan: … done all that in Tableau.

1:02:03 Dan Chissick: Yes, more or less. Yes.

1:02:05 Chris McClellan: Yeah.

1:02:06 Dan Chissick: And, and by the way, you can download, uh, my vizs.

1:02:10 I…

1:02:10 If, if someone finds one of them which is not downloadable, tell me. You can download, and you can try and run them through AI, and let's see if the AI can…

1:02:23 If the AI can tell you what's happening there.

1:02:26 That would be nice.

1:02:28 Chris McClellan: Yeah. No, that's just awesome. And, and even right at the start when you were doing something, and I said, "It's, it feels like you're l- using map layers," but you would've developed this way before map layers was a thing.

1:02:39 And then when you showed it-

1:02:40 Dan Chissick: It wasn't way before, but yes, none of them…

1:02:42 I think none of them are map layers.

1:02:45 Chris McClellan: But you're using, like, the XY technique rather than-

1:02:48 Dan Chissick: Yes

1:02:48 Chris McClellan: … latitude and longitude. It's the same result, yeah.

1:02:52 That's awesome.

1:02:52 Dan Chissick: Yeah, so map layers would make it… You could have more complicated games with map layers. Maybe that's the next project, having something s- I have to think of which game would, would fit, where you have several layers and, uh, things happen on different layers. But it, it would work. It'd have to be, again, a single player ga- I have to think of something.

1:03:14 Chris McClellan: But you've, you've almost got that with Sudoku, right? Because you've got…

1:03:18 If you've got the number correct, the number's in the middle.

1:03:22 If you don't have the number correct, you're putting up the helpers beside that of what numbers are available.

1:03:26 Dan Chissick: Helpers is a different worksheet. Yeah, it's two worksheets, and one of them-

1:03:29 Chris McClellan: Sure

1:03:29 Dan Chissick: … is floating on top of the other.

1:03:32 Chris McClellan: But, but it's essentially the same thing. Like, you don't have to convert that to map layers. That's just using lat and longs. You've, you've just done it with X and Y from the start, I guess.

1:03:42 Dan Chissick: It, it, it's not e- it's not even X and Y. It's simple, uh, worksheets with a trellis chart and a, and a, a number of data points. But it's two worksheets actually floating one on top of the other. The top one is transparent.

1:03:57 Chris McClellan: Yeah.

1:03:57 Dan Chissick: Over… Yes, the top one is transparent.

1:04:00 Chris McClellan: But just-

1:04:01 Dan Chissick: Uh, showing, showing and hiding, uh, the, the one, one of them. Yeah.

1:04:07 Chris McClellan: But the same thing, just super cool that you've, you've gone through the logic of thinking how to do that.

1:04:13 That's, that's the first step, and then making it work in Tableau so that it works just like a real Minesweeper or a real Sudoku and stuff.

1:04:21 Yeah.

1:04:23 Very cool.

1:04:23 Dan Chissick: Yeah, no, that, that's the challenge. That is… It, it makes you think. You, you really have to, to, to work at it. Some of them, you… I got stuck, and I had to…

1:04:33 Sometimes you get stuck on a specific th- One thing you need randomizing it or, um, in the Minesweeper, uncovering the beginning, so you need a, you need a starting point always in Mi- in Minesweeper. And you get stuck on it for a month, 'cause I'm not working at this full time. I am working full time with Tableau.

1:04:52 So I, I do this once in a while in the evening, and then suddenly I have a breakthrough, and I can, uh, can continue, and then I go… That's why it takes months.

1:05:05 Chris McClellan: Yeah. And, and some of that stuff, you've gotta step away from it to sort of think it through to figure out what the next step is.

1:05:12 Dan Chissick: Yeah.

1:05:13 Exactly. So I'm thinking about it going to sleep.

1:05:18 They're doing parameter actions in my mind.

1:05:23 Chris McClellan: And, and Jacob saying that, you know, back in 2017, Josh Milligan put something about playing Battleship in… Was that in Tableau as well?

1:05:33 And

1:05:33 Dan Chissick: Yeah, I, I think that one isn't randomized, and I think every, every cell is a different worksheet or something like that.

1:05:43 I'm not sure. I've, I've seen a few games, I've seen a few games where every picture… I've got… I've seen a memory game where every picture is a worksheet.

1:05:52 Chris McClellan: Yeah.

1:05:52 Dan Chissick: Or it's all static.

1:05:55 Chris McClellan: And I remember Heather Cox was having diff-

1:05:57 Dan Chissick: Oh, yeah. Diff- a different parameter for every cell. Okay. See?

1:06:00 Chris McClellan: Yeah.

1:06:01 Dan Chissick: Um, so that's what I'm trying to avoid. That, that's what parameter actions enable us-

1:06:07 Chris McClellan: Mm-hmm

1:06:07 Dan Chissick: … to do.

1:06:09 Chris McClellan: But, but Heather, uh, was about a year ago now, maybe even more, was having problems with random. The same problem as you said is it's random. It's called random. It's not exactly random. It's, it's very fixed in what it does, and you need to add some sort of, some sort of other thing in it to make it more random, like the date trunk seconds and stuff like that.

1:06:29 Dan Chissick: It, it actually is random. If you refresh your data-

1:06:33 Chris McClellan: Oh, yeah

1:06:33 Dan Chissick: … it's random. But you can't refresh your data in Tableau Public.

1:06:37 Chris McClellan: Yeah.

1:06:38 Dan Chissick: In a business context, it would be random because your data is refreshing all the time.

1:06:43 Chris McClellan: Yeah.

1:06:44 Dan Chissick: And as, as a user, you also, on Tableau Cloud or Server, you have a refresh button, but every time you refresh the extract, your… or even if, if it's live, it would, it would actually refresh. But, uh, yes, if, if you're on a fixed, uh, data source, then uh, the random isn't actually refreshing.

1:07:02 Yeah.

1:07:02 Chris McClellan: Mm-hmm.

1:07:03 It'd be interesting if you hooked up, 'cause Tableau Public can refresh from Google Sheets every night, or every… I think it's UTC midnight.

1:07:12 Um, so if you could do that, it probably would make it more relevant.

1:07:15 Dan Chissick: Yes. I, I know of that, but I'm not gonna… Yeah, but-

1:07:18 Chris McClellan: No, no, it's-

1:07:20 Dan Chissick: I'm not gonna connect your games to Google Sheets.

1:07:23 Chris McClellan: But, but you've got it fixed anyway, right? Because you've got that, that-

1:07:25 Dan Chissick: Yeah. No, I'm all in sheets

1:07:27 Chris McClellan: … yeah.

1:07:30 Dan Chissick: Yes. Okay. So I'll-

1:07:31 Chris McClellan: This is-

1:07:32 Dan Chissick: Uh, I, I'm, I'll be sending Chris the presentation and you'll add it to the show notes-

1:07:38 Chris McClellan: Definitely

1:07:39 Dan Chissick: … so people can download the presentation, which has all sorts of links.

1:07:43 Chris McClellan: That's awesome.

1:07:43 Dan Chissick: Yeah.

1:07:44 Chris McClellan: And there's all your contact details if people need to get in contact with you, especially Tableau Public and LinkedIn.

1:07:50 Dan Chissick: And read my blog. It's about, uh, Tableau.

1:07:54 Chris McClellan: Yeah. That's good.

1:07:55 Dan Chissick: Mostly.

1:07:57 Chris McClellan: We'll move on to the survey if everyone's got their phones handy.

1:08:02 So just a quick Mentimeter survey. Scan the QR code on your phone, or if you're sitting at a computer, you can always go to the website and type in the code.

1:08:12 Just a few simple questions. People that have been here before know what the, what some of the questions are. We always have some new ones that I've hopefully lined up with today's presentation as well.

1:08:24 So people can scan the code as we go through. There's a few people dropping off, which is fine.

1:08:29 Uh, so the first question is always: where do you live? Just so we've got an idea for where people are from for today's meeting.

1:08:40 And obviously, it's gonna go to that side, isn't it?

1:08:44 And we don't obviously, we don't usually see Israel and California on the same screen at the same time.

1:08:49 Uh, I think Cooley just left. She's in Estonia.

1:08:52 Um, Viraj has already left 'cause he's got work to do. I'll have to do that. Um, but India, a few other places.

1:09:01 That's cool.

1:09:03 And the next question, uh: what industry do you work in? So what can we actually see Tableau being used in.

1:09:11 Um,

1:09:16 so healthcare, automotive, insurance, software, consulting, just across the board, as always.

1:09:27 And this will be interesting. How many years have you been using Tableau? Just from an experience point of view.

1:09:36 And everyone's leaning on the big nine-plus side at the moment, right?

1:09:41 So you laugh. Every time we do this, the results are different, obviously, 'cause it depends on the audience.

1:09:47 And, and it's always when we get more technical conversations like this, it always leans over to the right.

1:09:52 Um, and the other day, I forget which TUG it was, and it all, it leaned over to the left as we had several people that had just started using Tableau, and someone replied in the chat and said, "I've never used Tableau before." So it's a wide audience. That's good.

1:10:07 Uh, okay. The special question just for today's meeting: what's your favorite part about working with Tableau?

1:10:19 Okay, so it sounds like everyone's cheating 'cause someone said flexibility, and someone says the flexibility, and the next person says flexibility.

1:10:27 Three out of three right there. Um, playing with data, the interface, definitely.

1:10:36 So all good things about Tableau. Uh, question number two is: should Excel be used as a database? I thought this was, this was funny when it came up in the list.

1:10:52 So, so the obvious answer is why not, or no, or I have before, or never.

1:11:02 No one's saying yes. The why not is this, the, mm, why not not have before.

1:11:08 And then obviously for what Dan does, I think that was the amazing thing about your Tableau thing is you don't have a lot of data. You've just got a lot of calculations.

1:11:19 So your data set's probably tiny, but it's how you manipulate that data as you go through the game. That's the important bit.

1:11:27 Dan Chissick: Yeah. It is in Excel usually, but it's not a database.

1:11:30 Chris McClellan: Yeah.

1:11:32 But you're not, you're not actually trying to display data. You're trying to… Yeah. You're almost bending the Tableau rule book in half and saying, "I don't have data. I've just got a whole heap of calculations that the user interacts with the calculations that does different things," which is the game.

1:11:48 Uh, and question three: what advice would you give your past self when first start, when you first started using Tableau?

1:12:00 I'm glad I made the, um, text boxes a bit bigger so people can write different things.

1:12:06 Some good responses so far. Have patience, Padawan, you will get there. Yes.

1:12:11 Um, and even looking at this presentation, you go, uh, even when I tr- teach Tableau, just you're, you're trying to explain to people how to learn Tableau in a few hours when even after a decade, you don't know everything because there's a lot of stuff to learn and, and it depends on which way you're going.

1:12:30 Um, someone else says, "Blue and green dimensions and measures, they are all different things." Yes.

1:12:35 Uh, start building the dashboards and interact more with the community.

1:12:41 That's good. That's what we're here for, and all the, the other TUGs.

1:12:45 So there's in-person TUGs where you actually have to be in that location and go in, attend the TUG meeting at some point in time. Um, they're always good.

1:12:54 And then the online stuff is good because we've got, you know, people from around the world watching this presentation.

1:13:01 And question number four is: what kind of dashboard do you want to build but haven't yet?

1:13:07 I thought that would be very fitting based on today.

1:13:13 So one person says board game, and no one else has replied. That's cool.

1:13:19 Dan Chissick: Yeah, I'm thinking.

1:13:26 Chris McClellan: Well, that's what I was thinking your presentation is, is even… There's a few people saying, "I've got an idea for a game. I've, I've now got to figure out how to do that," and probably following some of your workbooks to figure out how to make that possible.

1:13:42 An Iron Viz dashboard. Yeah.

1:13:46 Or maybe an Iron Viz winning dashboard for next year.

1:13:50 Dan Chissick: I would have to move country for that.

1:13:54 Chris McClellan: You're still not eligible?

1:13:56 Dan Chissick: No.

1:13:57 Chris McClellan: They might change the rules. I don't know.

1:14:00 Moving countries might be easier.

1:14:03 Depends on what-

1:14:03 Dan Chissick: No, no, not moving.

1:14:07 Chris McClellan: And question number five is: what is your favorite feature or function in Tableau and why?

1:14:19 So someone says map layers. Obviously, Dan's answer is parameter actions, of course.

1:14:24 Without parameter actions, you're not gonna do what you're doing.

1:14:29 It's always nice when you see people say, you know, "Oh, I have two or three parameter actions," and you look at that screenshot, and you've got, you know, more than ten, more than 20 times.

1:14:38 Okay, cool. And possibly the harder questions, but it's for me rather than for you. What topic should be presented at a future TUG meeting?

1:14:48 So someone says, "More deep dives like this into technical builds." Yes, it's like you're reverse engineering your own logic to explain how it works, which is always good.

1:15:01 And the same thing, download the workbook, pull it apart, and see how that works together.

1:15:07 Okay, and the final question, which might be just as hard as this question: who would you like to see present at a future TUG meeting?

1:15:17 Just giving me a list of who I can go out and find.

1:15:21 And no one's replying. It's either too early in the morning or too late in the afternoon. I don't know.

1:15:26 Or for Anne, it's like after 11 now.

1:15:30 Dan Chissick: There are a lot of people that have presented already, all the famous ones, so.

1:15:34 Chris McClellan: Yeah.

1:15:37 But I don't, I don't mind. This just gives me a list of people to contact. There's, there's been a few names that I need to get in contact with them that, um, just to, to book them in. Same thing.

1:15:47 Okay. We'll switch back to our normal presentation.

1:15:51 And the next TUG meeting is Sam talking about modern UX in Tableau. So unfortunately, she lives in the US, so the US times are back and working better. The European times, I don't expect you to be here at 1 a.m., and it's sort of easier for me as well. Um, but talking about how to actually build Tableau dashboards that have a modern UX appeal with toggles, custom filters, et cetera.

1:16:18 Again, those are the dates. Scan the QR code, uh, log in through the user group's website, or look at the recording on YouTube later on.

1:16:26 Uh, speaking of YouTube, this recording, a whole heap of… or everything else that we do, a whole heap of other online TUGs, um, a lot of stuff on that YouTube channel at Team Data Fam on YouTube, or listen to the podcast on Spotify or Apple.

1:16:41 I'd still be listening to this one, but it's obviously one of these ones you've got to come back and watch it to get the full benefit of it. But, um, you know, you can listen to it and pick up some stuff along the way as well.

1:16:52 And if people want to get in touch by email, it's team.DataFam@Gmail.com.

1:16:57 So again, thanks, Dan, for that. It was awesome presentation. It was good to actually see the logic that goes into that as well.

1:17:04 Uh, tons of calculations, tons of different things, and, and as I said, sort of using Tableau for a purpose it's not really designed for, but it really works well for as well. So thank you.

1:17:16 Dan Chissick: Yeah. Thank you. Thank, thanks everyone for, for listening.

1:17:21 Chris McClellan: Okay. And if anyone wants to unmute or say something, but, um, that's the end of the meeting for today.

Shorts for this TUG

Leave a comment

Your email address will not be published. Required fields are marked *