This content has been marked as final.
Show 2 replies
-
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
-
2. Re: Give me the number of days using COUNTD([DATE]) and only filter by year.
Tracy RodgersJun 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