Hello also to everybody back home, streaming this live or seeing this in the future.

Starting with a short introduction, my name is Tore Levensen, I'm from Norway, the only Yeah, we have this one, but sorry about this.

I don't care too much about this.

This is me.

So I'm a Tableau Jedi from Inmeta Consulting.

I am a Tableau ambassador, and also I run the Norwegian Tableau user group.

I have a wife, I have two kids, and I have a cat named Cecil.

Hi everyone.

My name is Heidi Kalbe, I'm an associate solution expert at Woodmark Consulting.

We are one of the premier partners in Germany.

So if you have any business in Germany, feel free to come talk to me.

Also feel free to talk to me under any other circumstances.

I am a Tableau ambassador in my fourth year, Tableau user group ambassador now, as I am a co-lead for Data Plus Women Germany and Rheinland Tableau user group also in Germany.

So feel free to connect.

A nice welcome also from my side.

My name is Annabel Rincon.

I have the chance to be a Tableau visionary and Tableau ambassador, and I am leading two initiatives, Data Plus Women Zurich.

If you want to be amazed and inspired by women working in data, please feel free to register.

Our events are virtual and free.

And I'm also co-leading the analytic Tableau user group.

In case you want to learn how to do analytics in Tableau, this talk is for you.

And please feel free to connect with me on LinkedIn.

It would be my pleasure.

So let's start because I have exactly 12 minutes and I will probably mess up.

So the first tip I have for you, it's not a Tableau tip, it's more like a learning tip.

Surround yourself with people that make you grow.

What I mean by that, attend Tableau user group, participate to community events like Workout Wednesday, for instance, ask for feedback, connect with people, because we never learn better than when we learn together.

And that's why, by the way, I'm doing this session with these two amazing guys, because I will mess up with their computer today, for sure.

The tip that I will be presenting to you, some of them are coming from the data farm from Klaus Schulz and Rosa Yogana, that are two amazing visionaries.

If you don't follow them, you should probably.

And how I learned about that, by attending a Tableau user group or reading blogs.

So what I didn't tell you about me is that I am living in Switzerland.

And in Switzerland, we love our chocolate, great, well done.

So let's imagine I'm working for a chocolate factory and I'm very happy.

I have done this visualization, I show it to my boss.

I have the sales and profit for different chocolate type and beans origin.

So I'm happy and she tells me, yeah, but I don't like you have the total at the bottom, right?

And I tell her, yeah, sure, I can put it on the top quite quickly.

But she tells me, I would like that it's written like total dark chocolate here and total milk chocolate here.

I can try, write dark chocolate.

But as soon as I do that, it changes every subtotal.

So how I do that?

For this tip, I will be using a calculated field that's called number of beans.

It's nothing else than the cone distinct of the beans origin.

I just show you so you trust me.

So you see here, it's like one for each row, six for dark chocolate because there are six beans origin difference and the grand total.

And I will be creating a fake column.

I put it here and I will use this column to display the label.

Create calculated field.

Let's call it new label.

Let's see if I don't mess up.

Yes.

Yeah, it's not my computer, so I'm happy to.

So if number of bean equal, no, equal one, that means that I am on every row label and I can, in this case, I want that it display beans origin.

Let's make it bigger, otherwise you will not see what I'm writing.

Else if, if my number of beans equal the total of number of beans, meaning the 14, but maybe tomorrow I have more beans origin, so I want that my calculation always works.

So then in this case, let's write grand total chocolate.

And else, what we want is like this subtotal.

So else, like written total, space, and a little plus sign with chocolate type and put an end.

And here Tableau say, Annabelle, you messed up because number of beans is a distinct, is an aggregated field, and the other one it's not.

So here it's not a big issue, I will just add like a minimum on the string.

So Tableau will be happy and he will have his aggregation exactly, and now it's okay.

So I can just like drag and drop this new label into my label, and now I have exactly what I want.

And now it's just a question of a little bit of formatting that we will be very quick.

We will change like the type by a Gantt chart, we will put the label in the left, we will remove the show header, and remove also the bean number because we are not interested.

And now, dual axis, synchronize the axis, very important, and Tableau messed up again, but that's fine, I can just like remove the measure name, and I have whatever I want.

So now for my boss like to be happy, I will remove the show header and I will write sales here on the bottom.

Quite cool, no?

So because I have a very demanding boss, she will come back and tell me, yeah, Annabelle, what I want now is that you create a visualization that allows me to understand the number of how many percentage of my spending I generated by how many percentage of my vendors.

And that is a Pareto.

So let's try to do the Pareto first, and don't worry, my boss will have like other requests.

So on the vendor idea, on the Pareto, you have first to sort, right?

So it's quite easy, you sort by field, descending order, and then, it's not my computer, I'm messing up, name the vendor idea.

What I want is not to have each vendor idea, I need like a measure.

So I will right click on this thing of the measure, and I will add a table calculation because the Pareto, what I really need is a running total.

Based on the vendor idea, I had a second calculation and have a percentage of total.

Yes, it's big enough.

Okay, and I will do exactly the same here, hot table calculation, running total, I was by the secondary calculation and percentage of total.

So that's good.

I just have now to remove the bar for line, and now I present that to my boss, and she can know that 30% of the vendor represent 91% of our spending.

And she said, yeah, but it's not what I want.

I want that I just write here, let's do the zoom, that I write 80% and that you create the intersection line.

