Focal Point
[CLOSED] InfoAssit GUI Compute Quartliles

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3507012096

May 21, 2018, 05:43 PM
raff
[CLOSED] InfoAssit GUI Compute Quartliles
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
May 22, 2018, 07:57 AM
BabakNYC
I've never tried it but this might be helpful.

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


WebFOCUS 8206, Unix, Windows
May 30, 2018, 10:15 AM
dbeagan
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.