User (Legacy) Posted November 6, 2000 Report Share Posted November 6, 2000 I have a sql statement that returns the following resultset DateTime Legend Value ---------------------------------------------------------------------------- ------------------------ Oct 1 2000 5:00AM MemPGFileUsage^^% 35.362959928720976 Oct 8 2000 5:00AM MemPGFileUsage^^% 37.303765531954511 Oct 15 2000 5:00AM MemPGFileUsage^^% 37.44519122320213 Oct 22 2000 5:00AM MemPGFileUsage^^% 37.246808014501248 Oct 29 2000 5:00AM MemPGFileUsage^^% 37.75940811167807 Oct 1 2000 5:00AM MemPhysUsage^^% 70.711202686131173 Oct 8 2000 5:00AM MemPhysUsage^^% 73.6383573868263 Oct 15 2000 5:00AM MemPhysUsage^^% 74.019691302705525 Oct 22 2000 5:00AM MemPhysUsage^^% 73.600927685435423 Oct 29 2000 5:00AM MemPhysUsage^^% 74.776226380684818 Oct 1 2000 5:00AM MemVirtualUsage^^% 9.5146011294756256 Oct 8 2000 5:00AM MemVirtualUsage^^% 9.4410242157835764 Oct 15 2000 5:00AM MemVirtualUsage^^% 9.6082678376442558 Oct 22 2000 5:00AM MemVirtualUsage^^% 9.6050705628849968 Oct 29 2000 5:00AM MemVirtualUsage^^% 9.6897064018917103 I have been trying to get the DataType and DataStyle properties to get what I want before I give this resultset to AdoResultSet method. However, I have had no success in getting a graph that is even close to what I want. Below are the configurations on what I am trying to do. If anyone has any ideas on how to do this with adoresultset let me know. Configuration. Construct n series based on Legend's distinct values. In this case n would be 3. Construct m data points for each series based on the distinct values in datetime for each series. In this case m would be 5. Populate data values with the values field. Thanks. Jonathon P. Gladieux Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.