Tableau Conference 2023 was held in Las Vegas from 5/9/23 - 5/11/23. I was so excited joining the conference this year after the pandemic. A lot of great features have been released or will be released soon. You may catch the highlights from Tableau Conference 2023 on Salesforce+.
How to String Agg a Dimension in Tableau?
Tableau does not have string_agg() function like SQL. I'd like to show list instead of asterisk when multiple values are present. Use Case: my company works with vendors to manufacture products. One product might be manufactured by different vendors . I'd like to show vendors associated with each product. If there are multiple vendors associated …
Continue reading "How to String Agg a Dimension in Tableau?"
Predictive Analytics – Capstone Project
The company is going to launch 10 new stores. The capstone project has three main tasks: determine store format for existing stores, store format for new stores, and forecast produce sales for the existing stores and the new stores. The methodology involve segmentation and clustering, non-binary classification model, and time series forecasting. Tools used in this project are Alteryx and Tableau.
How to Create a Donut Chart in Tableau?
Pie chart might be boring. If you would like to present percentage of total by categories, I highly recommend the donut chart. Based on the different data structures, I will show you how to create a donut chart in two scenarios.
How to create a stacked bar chart that adds up to 100% in Tableau?
Bar char is probably one of the simplest charts that every data analyst uses all the time. It is simple but very effective. I am working on a web traffic report, which needs to compare website visits by device category (desktop, mobile and tablet) over time. I think a stacked bar chart could be applied …
Continue reading "How to create a stacked bar chart that adds up to 100% in Tableau?"
How to create a YoY line graph in Tableau?
Line graph is simple, neat and one of the most popular charts that I use in my work. Today, I want to create a line graph to compare daily revenue with the same day last year. The challenge is that Tableau does not have Month/Day date format. See below: I have been tried several ways. …
Continue reading "How to create a YoY line graph in Tableau?"