Hi GoddData Team! I'm currently porting a Power BI report to GoodData. I've played with GoodData for some time now to get an idea on how things are organized, however, I would really appreciate if could could help me with a jump start. I have data of real estate ads that is structured as follows (simplified): • Ad ID (INT) • Price (DECIMAL) • City (STRING) • First listed (DATE) • Delisted (DATE) This means that I have for every real estate ad the date it was first listed and the date it was listed last (delisted). Now I would like to create a chart that tells me how many ads were listed each day or what the average daily price per month was (e.g. take the average daily price of all available ads and calculate the monthly average). The question is how can I do this? Is there: a) a measure I could use to achieve this without the need for changing the model or b) do I have to create a separate table outside of GoodData that would include rows with the ad ID and "Active Date" for each day the ad was active and load this into the model? Could you please give a GoodData beginner some tips? Thanks!

Hi Martin, just to make sure I understand properly, in your result by “_how many ads were listed each day_” , do you mean how many ads • had the value of first_listed_date equal to that date • or how many ads had that date between their first_listed_date and delisted_date (incl. empty delisted_date). if it is the second one, then you are correct that you will probably need to expand your data in a table or a view to include row for each day when the ad was active, similar to this question in the community. Depending on which GoodData product are you using, in case of GD Cloud, you could do this also in a “SQL dataset” in your GoodData model (write a SQL query there), otherwise with GD Platform, you would need to do it in your database.

Thanks a lot @Michal Hauzírek for your quick response! This is exactly the answer that I was looking for! 👍