-
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.
Madhuri Singh Sep 28, 2017 3:32 AM (in response to Priyanka Jose)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
Madhuri
-
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.
Thomas Rones Sep 28, 2017 3:44 AM (in response to Priyanka Jose)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:
-
RunningTotalExcelEdit.twbx 34.5 KB
-
-
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.
Madhuri Singh Sep 28, 2017 4:52 AM (in response to Thomas Rones)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.
Hope this will be helpful.
Regards
Madhuri
-
Total.twbx 7.2 KB
-
-
4. 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.
Thomas Rones Sep 28, 2017 5:15 AM (in response to Madhuri Singh)I'm not the original poster. That was my solution to Jose's question. He only mentioned visitor and date, so I created some mock data with visitor and date columns.
-
5. 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.
Priyanka Jose Oct 5, 2017 12:42 AM (in response to Thomas Rones)That helped alot...... thanks..