In Design view, how to use the Function pull down menu?

[Original_Memory6188]

how does one functions in the query design view in LibreOffice BASE (NOT in SQL)

The functions onesee in the menu (at the grid) in the query design view are:

Average
Count
Maximum
Minimum
Sum
Every
Any
Some
STDDEV_POP
STDDEV_SAMP
VAR_SAMP
VAR_POP
Collect
Fusion
Intersection
Group

Example I want a count of “Afrd IDX”
I click the funtion square and pick Count.
That is all I can do.
Error message is “Not in aggregate function or group by clause:”
Okay, now what?
Is it possible to use functions in Design View?

[RobertG]

Most of the functions will need a grouping of all other fields in the query. So if you set field “Afrd IDX” with function Count() you would only get counted all content if there isn’t chosen another field.

Let’s say you have another field “Person” in you query design. You have to choose “Group” for this field. So Count(“Alfd IDX”) will count the content for “Alfd IDX” for every “Person”.

By the way: COLLECT, FUSION and INTERSECTION won’t work with any of the internal databases. COLLECT is a special Oracle function. For FUSION and INTERSECTION I don’t know any database with this function…

[CRDF]

As I understand they are SQL Aggregate.
Did a test at the grid in a dummy DB here with STDDEV_SAMP:

SELECT "codigo", STDDEV_SAMP( "valor" ) FROM "Activities" GROUP BY "Activities"."codigo"

You must group other fields:
Function | Group
at the grid.