HI everyone,
I have connected tableau to 2 lists from SharePoint and already completed the worksheet.
I would like to add the total number of records (last column) from both of worksheets together based on date
+If the date match--> add total from both
+if the date NOT match --> add only available value, missing value will be null.
How can I do that?
Or there is any way that I can add dates from 2 column into 1 column?
Thank you so much
Sonny
Hey Sonny,
Based on the screenshots in your previous comment, I'm assuming that Normalized Weekly is the week number for the corresponding date column and there is no relationship between your two data sets. If a view with combined date is the only purpose of this workbook, then do the following.
Note: I've updated the excel spreadsheets to replicates your data as much as possible.
1. You don't even have to union the two data sources. Just join them using Full Outer Join and use the following clause as the join clause. After doing this, your data will have columns from both your worksheets.
2. Create the following calculated fields - one for each measure that you want to combine and show in your view.
- NormalizedWeekly_WOD_CD
- Shift_Created_WOD_CD
- Date_WOD_CD
- # of WOD Created
- # of CD Created
3. Drag an drop all the above created fields on to the rows and you should have what you want:
Attached all the files used. Let me know if this helps and if it does, then please mark it as the correct answer.
Regards,
Rohit
