We need to show a few issue calculated properties as columns, and to filter the report by year (showing the measures by quarter and other dimensions). But the time domension have to consider the planned start date of the issues. For instance, we use the start and due date of issues to calculate the workdays between those days. Then we have planned start and planned end dates on the issues, and also a calculated member with that workday count. Then we have a thrird calculated member that is the difference between the planned days and the actual days. Those fields are shown fine. The problem we have is when we use the Time dimension as a page filter, year / quarter, it looks like is filtering issues by their created date, and not the planned start date (that is what we need), even when we don’t have any created date related measure selected, and even selecting a planned start date measure, the report data does not match (we select 2024 Q1 and see rows with planned start date in June for instance).
Any tips on how to troubleshoot this? Thanks!
Best regards