I am having trouble showing a specific group of customers. My data is organized in the following way - each week represents a cohort. I have a calendar table with the cohort name and start day. What I want to do is count and show only the customers from the last week in a table with no dimension. I tried
=
count({<Starts = {'$(="5/3/2010")'}>}line_id)
where Starts is the Start Day and line_id is the customer identifier. The code works if I use the cohort name, but I don't want to, as it will change each week. Any ideas where would be the problem?
Thank you!
