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,470 points
29 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,200 points

Related Questions In Tableau

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,470 points
28 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
• 830 points
25 views
0 votes
1 answer
0 votes
1 answer

Date values from an int and a string in separate columns

Hi Anitha, You can combine fields together to ...READ MORE

answered Mar 13 in Tableau by CHERUKURI
• 13,940 points
26 views
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,200 points
945 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,200 points
36 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,200 points
77 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,200 points
29 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.