Count instance with same time

[jason5703]

I'm looking for help getting a count of instances where the timestamp is the same so that I can chart on a line graph against time of day.  

Throw Count Table:

ID	TOD(RND)
266268	8:30:00 AM
266268	8:30:00 AM
266268	9:00:00 AM

Obviously the table is much bigger and has more than one ID on it but I'm getting total numbers in the graph for the distinct id.  I'm hoping to get a answer if based on the above that 266268 threw twice at 8:30AM and once at 9:00AM.  Thanks!

[mwegener]

Hi @jason5703 ,

did you solve your problem?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[v-shex-msft · Accepted solution]

HI @jason5703 ,

You can use the following measures to calculate instance count based on current timestamp group, then you can create a line chart with timestamp field as axis, measure on value fields.

measure =
CALCULATE ( COUNT ( Table[ID] ), VALUES ( Table[TOD(RND)] ) )

Regards,

Xiaoxin Sheng

[mwegener]

Hi @jason5703 ,

create a calculated column an concatenate this two columns.

ID_TOD(RND) = CONCATENATE('Table'[ID];'Table'[TOD(RND)])

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.