Is it possible to build a bar chart in InfoAssist with 4 different data points (bars) with date beginning and ending prompts that control only 2 of the 4 bars on the chart?

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

Teri
create 2 seperate hold files and then use the more command to combine them in the graph statement.

I can write it against the car file if you need me to.

J.L. that would be very helpful and I would appreciate that. I do need it to be done so that a user will be able to open and edit within InfoAssist.

Thank you!

Teri
Here's one that works using the fildef.
I wanted to get back to you with something as I'm not going to have a chance to work on this till later.

FILEDEF XYZ DISK xyz.ftm
DEFINE FILE CAR
ALPHA/A3=IF COUNTRY LT 'G' THEN 'A-F' ELSE 'XXX';
END
TABLE FILE CAR
COUNT CAR
BY ALPHA
ON TABLE HOLD AS 'xyz'
END
FILEDEF XYZ DISK xyz.ftm (APPEND
DEFINE FILE CAR
ALPHA/A3=IF COUNTRY LT 'M' THEN 'A-L' ELSE 'XXX';
END
TABLE FILE CAR
COUNT CAR
BY ALPHA
ON TABLE HOLD AS 'xyz'
END
FILEDEF XYZ DISK xyz.ftm (APPEND
DEFINE FILE CAR
ALPHA/A3=IF COUNTRY LE 'Z' THEN 'A-Z' ELSE 'XXX';
END
TABLE FILE CAR
COUNT CAR
BY ALPHA
ON TABLE HOLD AS 'xyz'
END
TABLE FILE xyz
BY ALPHA
PRINT CAR
WHERE ALPHA NE 'XXX';
END

Unexpected break and easier than I remembered
This is probably the option you want to use.
Just get rid of the defines and use a where statement to limit what goes into the hold file.


DEFINE FILE CAR
ALPHA/A3=IF COUNTRY LT 'G' THEN 'A-F' ELSE 'XXX';
END
TABLE FILE CAR
COUNT CAR
BY ALPHA
ON TABLE HOLD AS 'HOLD1'
END
DEFINE FILE CAR
ALPHA/A3=IF COUNTRY LT 'M' THEN 'A-L' ELSE 'XXX';
END
TABLE FILE CAR
COUNT CAR
BY ALPHA
ON TABLE HOLD AS 'HOLD2'
END
DEFINE FILE CAR
ALPHA/A3=IF COUNTRY LE 'Z' THEN 'A-Z' ELSE 'XXX';
END
TABLE FILE CAR
COUNT CAR
BY ALPHA
ON TABLE HOLD AS 'HOLD3'
END
TABLE FILE HOLD1
BY ALPHA
PRINT CAR
WHERE ALPHA NE 'XXX';
MORE
FILE HOLD2
MORE
FILE HOLD3
END