Merin Joseph

@David Beagan I Created the page in WF designer .

here is the code which i have related to this. at present this dropdown is not working after i chained the link. -PROMPT &ABC.(<'PROJECT',Project>,<'GLOBAL',Global>).Select.QUOTEDSTRING; -IF &ABC EQ 'PROJECT' THEN GOTO BY_PROJECT ELSE ENDSELECT ; -BY_PROJECT WHERE NEW_PROJECTNAME_ALPHA EQ &NEW_PROJECTNAME_ALPHA.(OR(FIND NEW_PROJECTNAME_ALPHA IN SHIELD/PROJECTS |FORMAT=A410V,SORT=ASCENDING)).PROJECTS:.; -GOTO ENDSELECT -ENDSELECT Full code-DEFAULTH &SUBSIDIARY = 1;-PROMPT &WFFMT.(<AHTML,AHTML>,<Excel,XLSX>).Format.QUOTEDSTRING;-PROMPT &ZRT.(OR(FIND ZRT IN ZRT_LISTING)).ZRT.;-PROMPT &ABC.(<'PROJECT',Project>,<'GLOBAL',Global>).Select.QUOTEDSTRING;-INCLUDE IBFS:/WFC/Repository/Shield/common_content/zrt_select_list.fex-RUN -*COMPONENT=Join_J001 JOIN CALLS.CALLS.CUSTOMERID IN SHIELD/CALLS TO UNIQUE CUSTOMERS.CUSTOMERS.ID IN SHIELD/CUSTOMERS TAG J001 AS J001 END-*COMPONENT=Join_J002 JOIN CUSTOMERS.CUSTOMERS.ID IN SHIELD/CALLS TO UNIQUE CUSTOMERADDRESSES.CUSTOMERADDRESSES.CUSTOMERID IN SHIELD/CUSTOMERADDRESSES TAG J002 AS J002 END-*COMPONENT=Join_J020 JOIN J002.CUSTOMERADDRESSES.ADDRESSTYPEID IN SHIELD/CALLS TO UNIQUE ADDRESSTYPES.ADDRESSTYPES.ID IN SHIELD/ADDRESSTYPES TAG J020 AS J020 END-*COMPONENT=Join_J021 JOIN J002.CUSTOMERADDRESSES.ADDRESSID IN SHIELD/CALLS TO UNIQUE ADDRESSES.ADDRESSES.ID IN SHIELD/ADDRESSES TAG J021 AS J021 END-*COMPONENT=Join_J005 JOIN CALLS.CALLS.CREATEDUSERZRT IN SHIELD/CALLS TO UNIQUE PROJECTS.PROJECTS.CREATEDUSERZRT IN SHIELD/PROJECTS TAG J005 AS J005 END-*COMPONENT=Join_J006 JOIN J005.PROJECTS.CREATEDUSERZRT IN SHIELD/CALLS TO UNIQUE SURVEYS.SURVEYS.CREATEDUSERZRT IN SHIELD/SURVEYS TAG J006 AS J006 END-*COMPONENT=Join_J007 JOIN J006.SURVEYS.SURVEYTYPEID IN SHIELD/CALLS TO UNIQUE SURVEYTYPES.SURVEYTYPES.ID IN SHIELD/SURVEYTYPES TAG J007 AS J007 END-*COMPONENT=Join_J008 JOIN CALLS.CALLS.ID IN SHIELD/CALLS TO UNIQUE CALLSURVEYANSWERS.CALLSURVEYANSWERS.CALLID IN SHIELD/CALLSURVEYANSWERS TAG J008 AS J008 END-*COMPONENT=Join_J009 JOIN J008.CALLSURVEYANSWERS.SURVEYQUESTIONID IN SHIELD/CALLS TO UNIQUE SURVEYQUESTIONS.SURVEYQUESTIONS.ID IN SHIELD/SURVEYQUESTIONS TAG J009 AS J009 ENDDEFINE FILE SHIELD/CALLS ZRT1/A4 = CALLS.CALLS.CREATEDUSERZRT; END TABLE FILE SHIELD/CALLS BY CALLS.CALLS.CALLNUMBER AS 'Call Number' BY CALLS.CALLS.STARTTIME/HMDYIA AS 'Call Time' BY J001.CUSTOMERS.ID AS 'Customer ID' BY J001.CUSTOMERS.NAME AS 'Store Name' BY J021.ADDRESSES.ADDRESS1 AS 'Store Address' BY J021.ADDRESSES.CITY AS 'Store City' BY J021.ADDRESSES.STATE AS 'Store State' BY J021.ADDRESSES.ZIP AS 'Store Zip' BY J005.PROJECTS.CREATEDUSERZRT AS 'ZRT' BY J009.SURVEYQUESTIONS.TEXT AS 'Questions' BY J008.CALLSURVEYANSWERS.ANSWER AS 'Answers'-IF &ABC EQ 'PROJECT' THEN GOTO BY_PROJECT ELSE ENDSELECT ;-BY_PROJECT BY J005.PROJECTS.NEW_PROJECTNAME_ALPHA WHERE NEW_PROJECTNAME_ALPHA EQ &NEW_PROJECTNAME_ALPHA.(OR(FIND NEW_PROJECTNAME_ALPHA IN SHIELD/PROJECTS |FORMAT=A410V,SORT=ASCENDING)).PROJECTS:.;-GOTO ENDSELECT-ENDSELECT WHERE STARTTIME FROM DT(&STARTTIME_YEAR_D_FROM.(|FORMAT=YYMD,LINK_TO=STARTTIME_YEAR_D_TO,TITLE='START_DATE').STARTTIME_YEAR_D From.QUOTEDSTRING) TO DT(&STARTTIME_YEAR_D_TO.(|FORMAT=YYMD,LINK_TO=STARTTIME_YEAR_D_FROM,TITLE='END_DATE').STARTTIME_YEAR_D To.QUOTEDSTRING); WHERE ZRT1 IN FILE ZRTFILE-* WHERE J007.SURVEYTYPES.ID EQ 1 ;HEADING "Activities" "From Call Date: &STARTTIME_YEAR_D_FROM To Call Date: &STARTTIME_YEAR_D_TO " "As of &DATE "-* "&NEW_PROJECTNAME_ALPHA"FOOTING "Title of the Procedure : IBFS:/WFC/Repository/Shield/Reports/Activities.fex" "Swisher International, Inc.<+0>________________________<+0>Confidential Information"ON TABLE SET PAGE-NUM NOLEADON TABLE SET ASNAMES ONON TABLE NOTOTALON TABLE SET AUTOFIT ONON TABLE PCHOLD AS 'Activities' FORMAT &WFFMTON TABLE SET HTMLEMBEDIMG ONON TABLE SET HTMLCSS ONON TABLE SET BYDISPLAY ONON TABLE SET STYLE *INCLUDE = IBFS:/WFC/Repository/Shield/common_content/Swisher_Shield_Theme.sty,$ENDSTYLEEND-RUN

