Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Bar Graph error: Unable to use text data to render numerical/datetime axis
kbpeavey
My stacked bar chart renders just fine initially, but as I continue to refine the presentation, I get an error "Unable to use text data to render numerical/datetime axis". My X-axis is a string (row["RequesterOrg"]) with grouping enabled for Type=text, Interval=1, and AggExp=Count. Further, I'm doing an optional y-series grouping on another string (row["Priority"]). As I said, initally, the graph renders just fine, displaying the data exactly as I expect to see, but after making a few additional edits on the Format Graph tab, the graph rolls over dead on me. This is a repeatable event. Any ideas?
Find more posts tagged with
Comments
Virgil Dodson
What are you plotting on the Y-axis... and you should know that each Series on the Y-axis can change the default grouping aggregration of COUNT that you are using so you should check each series for that. I created a similar example that counted a text field on the y-axis. It is available at the thread below.<br />
<br />
<a class='bbc_url' href='
http://www.birt-exchange.org/forum/using-birt-maximo/16011-birt-2-1-2-chart-error.html#post51221'>http://www.birt-exchange.org/forum/using-birt-maximo/16011-birt-2-1-2-chart-error.html#post51221</a>
;
kbpeavey
The x-axis is the submitting organization (string) and the y-axis is a count of the submitted tickets grouped by severity level (string). Initally, this chart works as expected but from time to time (usually after editing the chart format) I get the error. I've been able to "correct" the error by removing the x-axis (derived from my report's table), saving the chart, then reapply the x-axis.
Virgil Dodson
That sounds like a bug. Do you mind reporting that at <a class='bbc_url' href='
http://www.birt-exchange.org/bug-reporting/'>Business
Intelligence Software - Reporting Tools - BIRT Exchange</a>
kbpeavey
Just came across a tech note on IBM website that states this is a known condition being tracked by BIRT project. <br />
<br />
<a class='bbc_url' href='
http://www-01.ibm.com/support/docview.wss?rs=988&context=SSSH5A&context=SSCSP7T&context=SSSTY3&context=SSCSNZN&context=SSSTWP&context=SSCGQ7B&context=SSCGQ7D&context=SSDV2W&q1=BIRT&uid=swg21321447&loc=en_US&cs=utf-8&lang=en'>IBM
- BIRT Editor resets x-axis type to Linear causing problems</a><br />
<br />
<br />
<a class='bbc_url' href='
https://bugs.eclipse.org/bugs/show_bug.cgi?id=222265'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=222265</a>
;
kbpeavey
Fixed in 2.3
Virgil Dodson
Thanks Keith for updating the thread with these details.