How can I create a timeline with the amount of times records appear? (not numbers)

[Anonymous]

I have a column with names and another column with timestamps (dates and times next to it)

I wish there was a way to create a timeline that shows me the amount of times ANY name appears within those dates. 

For example:
On 2nd May we had 2 names: John and Lisa
On 3rd May we had 3 names: Mike, Darryl and Lisa
On 4th May we had 1 name: Diego

I want a timeline that shows me 2nd May = 2, then 3rd May = 3, then 4th May = 1

I tried creating a new measure that counts the number of names on the list and associating it with the timeline chart, but it doesn work  😞

Is it possible to do this? 

[Anonymous · Accepted solution]

If you want to show the total amount of names regardless if they are appearing multiple times on the same date, a simple measure like this would do:
Measure = count(Table[names])

If you want the count of unique names, then:
Measure = DistinctCount(Table[names])

To show this in a timeline, you simply drag the Date collumn from your Calendar table to the X-axis of the graph, and then your measure to the Y-axis of the graph.

If this doesn't work, then make sure there's a relationship created between your Calendar and the Names Table.

Let me know if this helps 🙂

[Anonymous]

At the end I think it was only an issue of my date being formatted incorrectly. 

I finally managed to fix this. 

Thank you very much for the help 🙂