Table isn't correctly grouping by Date

Get Help
1

Date is an unaggregated feild if it has more than one value at a point on the xaxis the values will be summed.
I have received the error on the top corner of my visualization a few times and each solution I've come to has been quite different. So any clarity how why it occurs would be much appreciated.

SELECT
    TO_CHAR(`Timestamp`, 'yyyy-mm') AS `Date`,
    COUNT(DISTINCT `id_punto`) AS `Number_of_Clients`,
    `linea_negocio` AS `Product_Offering`
    
FROM table

GROUP BY 
    `Timestamp`,
    `linea_negocio`
ORDER BY    
    `Timestamp` ASC

45
45778×658 43.9 KB
17
172288×670 65.4 KB

Many thanks for any insights.

2

Hi @solrac
You are grouping by Timestamp instead of Date, which is not the same thing, since you're manipulating it with TO_CHAR function.

3

You are totally right @flamber, sorry for wasting your time and thanks for the spot.