| Subject: | docs for using dates on X-axis are not clear |
Thanks for this module. It's a neat idea, looks useful, and clearly a
lot of work into it.
However, in my first attempt to use it, I could not get a basic chart to
be generated. It appears the system is supposed to support using dates
on the X-axis, but I only get an terse error message, and after several
passes of the documentation, it's just how clear I tell it to cope with
a date column.
This is using PostgreSQL 8.1.11 with DBD::Pg 1.49 as the backend. My
simple query was:
my $rsth = $dbh->prepare("
SELECT _creation::date as xdate, count(*) as y
FROM _issue
group by _creation::date
order by _creation::date
RETURNING linegraph(*)
where WIDTH=500
AND HEIGHT=500
AND X_AXIS='Some Domain'
AND Y_AXIS='Some Range'
AND FORMAT='PNG'
") || die $dbh->errstr;
The resulting error is:
DBD::Chart::st execute failed: Non-numeric domain value 2005-10-29. at
/usr/local/share/perl/5.8.8/DBIx/Chart.pm line 420.
Thanks,
Mark