I tried finding solutions on the forum but I can't seem to find the same problem. I am having trouble with set analysis.
Probably because I am trying to count the weeks within a date selection. However de data is obviously linked to the facts.
The expression to count weeks:
count({1<Year=$::Year,Month=$::Month,Quarter=$::Quarter>}distinct YearWeek)
This works fine without being put into a table with dimensions. In a text box it nicely displays 5 weeks voor August 2021.
However putting this into a table where there is only 1 order in 1 week it counts the weeks as 1 instead of 5.
| Week | Order |
| 1 | |
| 2 | Order no. |
| 3 | |
| 4 | |
| 5 | |
The avg deliveries per week --> 1 / count({1<Year=$::Year,Month=$::Month,Quarter=$::Quarter>}distinct YearWeek) = 1 instead of the expected 0.2. how to overcome this?
Thanks in advance
