Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Display aggregated field in header of multi-graph in InfoAssist
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Display aggregated field in header of multi-graph in InfoAssist
 Login/Join
 
Member
posted
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]multi-Graph-aggregation[/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 above

This message has been edited. Last edited by: lsteff,


WebFocus 8205
Linux Intel/AMD
InfoAssist
 
Posts: 2 | Registered: January 17, 2020Reply With QuoteReport This Post
Member
posted Hide Post
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.


[IMG:left] [/IMG]


WebFocus 8205
Linux Intel/AMD
InfoAssist
 
Posts: 2 | Registered: January 17, 2020Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Display aggregated field in header of multi-graph in InfoAssist

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.