Forum Discussion

CalleWagenaar's avatar
CalleWagenaar
Frequent Visitor
3 years ago
Solved

How do I create a bar chart using start and end times.

Hi!
‎ 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 get this graph to show the time inbetween the stat and the end times.
For example: 
If a car drove from 10:00 -13:00 using only start 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? 

Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, CalleWagenaar 

     

    You can try the following methods.

    Sample data:

    Add a table for time.

    Measure =
CALCULATE ( COUNT ( 'Table'[Car] ),
    FILTER ( ALL ( 'Table' ),
        [Start Time] <= SELECTEDVALUE ( 'Time table'[Time] )
            && [End Time] >= SELECTEDVALUE ( 'Time table'[Time] )
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, CalleWagenaar 

     

    You can try the following methods.

    Sample data:

    Add a table for time.

    Measure =
CALCULATE ( COUNT ( 'Table'[Car] ),
    FILTER ( ALL ( 'Table' ),
        [Start Time] <= SELECTEDVALUE ( 'Time table'[Time] )
            && [End Time] >= SELECTEDVALUE ( 'Time table'[Time] )
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • CalleWagenaar's avatar
    CalleWagenaar
    Frequent Visitor
    3 years ago

    this helps however it doesn't work with multiple days. How can you combine months?