Hi, i was trying to create a metric type element inside Reports. and I want the total count of age in specific range. For example, I need to show total count of people who lie between the age of 10-20, then 20-30 and so on. But when i try to add the conditions then it was giving me the age of first person which it finds in the particular age group instead of total count.
Hey, if you want the total count you’ll need to aggregate your data with a sum function
https://docs.cortezaproject.org/corteza-docs/2023.9/integrator-guide/reporting/expr-reference.html#_aggregation
The metric only expects one value as an input, the load you have gives multiple results (all records that match the filter). Thats why metrics should be used with an aggregated datasource.