Video

Glad it helped!

Everyone will be able to see the shapes in your published dashboard. If someone were to go into the actual Tableau file, they would need access to where the image was stored for it to be visible.

Glad it was helpful!

I haven't tried embedding show/hide buttons in vertical containers. I've always changed the show/hide button images to a information icon, and it seems to work for my end users.

Where are you using the NULL?

Thanks for watching!

I'm not sure how to attach a dataset to CZcams. You can easily re-create the data set with an Excel file with Location, Date, and Quantity.

Glad it was helpful and glad you were able to follow along. Fairly complex way of approaching your data.

Glad you think so!

You might be right. This is a difficult for people to understand, at least it was for me. Someone explained it with pre-existing containers and it worked for me, so I took the same approach. Hopefully you found something useful in the video.

My pleasure. I hope it helped you on your journey.

Look at the formula at time stamp 2:32. You can add as many IF/ELSEIF scenarios that you want. For example, ELSEIF [KPI selector]="Group D" then sum([field]). You would add this logic to all the fields in Group D. Let me know if that doesn't help.

Thanks for watching.

I don't know off the top of my head. I assume you would replicate the pattern used for one parameter.

Good question. I haven't worked with extensions, so I can't answer that question.

Most welcome

I'm not aware of any way to synchronize any scrolling across multiple visuals. Admittedly, this was a work around and a bit clunky.

There may be an issue with the formula, or it could be the type of information you are trying to get. Are you trying to get 1, 2, 3, 4 for the quarter?

If you want to create anything, you'll need the Creator License. A good, cheap option is to get Tableau Public. You can link to Excel data sources and create charts and graphs. You won't be able to copy/paste images of your visuals, but if you do a screen shot you should be okay.

I'm not aware of any. This is a bit of a hack, so maybe in the future Tableau will roll this out as a feature.

Unfortunately, you can only have one item per worksheet. Dashboards are used for combined various worksheets together.

Glad it helped!

Tell me more. Are you using an image of a Google Map?

@TableauWeston, thank you for your response and question. To address your inquiry, no, I currently do not use Google Maps integration because I am unfamiliar with the process. However, I am actively researching ways to incorporate Google Maps into Tableau. On another note, I am creating a personal CV portfolio in Tableau, and to showcase the locations where I have worked, I aim to include an interactive map.

@@tahirtahirzade5051 I'm not sure how to integrate with Google Maps either, so if you figure it out please let me know. I've seen a couple interesting resumes done in Tableau. They look cool, but I'm not sure how practical they are for actually getting a job. Good luck.

Thank you for watching. Is there something you are interested in seeing?

Thanks for the suggestion. I discover things I know are helpful, but sometimes struggle with the titles. Thanks for subscribing!

I don't believe pie charts can have reference lines. If you want to show targets for the various slices, I would create a separate "target" pie chart and either display them side-by-side or overlay them using a dual axis.

Are you wanting to see the details for the particular category, like Furniture? In that case, just passing "Category" through the filter in the embedded visual should work. Feels like I'm misunderstanding the question. Please let me know what I'm missing.

I am still finding a solution for First and Last date case statement for e.g. IF ISNULL([touchpoint_date]) THEN "Date Null" ELSEIF (MAX[touchpoint_date]) THEN 'Last Touch' ELSEIF (MIN[touchpoint_date]) THEN 'First Touch' ELSE 'Mult Touch' END

Thank you for the kind words. I think you want to compare the [touchpoint_date] to the First Touch and the Last Touch. I recommend first creating two LOD calculated fields. {FIXED:MAX(touchpoint_date)} as the Last Touch, and {FiXED:MIN(touchpoint_Date)} as the first date. Then use those calculated fields in the IF-THEN calculation.

You may need to add additional dimensions to the FIXED calculation. For example, if you only want the Last Touch date for a vendor, product, store location, etc. , then put them in the FIXED calculation like {FIXED vendor, product, storelocation:MAX(touchpoint_Date)}. I hope that helps. Check out my other LOD videos.

The title is a little confusing (at least to me :( ). Can you explain a little more about which source field you are not able to see?

Thank you so much for the response. So to give you a background I am trying to reset all filters which incöude 2 parameter range date filters. I have found a way to reset the regular filters, i am now trying to use the same button to reset parameters to the dates when the workbook opens eg. 01-01-2023 - 20-12-2023. I am not even sure if that is possible

@@Syzemic This will be pretty complicated. I think you would need two parameters - one for the start date and one for the end date. Follow the video to set the parameters to a new value. I'm not sure if you can set the parameter to the value of another parameter. Depending on what you are trying to accomplish, you may suggest the dashboard user to select the "Refresh" button (a Tableau default) rather than trying to create a separate filter.

@@thegrabbag4304 Yeah I thought so as well. Just from a ux prospective its better if we have one apply all button and one reset button. Also the reset button remains selected when you click it so you have to click it twice, seems a bit buggy.

If the bar chart is showing the percent of the total, chances are the filter won't work because the percent of total is a table calculation that will not link to a specific field value. Do you have a location where you want the data set sent?

Under the Analysis menu, select Totals, then "Add All Sub-totals". You will then need to right click the dimension (blue bill) to unselect the sub-totals you don't want.

Is Cross Tab option greyed out, or is the format off when you export to Excel?

You're welcome!

Glad it was helpful. Thanks for watching.

I believe I used Excel and shaded the cells, then used the snipping tool. You could use PowerPoint as well. I liked Excel because I felt I could easily make the cells the same size horizontally and vertically. Good luck. Thanks for asking.

Glad it helped!

Glad you liked it. I hope it helped. Thanks for watching.

Unfortunately, because the menu items show up in the tool tips, I'm not aware of a way to adjust the size. However, the latest versions of Tableau have a hide/show button on contains, which will give you a lot more flexibility. Look up my video on hide/show buttons.

To add more filters to the FIXED function, add them between "FIXED" and the colon. Like this {FIXED [dim1],[dim2],[dim3]:SUM([Measure])}

Glad it helped! Thanks for watching and letting me know the video was helpful.

@@TableauWeston - Hi Weston! I used your steps for my Report where I wanted to exclude entire site's user if one of the category is deselected from Category filter for which that site was restricted. But I can not show them as BAN for final dashboard and create a map chart to show unique users by province because it calculates Unique users by Site ID in FIXED LOD formula. So if I remove Site ID from the view, nothing is showing on the report. Is there a way to show BAN and Map chart?

@@user-li4wz8st6l If you are looking for the unique user count on a map, would you even need to use the FIXED function? I would need to look at some sample data, maybe even a packaged workbook. Unfortunately, it sounds more involved and will require some research. Feel free to support me through Patreon or reach out via Linked in for a separate contract.

Glad you learned something. Now you can apply the concept to a variety of other situations.

Happy to help! Thanks for letting me know.

LOL. I make these videos because they are problems I've run into and had to research myself. Glad to know someone else has had the same problem.

Sorry. :) Once you figure out the impact and if you really want to do it by days or by months, your customer should be fine.

Perfect. If you have other ideas, please let me know.

Glad you liked it. Thanks for letting me know.

Wow! 6 levels, I would never have imagined it. You may be able to add the value to the label card and change it to % of total (quick table calculation). If that doesn't work, you might have a messy calculation on your hands.

Not that I know of. This is the only way I've found to include white. Tableau, if you're listen, add white to the color palette for discrete items, please.

Sorry about that. I try to show everything in one continuous shot, but sometimes I edit things out to keep things faster pace. I must have cut too much. Thanks for the feedback and for watching.