topic How to use one expression inside another expression in Set Expression in App Development

How to use one expression inside another expression in Set Expression

pankaj286 — Fri, 24 Sep 2021 16:44:58 GMT

Hi,

How can i use one expression inside another expression in Set expression. I want to count of model numbers where average rating of a model number should be greater than 3? We have multiple rating for one model number, we take average of all those rating. Please let me know if need any other detail.

Re: How to use one expression inside another expression in Set Expression

JuanGerardo — Sat, 25 Sep 2021 17:37:11 GMT

Hi @pankaj286 based on your description, it could be something like this:

Count({<Rating = {"=Avg(Rating)>3"}>} Distinct ModelNumber)

But if you send same sample data with the exact problem you have, it could be easier to have a response.

Re: How to use one expression inside another expression in Set Expression

pankaj286 — Mon, 27 Sep 2021 06:36:31 GMT

Thanks JG.

To explain my query i am putting a snapshot of the sample data. In below snapshot i have 4 models and their rating. If you take average of rating of each model, only the last model have average rating greater than 3. So i am expecting result.

Model with average rating>3/Total model,

so in this case: 1/4=25%

I hope this should clear the requirement. Please let me know if need any other detail.

Re: How to use one expression inside another expression in Set Expression

tresB — Mon, 27 Sep 2021 07:53:13 GMT

Try like:

Count({<ModelNumber = {"=Avg(Rating)>3"}>} Distinct ModelNumber)