Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like:
Count({<ModelNumber = {"=Avg(Rating)>3"}>} Distinct ModelNumber)
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.
JG
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.
Try like:
Count({<ModelNumber = {"=Avg(Rating)>3"}>} Distinct ModelNumber)