I originally posted this in the InfoAssist forum, but I didn't get any responses, so I figured I'd try here as well.

I'm working on building a line graph in InfoAssist (in 8002M) and running into a couple of issues. I've checked the documentation and FocalPoint, but I'm not able to find an answer, so I'm hoping that asking here might help.

The data set being used is a list containing 288 rows, which is one for every 5 minute interval during the day. The fields are the time of day (MEASURETIME) along with the count of items in a queue at that time (ITEMCOUNT).

The intention is to produce a line chart where the x-axis is the time of day (starting with the current time), covering the last 24 hours and the y-axis is the count of items in the queue. The x-axis should only display even numbered hours (due to size constraints of the graph, which should be around 150 x 590 pixels), with tick marks and grid lines shown for every hour.

My first attempt was to DEFINE some new fields in the data set, which included the hour value from MEASURETIME and the minute value from MEASURETIME. I then created another value on the data set that was only populated when the hour was even and the minute was 0 (DISPLAYHOUR). Then, on the graph, I added the MEASURETIME and DISPLAYHOUR to the x-axis and set the MEASURETIME to be hidden.

This works to only show the even hours once on the x-axis and keep the report sorted correctly. However, it only works when the graph is full size and I'm running it as HTML5. WHen the graph is resized, the values on the x-axis disappear. If I try formatting the graph as PNG, the values on the x-axis never show, regardless of the size.

Additionally, I can't get the grid lines to show for the hourly values. They either show at every record (based on MEASURETIME) or not at all.

Does anyone have any thoughts on how to fix these?

WebFOCUS 8.0.0.2
Windows, All Outputs

This message has been edited. Last edited by: <Kathryn Henning>,

Hi bsullivan,

I'd like to recommend opening a case on InfoResponse Online for this issue in order to work with someone on the specifics.

Regards,

Kathryn