You can translate the question and the replies:

Configure fields to ungroup or group dates

I want to make an integration of data where I can manage the date, that is to say a type of query for a period of time. Weekly sales, monthly sales, among others. Greetings from Ecuador.
user
13-01-2020 09:47:03 -0500

2 Answers

Hi, I recommend creating a separate view for each of these cases; Denodo does not replicate the data so minimizing the number of views in a virtual database project is not necessary. To create these views, you can use the built in [Date Processing Functions](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions) to extract the day, month, and year for grouping. For example, to create a sales by month view you could create the columns “GETYEAR(<date_field>)” and “GETMONTH(<date_field>)”, and then order by these columns to get the number of sales for each month. Hope this helps!
Denodo Team
14-01-2020 07:23:22 -0500
Thank you very much, it served perfectly.
user
15-01-2020 13:57:06 -0500
You must sign in to add an answer. If you do not have an account, you can register here