compare periods

[curiousfellow]

Our admin_year runs from march 1 to march 1

People can enroll from 1 year before  start admin_year to 1 year after start of admin_year

a table contains  admin_year,date of enrollment  and subscribernr  for every enrollment

A subscriber can re-enroll for each year

I have a listbox containing weeknumbers  This refers to a table with weeknumbers and enddate of that week for last admin_year (starting one year before start admin_year)

Now want a chart that compares the number of enrollments until a selected weeknumber

Admin_year is a dimension

My expression does not seem to work and I don't know why,

count(distinct{< weeknumber = , otherfield= {"= date_enrollment <  addyears(weeknumbers.enddate, admin_year - last_admin_year"}>}subscribernr)

[QFabian]

Hi @curiousfellow , you can create a line chart using admin_year and weeknumber as dimensions, and  one expression like 'count(subscribernr)', i can´t see why are you using set analysis, please explain.

[curiousfellow]

I want  to select a weeknumber because the weeks of previous periods have passed, so for those years I have about 104 weeks while for example for this  year 25 weeks have passed. Besides that I have more dimensions in my chart.

I want to show the values.