Chart on date range

[jay@bplogix.com]

How do I set up my charts so that it correctly plots values across a date range?
For instance , if my data is
Date Amount
1/1/2010 100
1/2/2010 110
1/7/2010 120
1/14/2010 190

I would like to display the Amounts as the Y axis, with the dates as the X axis. I need the X-axis to have the correct spacing ... basically it needs to fill in the date ranges automatically. I also do not "know" the date ranges ahead of time ... it is variable in the data.

Thanks!

[Alex K.]

Hello,

Unfortunately, on current moment, it is not possible for datetime type in charts.

Thank you.

[jay@bplogix.com]

I guess I am a little surprised ... there is no way to plot values over a timeline? I have a list of invoices with an amount and date ... I would like to show a bar chart or line chart of total sales per month over the year. Are you saying there is no way to do that?? (some months may have zero sales so that month would be charted as a zero value rather than simply leaving the month out).

I would have thought this was a very common type of chart (bar chart, line chart, points). Is this something that is planned for the future?

thanks,
Jay

[Alex K.]

Hello,

On the curreny moment, we are very actively working of charts improvements.
We have added your request to our to-do list.

Thank you.

[jay@bplogix.com]

Is there any new ability to create charts based on date ranges?

Basically I just want to have a bar or line chart that shows how many items per month. For example, with an input data of
DATE (date column) NAME (string column)
----- -----
Jan-1-2011 abc
Aug-21-2011 def
Mar-11-2011 xyz
Jan-21-2011 abc
Feb-23-2011 def
May-16-2011 xyz
May-3-2011 abc

I want a chart (bar or line) that shows a count of rows that occured in each month like this:

Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
2 1 1 0 2 0 0 1 0 0 0 0

Thanks!!

[HighAley]

Hello.
[quote="jay"@bplogix.com]Is there any new ability to create charts based on date ranges?

Basically I just want to have a bar or line chart that shows how many items per month. For example, with an input data of
DATE (date column) NAME (string column)
----- -----
Jan-1-2011 abc
Aug-21-2011 def
Mar-11-2011 xyz
Jan-21-2011 abc
Feb-23-2011 def
May-16-2011 xyz
May-3-2011 abc

I want a chart (bar or line) that shows a count of rows that occured in each month like this:

Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
2 1 1 0 2 0 0 1 0 0 0 0[/quote]
Charts couldn't group and count data rows. In this case it's better to use DataSource from other DataSource where you could prepare data for chart.

Thank you.

[jay@bplogix.com]

I want to create a report that shows counts the number of results in the last 12 months.

How can this be done with DataSource from other DataSource?

Thanks

[HighAley]

Hello.

Sorry for the delay with response. We need some additional time to prepare the answer for you.

Thank you.

[HighAley]

Hello.

Unfortunately, it's impossible to prepare data with DataSource from other DataSource.
You should prepare it before passing to report.

Thank you.