-
1. Re: Limit Hourly Results to Once per Day
Veronica Simoes Sep 10, 2016 3:19 PM (in response to William Kenworthy)2 of 2 people found this helpful -
2. Re: Limit Hourly Results to Once per Day
William Kenworthy Sep 11, 2016 11:50 AM (in response to Veronica Simoes)Thanks for replying, it looks like the view that you posted still has the results from the same day. For example, the first two results (21,175 and 21,087) occurred on August 11 at 3pm and 4pm respectively. What I want to do is filter out other hours on the same day, so the August 11 at 4pm and August 11 at 2pm (and any other August 11 hours) would be removed.
It works if I use the day filter (as in the second screenshot), but it won't show me during what hour that occurred.
-
3. Re: Limit Hourly Results to Once per Day
William Kenworthy Sep 11, 2016 12:09 PM (in response to Veronica Simoes) -
4. Re: Limit Hourly Results to Once per Day
Isaac Mickey Sep 12, 2016 1:51 AM (in response to William Kenworthy)Hi William
What about doing a DATEPART('hour',[Date and Time CPT]? This will simply strip out the hour from your date/time field and then you can use it in a variety of ways;
- You use your DAY version of the max, hide the axis and create a string label with a calculated field using DAY[Date and Time CPT] and the Hour DATEPART
- You simply add the hour value to your tooltip
- you could even colour code your bars based on the hours they occurred
I don't have Tableau 10 so I can't show you with your example but I've done it with some data that I have with date & time in it.
Hope this helps