5 Replies Latest reply on Oct 5, 2017 12:42 AM by Priyanka Jose

# I want to create a line graph that shows montly details and unique visitors count..and then take a running total of the distinct count od visitors.

Here I am getting a unique count of visitors for each month but the Problem is if I visit for the month of june..it is calculated as 1. similarly if I visit for august. again counted as 1 in the month of august. And in the running total, I am getting my count as 2.. What I want is 1. Is that possible?

• ###### 1. Re: I want to create a line graph that shows montly details and unique visitors count..and then take a running total of the distinct count od visitors.

Hi Priyanka,

It would be better if you share your workbook, so that we can understand your data and query and can help you out with this.

Regards

• ###### 2. Re: I want to create a line graph that shows montly details and unique visitors count..and then take a running total of the distinct count od visitors.

I wasn't able to do the calculation directly in Tableau, but you can create a chart like this (assuming you are using excel) by adding another field in excel.

I started with:

 Visitor Date Billy 1/1/2017 Susan 1/2/2017 Jerry 1/3/2017 Susan 2/1/2017 Tom 2/2/2017 Susan 3/1/2017 Billy 3/2/2017 Frank 3/15/2017

Calculations:

Previously Exists  - You can see that it counts the times "Susan" appears in the previous cells and if the answer is greater than 0, then the > evaluates to TRUE, which means she has visited before.

New/Old -- This could be added to the previous calculation, but I just broke it out for simplicity. This part could also be done in Tableau.

Result:

 Visitor Date Previously Exists New/Old Billy 1/1/2017 FALSE New Visitor Susan 1/2/2017 FALSE New Visitor Jerry 1/3/2017 FALSE New Visitor Susan 2/1/2017 TRUE Previously Visited Tom 2/2/2017 FALSE New Visitor Susan 3/1/2017 TRUE Previously Visited Billy 3/2/2017 TRUE Previously Visited Frank 3/15/2017 FALSE New Visitor

Now in Tableau:

1 of 1 people found this helpful
• ###### 3. Re: I want to create a line graph that shows montly details and unique visitors count..and then take a running total of the distinct count od visitors.

Hi,

I am unable to open this workbook which you have shared, but what I have understood is you want to calculate all those fields in Tableau.

So please see the attached workbook and select any visualization from SHOW ME palate according to your need.

Regards