Display String Fields with queryAggregation

Kyle Jorgensen over 7 years ago

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?

Discussion posts and replies are publicly visible

Parents

0 Kyle Jorgensen over 7 years ago

The issue isn't with the user input (both are int), rather with queryAggregation being unable to handle text, in the attached mockup it would be the "Project Name" and "Division Fields". I need to display those fields, but aggregate the labor and material fields based on user input.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kyle Jorgensen over 7 years ago

The issue isn't with the user input (both are int), rather with queryAggregation being unable to handle text, in the attached mockup it would be the "Project Name" and "Division Fields". I need to display those fields, but aggregate the labor and material fields based on user input.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data