Santa Monica, CA
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+.
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?"
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.
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.
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?"
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?"
NIKKI YU 