Focal Point
Setting X-axis range with date field in Graph

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

November 21, 2005, 12:40 AM
Sridevi
Setting X-axis range with date field in Graph
I am trying to plot a line graph with
X-axis – a date filed
Y-axis – a numeric filed

Sum A By B
Across Date

The requirement here is the X-axis should range as per user input.
For example if the user selects range btw Jan 2005 and Dec 2005
The X-axis label should get displayed from Jan 2005 to Dec 2005.
There is no issue if the query that we use fetches data for all the months from Jan to Dec.
But when the query fetches data only for months from Mar 2005 to Aug 2005 the graphs gets
displayed only from Mar 2005 to Aug 2005 ie the X-axis labels displays from Mar 2005 to Aug 2005.
The requirement is, though there is no data for months Jan to Feb and Sep to Dec the X-axis label should still display them with no lines plotted.
I found that setY1ScaleMin() and setY1ScaleMax() accepts only double parameter.
Is there any way to set the X-axis range with date field.


Thanks & Regards,
Sridevi
Webfocus 7.6.5 | Windows |
HTML
November 21, 2005, 03:24 AM
Tony A
Sridevi,

Your solution lies not in the API but with your data. Look at a previous posting entitled 'dense or no data' or search on COLUMNS and ROWS.



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
November 21, 2005, 10:58 PM
Sridevi
Thanks Tony,

I handled this at the query level itself. I included some dummy records for the months which not fetched from the main query.


Thanks & Regards,
Sridevi
Webfocus 7.6.5 | Windows |
HTML