Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.