Focal Point
Two Charts showing different WEEK starts

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

November 01, 2017, 09:33 AM
BSBAL18
Two Charts showing different WEEK starts
I have two charts that use the same master file, and only one MAS file. There is a DEFINE in the master file that DTRUNC(REPORT_DATE, WEEK). Neither chart does any kind of SUM or aggregate, however when i put the Report WEEK field as the slider, in one chart, it shows 10/22 and the other chart it shows 10/23 as the week start date. Any idea why ??


AS Version: 8201
Gen: 10202016
Windows, All Outputs
November 01, 2017, 09:40 AM
MartinY
quote:
in one chart, it shows 10/22 and the other chart it shows 10/23 as the week start date. Any idea why ??


Is this only from AS or at run time ?
Pay attention that AS may only show SAMPLE data.

quote:

Neither chart does any kind of SUM or aggregate


But have BY field and may have WHERE clause ?

As usual, sharing your code may help a lot to understand...


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
November 01, 2017, 09:50 AM
BabakNYC
You'll have to expand on the question by telling us what the difference is between the two charts. Are they both running on the same instance of WebFOCUS? Do they point to the same exact dataset? Are there lines of code that redirect your chart a different connection? How did you create these charts. Anything you can tell us that would shed light on the difference between the two will help.


WebFOCUS 8206, Unix, Windows