2 Replies Latest reply on Jun 18, 2013 8:05 AM by Tracy Rodgers

Give me the number of days using COUNTD([DATE]) and only filter by year.

Jerry Ward Jun 17, 2013 3:43 PM

I have a working formula where it gives me the number of days selected in the filter. So if I have 5 days selected in the filter it will give me 5.

COUNTD([DATE])

The problem I am having trying to run this formula in a IF statement because I would like a COUNTD(DATE) for each year in a dataset.

For example I am trying to give me the number of days in 2013 by set on the filter using:

IF YEAR([StatDate]) = 2013 THEN COUNTD([DATE]) ELSE 0 END

and the same for 2012

IF YEAR([StatDate]) = 2012 THEN COUNTD([DATE]) ELSE 0 END

Ultimately I can have it work correctly if I put a YEAR filter in filter box but my YoY calculations do not calculate correctly.

Thanks,

Jerry

1. Re: Give me the number of days using COUNTD([DATE]) and only filter by year.

Shawn Wallwork Jun 17, 2013 7:37 PM (in response to Jerry Ward)

Jerry post a package (twbx) workbook with a bit of sample data and one of the text table guys are more likely to take a look.

--Shawn
Like Show 0 Likes(0)

Actions
2. Re: Give me the number of days using COUNTD([DATE]) and only filter by year.

Tracy Rodgers Jun 18, 2013 8:05 AM (in response to Jerry Ward)

Hi Jerry,

The calculations above should work, however, I'm unsure of the end goal. Do you want to see the YoY value for each year? By filtering out the year, it will change the data because the filtered out date won't be taken into account. If you can give a little more detail about the desired outcome that'd be great!

-Tracy
Like Show 0 Likes(0)

Actions

Tableau Community Forums