2. ASPRunnerPro General questions
  3. [SOLVED]  Limitations of the charts ??
This topic is locked
[SOLVED]

 Limitations of the charts ??

 		4/7/2012 8:24:30 AM
ASPRunnerPro General questions
M
 Maurits author

Hi I have a problem or is it the limitations of charts...
I have to write a DB in access for a weather station....sigh
The record layout is:
[indent]ID...Pimary key in database

Number as number (Indexed, no doulbes)

RecordingDate (date-time) "eg: 07/04/2012 10:17:00"

All other field as Number/Double in DB

OutdoorTemperture as Number(Long...to store decimals)[/indent]
It is just a single table, been reading up to limitations...2Gb maximum data storage in single tables in Access.

I am looking to save 525,600 records(total minutes) per year..i know it is a lot in access but hey it can just cope.

This is all working, editing, adding, exporting, no problem there.
But now a few questions:
Is there a limitation in any of the charts for example...X=number Y=TempOutdoor

It is not working with "RecordingDate date:time format" stored in the database, but it does work with "Number"
As i do get an error when loading the chart:
Error Loading file: "dchartdata.asp?chartname=Weather_History_Chart&ctype="
Nothing else but it also takes a long time to load on the intranet with the value "Max bars on screen: 525,600" and then i get the above error message.
Is there in de charts a chart-type that does only lines with at the minute i use Area but there are some problems:

But all the charts shows dots with a value in the chart it self, like you get a an extra black line above the current data. I have tried to untick "Show values" but that also removes the values from the Y-Axis

Also if you move the mouse of the data, it shows an rounded "integer" instead of a decimal value.
Does anyone know a way round it or can you help me to get on the right track?
Please help...
Thanks
Sergey Kornilov admin 4/11/2012

Well, I don't think displaying more than 500K bars on the chart makes any sense. Anyway, if you want to learn about AnyChart limitations I recommend to check their website: http://anychart.com
M
 		Maurits author 4/11/2012



Well, I don't think displaying more than 500K bars on the chart makes any sense. Anyway, if you want to learn about AnyChart limitations I recommend to check their website: http://anychart.com


Looked on their website, but get Error 404 - Not found
But is thee a way to display like temperatures of a period of a year? Just as a single line?
Thanks
Sergey Kornilov admin 4/11/2012

Their website seems to be up now.
I'm not seeing any problems displaying temperatures on the chart. Are you facing any specific issues doing this?
M
 		Maurits author 4/11/2012



Their website seems to be up now.
I'm not seeing any problems displaying temperatures on the chart. Are you facing any specific issues doing this?


I can't find the right chart... with just "only smooth lines", without the dot(value) and if the dots on the line are there it is showing the interger eg 10 instead 9.8

But the problem is if you untick the box "Show Value" it deletes also the Y-Axis values...i have tried all sorts..
I am looking for a line chart with the following options as in the chart "Area" stacked but with one single series, but only want to do say Temp or only Humidity in different charts.

  • Simple smooth line only (no dots and values in or on top of the line)
  • Only show Y-Axis and X-Axis values, NOT on top of the bar or lines in the chart below
  • Also the rounding in the chart should NOT be done in DB interger, long and it is showing on the char as rounded integer.
  • only when you go over with the mouse pointer it should show and highlight the bar and show the value
  • It should show the whole year in minutes in a single smooth line, that is why i do have a large number of records as it records every minute the temp,etc.
    Also I can't get it to work with RecordingDate(Date:Time format in the database), at bottom where "Number" is this should be all dates and time, but it worked only with "Number" which is just an integer in the access table. Tried with RecordingTime (date:time in db) you just get one single dot in the middle of the chart, and that is it as in the SQL results all data is showing.... I have to call that strange
    Have alook at this picture you will see what i mean:
Sergey Kornilov admin 4/12/2012

In regards to values being rounded - make sure you select to display one or more digits after the comma when you setup your chart series.
In regards to using date or time values on X axis - post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. Probably this is something we can figure out once we see your data.