To GoodData homepage

Replies posted by mares

5 Replies

mares
maresParticipating Frequently
asked in Data models

Model query

Hi @Iva Gasparekova , apologise for the delay on my response. I've read the articles you mention, seems my model was setup "correctly", as I'm able to play around with all dataset with the designated id. Thanks in advance for you help !

2
mares
1 year ago
mares
maresParticipating Frequently
asked in Dashboards and Reports

Start End Date bar chart by Months

Hi @michal, thanks for the confirmation, it's most helpful, I ended doing exactly what you mention. -- demoSELECT *FROM ( SELECT SEQUENCE( --creates an array seq based on (start & end) * interval type current_date, date_add('year', 1, current_date), INTERVAL '1' MONTH ) AS seq_month)CROSS JOIN unnest(seq_month) AS auto_gen(month)Basically the code above  (representation) generates a row by the interval you specify. Wanted to share the approach as it might help someone else topping with the same issue.Thanks again for the insights @Moises Morales & @michal 

8
mares
1 year ago
mares
maresParticipating Frequently
asked in Dashboards and Reports

Start End Date bar chart by Months

Hi @Moises Morales I do really appreciate the help. Unfortunately, I already tried that. The result of it, is that when using date as X-axis on (what you mentioned, "view by"), you need to associate one of the 2 dates, start or end. When dragging the date to view by, GoodData UI forces you to select which field do you want to use. As per my model start or end date. Which using either of them would not resolve the KPI. Given my first post example: user start end 1 jan-22 dec-22 2 jan-22 mar-22 Using start date as view by the outcome would be the following: please take reference that bold values wouldn't even appear, as there are no subs which starts on other months. 2 0 0 0 0 jan-22 feb-22 march-22 apr-22 … rest of months ...  Using end date (same explanation as above). 0 0 1 0 1 jan-22 feb-22 march-22 … rest of months ... dec-22   Maybe GoodData does not handle out of the box this specific scenario. I tried to create a dissociate

8
mares
1 year ago
mares
maresParticipating Frequently
asked in Dashboards and Reports

Start End Date bar chart by Months

Here's how my model looks like, which I think is fairly simple. Above you can see I got, "subscriptions" table, just for context, a subscription has 2 records (subscription_type), one period status trial and subscribed with their own period start and end. A user can have several subscriptions over the years (just wanted to clarify that there's no primary key here). I would like to replicate something similar to the following image, month-year contains all subscriptions that are in between start and end (red are trials, and blue are subscribed users). Meaning a user can be in several months-year I would really appreciate some advice on how could I achieve this, as reading the doc's / forum could not find any example.

8
mares
1 year ago
mares
maresParticipating Frequently
asked in Dashboards and Reports

Start End Date bar chart by Months

HI @Moises Morales thanks for reaching out so shortly. Currently I'm really novice, experiencing the tool and still reading the doc from GoodData. An example of a posible MAQL would be the following.SELECT {label/date.month}WHERE {label/date.month} BETWEEN {label/start_timestamp.month} AND {label/end_timestamp.month}Unfortunately as I stated, when trying to create a simple bar chart where I would display MM-YY (X axis) and the amount of actives subscriptions (Y-Axis), the X axis is associated with 1 of the two date fields (start or end) rather than using a calendar.While creating the above metric, can not use it as a dimension naturally. Additionally date.month is a data island with no relationship at all in DML, thinking GoodData would do a cross join between both and come up with the result. Can not seem to grasp how to accomplish my original query.Any thoughts? 

8
mares
1 year ago
Welcome to the GoodData Community!Cookie settings