Display String Fields with queryAggregation

I am building a budget report that displays budget data (which is tracked and stored by quarter) by project.

I have a requirement to be able to display the total budget per project for a specific year and quarter that a user inputs. See attached for a mockup of what I am looking for.

I have a DB view configured to display information about a project grouped by Project, Year, and Quarter. I am then trying to use query aggregation to sum budget values based on user input, however I am running into an error when I try to pass string fields through the queryAggregationColumn function using "MAX" or "MIN". Any idea of how to display string values alongside decimal values that are aggregated based on user input?

OriginalPostID-257488



  Discussion posts and replies are publicly visible

Parents Reply Children
No Data