How to obtain published time distributed data by month via BI Publisher
Is anyone aware of a method to return published time distributed data by month via bi publisher?
For context I am happy writing the query to return, let’s say the ‘resourceassignmentspread’ table as an example, the challenge is trying to return the time distribution by month, so a conversion from the current week setting.
I have considered switching the distribution interval from WEEK to DAY, but am not happy doing this due to table sizing and db bloating.
Also tried is deriving the month from the start and finish dates for the weekly interval, but of course some weeks do start in one month and finish in another, so that idea is void.