Heya Dave -
Make sure that you set your Hour Part dimension to be Continuous instead of Discrete (a green "pill" vs. a blue "pill").
Example attached. I added about 7-8 records which span hit 4-5 different hours, but because one row is 00:01 and another row is 23:00, I get everything in between filled in.
Show missing hours.twbx.zip 16.6 KB
Thank you very much for the quick response Russell,
I did set my Hour Part to be Continuous but that did not seem to help. The problem that I have is that in my data set I am unlikely to get "natural" data points that occur in the first and last hour of the day on a consistent basis (the 00:01 and 23:00 rows in your example).
Is there a way to force Tableau to cover the entire range of possible hours for the day, or to insert a type of "dummy" data points with the time values of 00:01 and 23:59??. (I will also have this exact same problem in another area where I will be looking at a 14 day period with sparse data).
Another solution would be for me to write a separate query and build an additional data connection for this, but I will have many metrics in this format and so would wind up with many, many data connections??
I feel like there must be a simple solution to this??
You can fix the axis to show from 12:00 AM to 11:59PM (right click)
2 of 2 people found this helpful
You should be able to go to Analysis -> Table Layout. That submenu has options for showing empty rows and columns. That, in combination with filters like Alex suggested above, should be enough to get you going.