Awesome. Thanks David. Thanks for sharing this document .

For example if i have selected a date range jan1st to end of Jan from a dropdown it displays a result. then i need another dropdown for 'compare to date:' were if I selected Feb 1st to end of Feb, then it should display another chart next to each other.

v8207

YES... This one is working @David Beagan​ . You have a swift problem solving skill. Thank you soo much..

when i run this same code, it actually looks like this. Looks like it doesn't support in my version. Isn't it?

no i just have only 1 level.. above is my requirement to get that 2nd level with month and year.. This is what i have now:code DEFINE FILE SHIPMENTS_HOLDSHIPDATE_DAY/I2 MISSING ON = DTPART(SHIPDATE_D, DAY);SHIPDATE_MONTH/I2 MISSING ON = DTPART(SHIPDATE_D, MONTH);SHIPDATE_YEAR/I4 MISSING ON = DTPART(SHIPDATE_D, YEAR);END GRAPH FILE SHIPMENTS_HOLDSUMQUANTITYINPRIMARY/D20.2C AS 'Quantity in Primary'-*BY SHIPDATE_DBY SHIPDATE_D NOPRINTBY SHIPDATE_DAY AS 'Day'BY SHIPDATE_MONTH AS 'Month'BY SHIPDATE_YEAR AS 'Year'HEADING----------------------------------------TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $TYPE=DATA, COLUMN=N3, BUCKET=tooltip, $TYPE=DATA, COLUMN=N4, BUCKET=tooltip, $TYPE=DATA, COLUMN=N5, BUCKET=y-axis, $

selection of dates is based up on webfocus date controls (combined)

I used ON TABLE SET AUTOFIT ON . No i didn't submitted yet. I will do it. Thank you.

Yes, Looks like. Thank you for your prompt response.

I tried the above code and still autofit not working with arversion=2. my version is 8207.28.08

instead of When i add 'SET ARVERSION = 2 , Im getting the result as i want but ON TABLE SET AUTOFIT ON is not working with that... how can i get this 2 together, the autofit and the first pagination format ? thank you.

@David Beagan​ awesome. this works. thank you soo much.

Can we do hover over on reference line which shows the label and value ? so i can not show them on chart.