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 28, 2018 in Tableau by ffdfd
• 5,550 points
387 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 28, 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 18, 2019 in Tableau by manoj
586 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 18, 2018 in Tableau by ffdfd
• 5,550 points
459 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
714 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
9,371 views
+2 votes
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
1,265 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
2,827 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 29, 2018 in Tableau by Atul
• 10,240 points
709 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP