How to Count Distinct for prior 30 days at a given time interval?

tableaucommunity@tableau.com — Fri, 18 Oct 2013 15:54:08 GMT

Hi,

Instead of the count distinct function by week, I was looking to have a count distinct function that counted everything for the prior 30 days in a given week.

So for example, count distinct of Week 20, 2013 would give me a count of all distinct values for that week and the prior 23 days (cumulative).

Thanks

Help: Tableau returning incorrect sum/count values

tableaucommunity@tableau.com — Sun, 07 Jul 2013 07:19:04 GMT

Hi there,

I pushed my data from a CSV file into Tableau. For some reason Tableau is returning a Sum/Count value for a chosen column (Amt) that is incorrect. What is even more intriguing is when I open up the underlying data in Tableau, it still reflects the correct data - meaning Tableau is somehow misinterpreting the data. See below for a clear example of this contradiction. Tableau shows that the actual underlying data has a count of 711,205 rows, but only returns 710,339 count for the amount. I tripled check and this isn't because there are fewer values in the AMT column - there are 711,205 values in the underlying data!

I investigated further and it looks like Tableau has inserted blank spaces into certain rows for the value (Amt) where those rows originally had actual values. Why would ol faithful Tableau be doing this?

Thanks

Content in Tableau Community Forums

How to Count Distinct for prior 30 days at a given time interval?

Help: Tableau returning incorrect sum/count values