Stuck Adding Parameter to Custom Query

I followed the docs here …

But it doesn’t show how to add the parameter to the query?

Hey Brad. Are you looking for something other than typing in the name (:P1 in this case)?

No matter what I put in the WHERE statement I get an error.

The where clause comes before the group by.

Perfect! Knew it had to be something simple. Works like a charm. Thanks @mebeingken!

1 Like

I have a similar setup… my question is to find out how to use a custom query and add SUM to some of the fields. The other method of query we can use the Aggregate and Alias and create another ‘field’ name with SUM. Is something like this available to custom queries?

Yes, you can use SUM in your custom query. In my case I used COUNT but the syntax to use SUM is the same.

1 Like