November 21, 2005, 12:40 AM
SrideviSetting 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.
November 21, 2005, 03:24 AM
Tony ASridevi,
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.
November 21, 2005, 10:58 PM
SrideviThanks Tony,
I handled this at the query level itself. I included some dummy records for the months which not fetched from the main query.