Hi,
I try to build a report which would give a condense information on products usage over the last 3 months, last 6 months, and then similar last: 9, 12, 18, 24 months etc in one table where these usages over different times would be presented in seperate columns.
So far I was able to get only one column at the time by filtering the time dimention correctly. I guess I would have to code the time within the BQL expression seperately for every column.
I use a simple BQL expression to calculate usage (Normal Usage - Transfer Usage) . I have attached some snippets to show what I try to achieve.
I would be massively grateful if anyone could suggest the best approach/syntax.
