Unable to create report based on aggregated data source

💻 Core Engineering
#1

I want to create a bar chart in report builder based on aggregate data source of a module:

image
image618×904 58.6 KB

my data sources are:

  1. First I am loading Lead module

  2. Create Aggregate Data Source
    In this I am using previous source of loaded Lead module

then I am grouping this by field name source in Lead module
and aggregating count of leads, and sum(amount)

However, after creating this block it says error:
Failed to run report: Request failed with status code 500

Why I am getting this error any help would be appreciated.

#2

https://docs.cortezaproject.org/corteza-docs/2023.9/integrator-guide/reporting/index.html#ds-group-group-by

Take a look at those docs, you’ll see you must define at least one groupBy element. Add a column you want to group by, your expression is missing.

#3

ok thanks got this one.

#4