Hi Folks !
I'm reviewing GoodData, and of course I'm here cause I have some really basic questions.
To make the example easy, I'have a data set with 3 fields user, start end date (subscriptions base data). I'm trying to build a simple chart in which each MM-YY as (X axis) and count the active subscriptions (Y axis).
user | start | end |
---|---|---|
1 | jan-22 | dec-22 |
2 | jan-22 | mar-22 |
result would be (bar char):
2 | 2 | 2 | 1 | 1 |
jan-22 | feb-22 | march-22 | apr-22 | … rest of months ... |
The issue I'm encountering is that GoodData is associating the date with only 1 date field either start or end. How can achieve this?
I read date-attribute-arithmetic, if I understood correctly that won't solve my query, as it calculates the duration by a given granularity
Best answer by michal
View original