[SOLVED] Display aggregated field in header of multi-graph in InfoAssist
I am looking for a way to display aggregation in EACH header of a multi-graph chart in InfoAssist. Rather than a SUM or CNT of the total chart results, we would like each section of the multi-graph to SUM or CNT only the results for that section (by the multi-graph field).
I have found that: 1. TOTCNT. placed in the Page Header accurately returns a total count of all results so that each section displays the exact same total count. 2. CNT. placed in the Page Header returns just a count of the first result, so each section displays "1" in the header. 3. SUM. placed in the Page Header returns just null and displays a period "." in the header of each section
A sample chart would use the following fields, formatted as a horizontal bar multi-graph with color by. Measure field = CNT.'Tickets' Multi-graph field = 'Work Group' Color by field = 'Ticket Status'
sample image: [IMG:left][/IMG]
Data Work Groups: 3 total Group A, Group B, Group C
Tickets: 85 total Group A = 1 ticket Group B = 5 tickets Group C = 79 tickets
Ticket Status: 10 total Status 1, Status 2...Status 10 *tickets divided amongst multiple statuses per Work Group; please view image link aboveThis message has been edited. Last edited by: lsteff,
WebFocus 8205 Linux Intel/AMD InfoAssist
January 20, 2020, 03:55 PM
lsteff
The solution we discovered is to create a compute to use in the header.
For a simple bar chart without color-by field, the solution was to create a 'c_cnt_tckt' compute with CNT.'Ticket' as the logic, then display c_cnt_tckt in the page header.
For a bar chart with color-by field, the solution was to create a 'c_partition' compute with PARTITION_AGGR(CNT."Ticket", "Work Group", B, E, SUM ) as the logic, then display c_partition in the page header and hide it on the horizontal axis.