Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Setting X-axis range with date field in Graph

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Setting X-axis range with date field in Graph
 Login/Join
 
Sridevi
Silver Member
posted
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
 
Posts: 36 | Location: India | Registered: October 06, 2005Report This Post
Tony A
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Sridevi
Silver Member
posted Hide Post
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
 
Posts: 36 | Location: India | Registered: October 06, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Setting X-axis range with date field in Graph

Copyright © 1996-2020 Information Builders