I am trying to create a line chart that shows the percentage of the people a specific user has seen in the last 6 weeks at any point in time. So for example: User A has 100 people assigned and I wanna see how many of him he has seen in the last 6 weeks at any day I select (dynamic trellis?!)
The part I am stuck is that I my expression shows me the percentage per date and not the last 6 weeks. I tried if statements and set analysis in lots of different ways and I just can't make it work. Here the expression iuse at the moment:
1. if(Week>=weekstart('$(vMaxDate)'),Week) //shows the last 6 weeks. the requirement is to show the last 6 weeks, but look back 6 weeks at any of the week shown in the graph. So if we see the calendar week 10- 16, week 10 would have to show the value of week 4-10
2. User ID
I hope that makes kind of sense. If you need more information, let me know.
I have worked on the problem and made it at least kind of work. Attached is an sample, I tried to comment as much as possible in the short time. Hope that helps you to understand what I did, what i am doing and where I try to go to.