first of all: I am new to eazyBI, so please excuse wrong/irritating terms considering the eazyBI concepts.
In my project, I am importing data from jira tickets to eazyBI. These tickets all have a label of the pattern: xxxxyyzz where xxxx is year, yy is calender week and zz is a specific number of a test. For Example the label 20184402 would be year: 2018, calenderweek: 44 and test number: 02.
What I would like to have is a report with dimension Time as Page. I am not interested in when the tickets were created in jira. I’d rather like to choose for example only the tickets from calenderweek 42 to 45 in 2018 (so 201842zz to 201845zz, independant of test number) and show them in a report.
I would also like to cluster the weeks in quarters Q1, Q2, Q3, Q4.
It doesn’t neccessarily have to be in dimension time, but I thought this would maybe fit best.
In my report I want to have Members of “Labels” in Rows and “Project” or “Measures” as Columns.
I am thankful for every useful hint.
Thank you in advance!