Data is my world!
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?"
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 