Graphical Reports (1 Viewer)

JMichaelM

Registered User.
Local time
Yesterday, 23:54
Joined
Aug 4, 2016
Messages
101
I figured out the data bars as well. THe problem I get when running comparing the records is "Cannot have aggregate function in expression (Min(Count(())) so perhaps I need to build a new query?
 

Mark_

Longboard on the internet
Local time
Yesterday, 23:54
Joined
Sep 12, 2017
Messages
2,111
I figured out the data bars as well. THe problem I get when running comparing the records is "Cannot have aggregate function in expression (Min(Count(())) so perhaps I need to build a new query?

Count counts up the total in a set. Min would return the minimum from a set.

It does look like you would need two queries, first to return you COUNT, then a second to return the minimum from your set.

I am guessing you are trying to count the total number of records that meet a criteria then work out your minimum and maximum values, correct?
 

JMichaelM

Registered User.
Local time
Yesterday, 23:54
Joined
Aug 4, 2016
Messages
101
Yes, the total comes from a count records query.
 

Users who are viewing this thread

Top Bottom