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] Limit issue in Visualization (Info-Assist+)
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Limit issue in Visualization (Info-Assist+)
 Login/Join
 
Platinum Member
posted
Hi All,

I have created a visualization (Info-assist+) for bar chart and now i want to show top 5 cars by sales (using car sample file) but I am unable to apply limit in the visualization , Limit option is disabled . Is this any configuration issue with my machine or we can not limit the data points in visualizations.

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


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I think that's by design. You can still sort but in visualization mode, the end user can determine what part of the chart they want to include or exclude by brushing the mouse over the bars they want to keep.


WebFOCUS 8206, Unix, Windows
 
Posts: 1742 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Still not an elegant solution, but is that what you're looking for (or similar to this) ?

TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
BY CAR
ON TABLE HOLD AS TMP FORMAT FOCUS
END
-RUN

TABLE FILE TMP
SUM RETAIL_COST
BY HIGHEST RETAIL_COST NOPRINT
BY TOTAL COMPUTE RNK /I2 = RNK + 1; NOPRINT
BY COUNTRY
BY CAR

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     
     DEFMACRO=RANKGE6,
     MACTYPE=RULE,
     WHEN=RNK GE 6,
$
     GRAPHTYPE=DATA,
     COLUMN=N5,
     GRAPHCOLOR='BLACK',
$
     GRAPHTYPE=DATA,
     COLUMN=N5,
     GRAPHCOLOR='WHITE',
     MACRO=RANKGE6,
$
ENDSTYLE
END


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2261 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
till not an elegant solution, but is that what you're looking for (or similar to this) ?


Hi Martin ,

Thanks for your quick reply ,
Actually i was creating visualization(bar chart) and below is the sample code of my visualization
In this i need to show only top 5 values,

  SET UNITS=PIXELS
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET EMPTYREPORT=ON

SET ARGRAPHENGINE=JSCHART

COMPOUND LAYOUT PCHOLD FORMAT AHTML
SECTION=Section_1, LAYOUT=ON, PAGESIZE=E, ORIENTATION=PORTRAIT, SHOW_GLOBALFILTER=OFF, ACTIVE_UNITS=PTS, PAGECOLOR=RGB(255 255 255), ARGRAPHENGINE=JSCHART, $
PAGELAYOUT=1, NAME='Page 1', TEXT='Page 1', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=Cache_1, COMPONENT-TYPE=REPORT, POSITION=(1.0 1.0), DIMENSION=(3.0 4.0), HIDDEN=ON, ARFILTER_TARGET='*', METADATA='VERSION:1.0', $
COMPONENT=Chart_1, COMPONENT-TYPE=GRAPH, POSITION=(0.0 0.0), DIMENSION=(100.0% 100.0%), ARREPORTSIZE=DIMENSION, ARFILTER_TARGET='*', METADATA='VERSION:1.0', $
OBJECT=HBOX, NAME='HBox_1', CONTENT='Chart_1', POSITION=(0.0 0.0), DIMENSION=(100.0% 100.0%),$
END

SET COMPONENT=Cache_1
-*component_type report
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ibisamp/car
PRINT CAR.ORIGIN.COUNTRY
WHERE RECORDLIMIT EQ 1
WHERE READLIMIT EQ 1
HEADING
""
ON GRAPH PCHOLD FORMAT PDF
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET WEBVIEWER ON
ON TABLE SET ARCACHEMODE NOEXTRACT
ON TABLE SET EMBEDHEADING ON
ON TABLE SET PREVIEW ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='WebFOCUS InfoDiscovery', HIDDEN=ON, PAGESIZE=E, AR_SHOW_MENUBAR=POPOUT, ARCACHEINCLUDE='', ARGRAPHENGINE=JSCHART, $
ENDSTYLE
END

SET COMPONENT=Chart_1
-*component_type graph
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE ibisamp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.SALES
BY TOTAL CAR.BODY.SALES NOPRINT
BY CAR.COMP.CAR
HEADING
""
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET WEBVIEWER ON
ON GRAPH SET ARCACHEMODE NOEXTRACT
ON GRAPH SET EMBEDHEADING ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET HAXIS 100.0
ON GRAPH SET VAXIS 100.0
ON GRAPH SET PREVIEW ON
ON GRAPH SET UNITS INCHES
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENID_Default.sty,$
TYPE=REPORT, TITLETEXT='Bar Stacked1', PAGESIZE=E, AR_SHOW_MENUBAR=POPOUT, ARREPORTSIZE=DIMENSION, ARFILTER_TARGET='*', CHART-ORIENTATION=VERTICAL, CHART-SERIES-LAYOUT=stacked, ARGRAPHENGINE=JSCHART, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);

*END
ENDSTYLE
END

COMPOUND END



WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
Originally posted by BabakNYC:
I think that's by design. You can still sort but in visualization mode, the end user can determine what part of the chart they want to include or exclude by brushing the mouse over the bars they want to keep.


Thanks Babak I tried this in other users machine , and all user has limit option disabled .
I think you are right that's by design .


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
You could do the aggration before:

TABLE FILE CAR
SUM SALES
BY HIGHEST 5 TOTAL SALES
BY MODEL
ON TABLE HOLD AS BLABLA FORMAT FOCUS INDEX MODEL
END

And inner join to it with your visualisation. Note that this migth have some performance challanges.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 414 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Frans,

It does not works , As i am creating Visualization,

Login to Client--> select Domain --> Right click --> new--> select Visualization .

Here i want to apply limit.


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Chaudhary

Visualizations a different paradigm and are meant for data mining if you really want to apply a limit without creating a hold file first then just do a chart


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1723 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Limit issue in Visualization (Info-Assist+)

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