Forum Discussion
Danielwood
Helper I
Helper ICount months
Hi, In my table I have unique records, each with a target delivery date. I am trying to create a scatter graph which shows the number of records with a target delivery each month. Is there a calc...
DanielwoodHelper I
Helper Ipossibly i haven't entered it corrently, but the table would look like this
| Unique ID | Delivery |
| ABC1 | 01/10/24 |
| ABC2 | 01/11/24 |
| ABC3 | 01/11/24 |
| ABC4 | 01/10/24 |
| ABC5 | 01/02/25 |
| ABC6 | 01/10/24 |
| ABC7 | 01/02/25 |
| ABC8 | 01/02/25 |
| ABC9 | 01/10/24 |
So in this example on my graph i would be expecting 4 in October, 2 November, then 3 Feb 2025
rajendraongole1
Super User
Super UserHi Danielwood - as per shared information,
can you check below steps
I have created a relationship with Date table with uniq table (Delivery date to Date column Date table)
create a measure that will count the unique Uniqueid records for each month.
output as per shared data in scatterplot chart
Hope it helps.