Forum Discussion
CalleWagenaar
3 years agoFrequent Visitor
Counting unique data points in a bin group
This is my data set which I have sorted into bins. I want to calculate how many bins one vechile is part of. For example 8-TNN-89 would equal 2 as is belongs to bin 8:00 and bin 5:00. How do I ...
- 3 years ago
i hope both of the one helps you.
CalleWagenaar Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
CalleWagenaar
3 years agoFrequent Visitor
I have another questin now. I am trying to create a graph showing how many cars are drving at a certain hour. To do this I have start times and end times in my data. have created a time frequancy graph based on start times, which shows how many cars start at a certain time:
However this only shows the start times. How do I geth this graph to show the time inbetween the stat and the end time. For example:
If a car drove from 10:00 -13:00 using only strta times it adds one point to 10:00. I need it to add a point to 10:00, 11:00 and 12:00. How can I do this?