Thanks for your response! You're right, I had a typo in there. The sample
data should actually look like this:
Vehicle ID Location StatusDateTime 1234 B 7/1/2017 9:17am 1234 A 7/1/2017 12:00pm 1235 B 7/1/2017 3:35pm 1236 A 7/1/2017 4:45pm 1234 B 7/8/17 8:43 AM 1235 A 7/10/2017 9:00am 1236 B 7/12/2017 7:52pm
Leading to the counts in the bottom table. Thanks for catching that!
On Tue, Aug 8, 2017 at 10:38 AM, Shinichiro Murakami <
Sorry for late reply, and one more question.
Which version of Tableau you are using?
I'm using 10.3.
On Tue, Aug 8, 2017 at 7:39 PM, Shinichiro Murakami <
Looks pretty challenging..
You are using 10.3, then join itself is relatively easy.
Specify the day end location by vehicle.
Then, Count "A" and "B" separately.
Because "Location" directly impact to table calc, I could not find a way to set Location as dimension.
Same table calc needs to be set for "B"
Then filter the view with index..
Table calc is VERY complicated, becaue of missing value..
If you could create this table as data set, the approach can be straight forward.