Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Group average values from [Fecha_Hora] per hour!!!

People.

I have a very large table with a lot of records, where records are inserted per minute.

Fr4ncoFerr3r_0-1651758965323.png

I need to create a table from this, grouping the AVERAGE values per hour. That is, average the 60 values of the field value_1 at the time 04-05-2022 16:00. But, grouping from the [Fecha_Hora] field of the table. I don't want to add the column:

CONVERT((FORMAT (data_xample[Fecha_Hora], "dd-mm-yyyy hh:00:00")),DATETIME) to group the values into a table.
Fr4ncoFerr3r_1-1651759857804.pngFr4ncoFerr3r_2-1651759881445.png

How do I group by [Fecha_Hora]?

  • amitchandak's avatar
    amitchandak
    4 years ago

    Syndicate_Admin , I think you need to have to create that column, Now instead of a column, You can use selectcolumns in summarize. In selectcolumns  you can give expression for each column

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Syndicate_Admin , I think you need to have to create that column, Now instead of a column, You can use selectcolumns in summarize. In selectcolumns  you can give expression for each column

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi， Syndicate_Admin 

    As mentioned by amitchandak , you have to create the column.

    If you want to call the function 'SUMMARIZ' to summarize data based on a column, your column must be a specific column and can not be an expression.

     

    Best Regards,
    Community Support Team _ Eason