Sure.

So I already created the parameter for that.

So in that case, I just, with the parameter, I can just right click, add reference line, select my parameter.

I could have chosen like a better name, I think, but anyway, add the value, and I can obviously like change a little bit of the formatting, have a nice color, for instance.

Let's put like a format, so you see very well and had some shading.

We have 80%.

But the problem now is to create these lines, and it's automatic, right?

So let's create a calculation.

To earn some time, I already copy-paste that.

That is nothing else that what we have in column.

I will explain that to you, intersection, yes.

So the first one is the one that we have in the row.

So the running sum of the sum of the spending divided by total, to make the percentage of total, and what I want to write here for the intersection, if this big formula is below my parameter, then I will start doing the running sum of the count of the vendor divided by the total, else, null, because I'm not interested in what happened after the intersection.

And then I can just drag and drop this intersection into detail.

Don't forget to compute using vendor ID.

Right-click, add the reference line, select it from the intersection, add the value, and we are done.

And now my boss, I can even like a parameter, but action, but if she write down 75% now, yes, sorry, 0 point, yes, I think that I didn't put, like, so correct.

Okay, trust me.

Yes, sorry.

I was with a comma instead of a zero.

Do you like it?

Yes.

Yeah?

Okay, right on time.

For the last tip, it's coming from Rosario Gona, so thank you, Rosario, if you are followers.

So my boss came to me and said, Annabelle, I want that you select, I want to be able to select a parameter like this and have, like, if I select the number of customer, the graph is automatically updated if I select the number of order, et cetera, et cetera.

So yes.

So I create, like, a visualization very quickly with the dark chocolate, mild chocolate, beans origin, like always, and I have a metric selected here.

The metric selected, I will show you very quickly.

It's simply, like, whatever I select on the parameter, if I select customer, it will be the condistinct of the customer name.

If the select order, condistinct of the order.

If I select the last one, I want, like, the number of order by customer.

So that's fine.

And that display.

The only problem here, what happened, and I will show it to you immediately, the label.

So for customer and order, it's okay.

But for order by customer, I have a lot of digits, and my boss doesn't like that.

She wants, like, a different format depending on her selection.

And how we do that?

We cannot.

But Rosario come with a tip, because in Tableau, what we have is, like, we can change a format if the value is negative or if the value is positive.

So let's do that.

Here I have a display metric, and I just said that if the metric section is order by customer, it's a bad guy that's causing issue, we will multiply the metric selected by minus one.

If I just drag and drop now metric selected into label, you see I have a negative value.

And now I just have to copy-paste this format, right-click, format, numbers, custom, copy-paste.

And that's it.

Because what we have done here is, like, the first one is positive.

Let's try to do that.

Can I?

No.

Sorry.

I just want, like, to show it to you.

Exactly.

When it's positive, it's this format that is a full integer.

And when it's negative, it's one digit after the zero.

And that concludes my session.

I hope that you like it.

And I'm right on time.

And Torre, the stage is yours.

Yeah.

So that was tips from a visionary.

Now it's down to lower level, simple tips from an ordinary ambassador from Norway.

I do tiny Tableau tips on X every Wednesday, so I'm going to do some of those.

And I'm going to start with this one, where I'm just going to start up Grammarly.

You know Grammarly?

Yeah.

Yeah.

And we don't know yet, but tomorrow there's going to be devs on stage.

Will there be spellcheck in Tableau?

We don't know.

I asked Mr. Miller last night.

He didn't want to divulge anything.

So if they don't want to share this tomorrow at devs on stage, if you install Grammarly, which is free, we can use the free version, you see that I have some spelling mistakes in here.

And you see that the G is spotting my mistakes.

And I can click accept, but Grammarly can't change anything in Tableau, unless you open up the dialog box.

You can't change the title, unless you edit it.

So when I go in here, I have three suggestions.

Or maybe I'm going to click...

What do you want to do?

I don't know what I want to do.

I want to fix my mistakes, please.

Just the same as Annabelle.

When it doesn't work, it actually works.

So this one apparently works.

Watch our session tomorrow at 9, then we're going to fix it.

But this works on any dialog box that you can open, a caption, a calculated field, or anything.

So until Tableau fixes spellcheck, you can use Grammarly instead.

And trust me, it actually works.

I've seen it.

I've seen it as well.

If you have a dashboard with multiple different visualizations like this one, just a simple bar chart, and you would like to save some space.

So this could be one of many different sheets inside of a workbook.

See that if I click on any of these, it zooms in inside of the same container to save space.

If I select multiple, it also shows multiple inside of the same space.

So I'm using a container to contain my data.

But also if you pay attention to my axis, it goes to 300,000K.

So it doesn't matter if I click on Chairs, or if I click on Art, it still keeps the same axis.

So how is this done?

If I go over to my worksheet, you see this nice little bar chart.

And I've created a calculated field that is called Fixed Max Sales.

I'm going to edit this one, and I'm going to zoom in.

So for each and every subcategory, I'm going to find the sum of sales, basically the same as you see on the label.

And then I'm going to find the max of this.

So whenever the data is changing, there's new data coming in, this will always be the highest value.

And the trick is, that you can't see, unless I hover over this hidden reference line, where I then put this calculated field, so it sticks into the view.

So whatever you zoom into, it will show you this Fixed Max Sales.