# Chart over Users completion date
**URL:** https://community.glideapps.com/t/chart-over-users-completion-date/51523
**Category:** Ask for Help
**Created:** [October 12, 2022, 6:06am UTC](https://community.glideapps.com/t/chart-over-users-completion-date/51523 "2022-10-12T06:06:37Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)
#### Post date: [October 12, 2022, 6:06am UTC](https://community.glideapps.com/t/chart-over-users-completion-date/51523/1 "2022-10-12T06:06:37Z")
Under my users, I have a column named “ProfileCreatedOn”, which is a date that shows the data the user was created. How can I make a line chart of the user’s different dates?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 12, 2022, 6:25am UTC](https://community.glideapps.com/t/chart-over-users-completion-date/51523/2 "2022-10-12T06:25:30Z")
What would you expect such a chart to look like?
---
### Author:  [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)
#### Post date: [October 12, 2022, 6:38am UTC](https://community.glideapps.com/t/chart-over-users-completion-date/51523/3 "2022-10-12T06:38:41Z")
The X-Axis should be dates, and Y-axis should be amount of users that created that date.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 12, 2022, 7:41am UTC](https://community.glideapps.com/t/chart-over-users-completion-date/51523/4 "2022-10-12T07:41:33Z")
Okay, so…
- Create a Math column using the following formula:
```auto
Year(Date)*10000
+ Month(Date)*100
+Day(Date)
```
- Replace Date in the above with your ProfileCreatedOn date/time.
- Next, create a multiple relation column that matches the above column to itself.
- Now do a rollup through that relation, taking a count of any column.
That will give you a count for each date, but you might have duplicate dates, so they need to be removed. Do that as follows:
- Make sure your Users table has a RowID column
- Create a Single Value column that takes First-\>RowID from your multiple relation column
- Create an if-then-else column:
– If Single Value RowID is RowID, then User Count (the rollup column)
Configure your chart as follows:
- X-Axis: ProfileCreatedOn
- Item 1: Count (Rollup column)
- Filter: where if-then-else column is not empty
End result should be something like the below:
