November 01, 2017, 09:33 AM
BSBAL18Two 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 ??
November 01, 2017, 09:40 AM
MartinYquote:
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...
November 01, 2017, 09:50 AM
BabakNYCYou'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.