Using fixed values for weekdays as columns

0 votes

Sample Data:

enter image description here

What I want?

Build a single combo bar chart representing the number of orders booked, shipped, and delivered on a given day of the week (Sunday through Saturday). For ex: If August 1 was a Monday: Booked-4, Shipped - 2, Delivered - 1 should be its three columns and so on.

What I did?

Used DATEDIFF and time based filters to count the distinct orders. 

Issues facedThe issue that I am having is that I cannot use WEEKDAY function corresponding to any particular date i.e. Booked, Shipped, Delivered as it messes up the count. 

I want to use fixed values for weekdays as columns. Is it possible? 

Aug 27, 2018 in Tableau by Atul
• 5,530 points
50 views

1 answer to this question.

0 votes

You can PIVOT it in the data window so all the dates are in one column.  Once you are done, it would be simple to create your desired visualization. 

sample

answered Aug 27, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
1 answer

Tableau - columns as values

Hi Sindhu, You can do in 2 ways ...READ MORE

answered Jun 17 in Tableau by manoj
44 views
0 votes
1 answer

Creating a calculated field for summing up the values

Well you can use this in your ...READ MORE

answered May 17, 2018 in Tableau by Atul
• 5,530 points
49 views
0 votes
1 answer

Using Regex in Tableau, but only getting Null values.

Tableau regex engine is ICU, and there ...READ MORE

answered Aug 17, 2018 in Tableau by AwesomeSauce
• 860 points
58 views
0 votes
1 answer
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,355 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
113 views
+2 votes
1 answer
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
191 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,240 points
53 views