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     [CLOSED] InfoAssit GUI Compute Quartliles
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] InfoAssit GUI Compute Quartliles
 Login/Join
 
Member
posted
How do divide a column of data ranging from 100 to 10,000 into Quartiles and Percentiles? I don't see a function for this or something called "TILES"

Thanks
Robb

This message has been edited. Last edited by: FP Mod Chuck,


8.2
 
Posts: 18 | Registered: March 23, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I've never tried it but this might be helpful.

https://techsupport.informatio...cof/cof_tcn_073.html


WebFOCUS 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
An example of quartiles in code which creates the quartiles based on the DOLLARS field:

TABLE FILE ibisamp/ggsales
 PRINT SEQ_NO
      BY DOLLARS
      IN-GROUPS-OF 4 TILES
 END
 
App Studio Report Canvas supports this too:
Sort on the DOLLARS field, right-click it, and select Options....
In the pop-up window, select the Grouping tab and make your choices for the tiling you want.

I did not see any of these options in InfoAssist. I was able to get InfoAssist to produce quartiles by using hold files and computes. If you're interested, I can provide the code that InfoAssist generated for this.
 
Posts: 134 | Registered: October 19, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] InfoAssit GUI Compute Quartliles

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