I am trying to calculate the number of issues deployed in a given two week time period with specific start and end dates.
I have selected “Issues with deployment date” as a Column measure.
I have selected All Times on the Time Dimension’s week hierarchy level - which is selected as a Row.
I added a time filter to filter between two given dates “Time between Dec 29 2019, Jan 12 2020”
I get the below table with right number of issues per week.
But my requirement is to combine these two rows (weeks) into one so that I can create a chart for each biweekly iterations.
Is there a way to do this using a calculated member or measure , could you please help ?
We are doing a POC and would like to figure this out so that we can go ahead with this tool ASAP.
Thank you for the help in advance.