Group on measures not working

[Former Member]

Hi, I want to find out the most common values for field "x", and "x" is a measure with DECIMAL type. So I ran the following pass-through-sql, The output has only 1 record with some random value for "x". I know "x" has many different values. Can someone help? Thanks.

SELECT "x", count(*) as cnt

FROM "table1"

GROUP BY "x"

ORDER BY cnt DESC

[regdomaratzki]

Can you be more specific with your problem and include the schema of the table in question, the data in the table, the results you are seeing, and the verison and build number of the database engine that you are running?  The SQL below (using a recent build of 16.0.0) works fine for me.

 

Reg

PS: Apologies for the screenshot.  I was having trouble pasting text into the response for some reason.