I created some BAQ’s to track MTD sales, but am having trouble finding how to have it show the totals. Any guidance would be greatly appreciated!
Right click the grid at the top and choose show summaries.
If that’s not what you meant, please explain further.
I have been using advanced grouping that enable you to a total, average, etc. into the results (even highlight them easily on a dashboard)
In addition, subtotals can be done too.
Stay tune for the Midwest user meeting in February for this capability that I will be demonstrating.
PS - this functionality was in E9 and is still available in Kinetic UX.
1 Like
It annoying to me that I can’t just display, and potentially use (for currency conversion eg) the total of a column in a TransView column.
Here I am using two date pickers to set a date range to query invoices and labour entries within the range, storing these in TransView columns, and applying them to both grids via Grid Model, Provider, BAQ Options, Where clauses. This “Dashboard” created using the application wizard (see Basic Application Wizard no TransView - #7 by Carson) as opposed to the classic dashboard to Kinetic UI conversion process.
I thought I might be able to include a sum column in the BAQ via subqueries etc, but basically the BAQ WHERE clauses are applied to the BAQ as if its a subquery, so the totals have already been SUMmedbefore the WHERE is applied and thus not what I am after.
Yes i could do it with BAQ parameters, but they really don’t work terribly well as everytime you search, sort, filter, refresh, sum… the parameter slider appears.
I thought there might be an event to catch the loading of each row during the BAQ get, that I could intercept and do summing there, but nope, not as far as i can see at least.
Surely this is doable…somehow?
PS also, I only get the show summaries option in the actions list if I add the dataviews and grids in the application wizard; if I add the second one in application studio afterwards, There’s no “Show Summaries”, and no setting in the grid panel i could find to activate it