# Plot cumulative users over time

**URL:** <https://community.piwik.pro/t/plot-cumulative-users-over-time/3908>\
**Category:** Reports and working with data\
**Created:** [April 18, 2024, 7:22am UTC](https://community.piwik.pro/t/plot-cumulative-users-over-time/3908 "2024-04-18T07:22:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Butler](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/david_butler/32/3304_2.png) [@David\_Butler](https://community.piwik.pro/u/David_Butler)\
**Post date:** [April 18, 2024, 7:22am UTC](https://community.piwik.pro/t/plot-cumulative-users-over-time/3908/1 "2024-04-18T07:22:33Z")

</div>

Hey. Sorry if this is a naive and obvious question, but I want to plot number of unique visitors cumulatively over time - cannot work out how to do it.

That is: x axis = time, y axis = total number of visitors the app has had to that date

For avoidance of doubt, the graph should be monotonic increasing (cannot decrease)

---

<div class="post-metadata">

**Author:** ![asinior](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/asinior/32/1905_2.png) [@asinior](https://community.piwik.pro/u/asinior)\
**Post date:** [April 18, 2024, 8:43am UTC](https://community.piwik.pro/t/plot-cumulative-users-over-time/3908/2 "2024-04-18T08:43:27Z")

</div>

Hi,  
You could create a **Line chart report** , add the Visitors metric to you graph, and then add a condition in the **Filter dimensions** section, which only looks at **New visitors** ( **Returning visitors is New** ). Here is an example of that:

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/8/86ca445ac33d215200e45151def67f19aee041ff.png)

Also, here are some additional articles that you may find helpful:

> **[Create a custom report | Piwik PRO help center](https://help.piwik.pro/support/reports/create-custom-report/)**
>
> Creating custom reports is easy. Just decide what data you want to include, follow our directions and you’re ready to go. Then use custom reports to gain insight into your website traffic and visitor journeys. To create a custom report, follow these...

> **[12 useful custom reports | Piwik PRO help center](https://help.piwik.pro/support/reports/12-useful-custom-reports/)**
>
> Creating your first custom report can be a bit of a challenge when you’re just starting out. That’s why we’ve got you covered! We’ve put together a list of custom report templates to get you started and inspire your reporting journey. In this...

List of dimensions and metrics used in Piwik PRO:

> **[List of dimensions and metrics | Piwik PRO help center](https://help.piwik.pro/support/reports/metrics-dimensions/)**
>
> Here’s a list of dimensions and metrics in Piwik PRO. Dimensions contain their description, category and scope. Metrics include their description, category and the approximation method used to calculate them. Dimensions Session Dimension name...

---

<div class="post-metadata">

**Author:** ![David\_Butler](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/david_butler/32/3304_2.png) [@David\_Butler](https://community.piwik.pro/u/David_Butler)\
**Post date:** [April 18, 2024, 9:18am UTC](https://community.piwik.pro/t/plot-cumulative-users-over-time/3908/3 "2024-04-18T09:18:55Z")

</div>

Thanks. I am a little confused as I would expect the graph to only go up. The number of total users we have can only ever go up…

Am I missing something? Essentially I do not want to group by day, just over all time.

 ![Screenshot 2024-04-18 at 10.16.54](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/3/3912ca96354aeabe17a661c799a5d8e96bf992be.png)

---

<div class="post-metadata">

**Author:** ![asinior](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/asinior/32/1905_2.png) [@asinior](https://community.piwik.pro/u/asinior)\
**Post date:** [April 18, 2024, 9:26am UTC](https://community.piwik.pro/t/plot-cumulative-users-over-time/3908/4 "2024-04-18T09:26:44Z")

</div>

This is only for unique visitors, so this will rule out visitors that have already been to you site before and this can significantly influence the chart. If you would like to include the returning visitors as well then remove the **Returning visitor is New** from the filter dimensions section. After you do that, you should have an overview on the data from all of your site’s visitors.

The line on the goes downwards because on April 18th there is not enough data that could be gathered. I am sure that it will eventually go upwards during the day.

Also, it seems that the data started being gathered around April 11th. There will be no all time data accumulated for the period before this date as the data starts being gathered as soon as there is a Piwik PRO installation code incorporated into your site’s source code. However, you should be able to filter out the data as soon as you create and save the report in the line chart report section itself:

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/7/7728d83110d295833721642d13301519e9cc262f.png)

---

<div class="post-metadata">

**Author:** ![David\_Butler](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/david_butler/32/3304_2.png) [@David\_Butler](https://community.piwik.pro/u/David_Butler)\
**Post date:** [April 18, 2024, 12:39pm UTC](https://community.piwik.pro/t/plot-cumulative-users-over-time/3908/5 "2024-04-18T12:39:37Z")

</div>

Thanks for your swift replied. Much appreciated.

Digging deeper, i am struggling to understand the user segments and am confused by the following inconsistency. I have created the following example to illustrate the point.

 ![Screenshot 2024-04-18 at 13.31.16](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/c/c006d6dd1921103aee16b591f0ac06488af577e1.png)  
I have a user segment that is just me: identified by “this-is-dave” by the event that we are using to track users (users enter this custom event when they opt into our SDK telemetry). This is shown in screenshot 1.

Then screenshots 2 & 3 show a dashboard for “all visitors” and “not dave” (everyone but me).

I plot two things in the dashboards:

1. Number of unique visitors
2. Page views by Dave (screenshot 4 to see this definition)

As expected the page views has data for “all visitors” and no data for the “everyone but dave” segment.

However, why does the number of unique visitors remain the same? I would expect the number to decrease by 1 when looking at “everyone but dave” compared to “all visitors”

 ![Screenshot 2024-04-18 at 13.30.40](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/0/0dae81ac36406b740bef76c073374742f1d53c98.png)  
 ![Screenshot 2024-04-18 at 13.30.54](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/f/fa7f9fee638af994b970aae8fbfda914fbdce415.png)

 ![Screenshot 2024-04-18 at 13.35.32](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/9/9699d3e914dca93ee2e3ac2e1c8e70dea292189c.png)

---

<div class="post-metadata">

**Author:** ![asinior](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/asinior/32/1905_2.png) [@asinior](https://community.piwik.pro/u/asinior)\
**Post date:** [April 19, 2024, 9:34am UTC](https://community.piwik.pro/t/plot-cumulative-users-over-time/3908/6 "2024-04-19T09:34:43Z")

</div>

Custom variables are not a feature that should be used for the custom event recognition and that is why it does not remove you from the report as soon as you apply the segment. Could you share the structure of the custom event that you are using to identify if someone “is Dave” or “is not Dave”?

The best way of segmenting visitors is to assign a [User ID](https://help.piwik.pro/support/getting-started/userid/) to them. Also, if you do not wish to see yourself in the reports, then you could play around with the **Administration settings** , which will allow you to ignore traffic coming from you or your teammates. Here is an article on that: [How can I ignore traffic from my office? | Piwik PRO help center](https://help.piwik.pro/support/questions/how-can-i-ignore-traffic-from-my-office/).
