What is the number of days that you are expecting to see?
Sorry for September I am expecting 743 Hours, but only getting 633. This is because there are no dates.
I would like to access the date dimension in Tableau and do a right join.
I am after number of hours and have tried using this calculation as well.
Business days/ hours?
The number of hours needs to be adjusted based on a filter, so if the filter says working days Monday to Friday we would like to count 5 working days, also if working hours are 7 to 7 then that's 12 hours.
The first step for us was to see if we can get the total number of days without any data, the rest of the calculation "I believe" is fairly easy.