I have MongoDB repository with some fairly complex documents. The gist of the doc is that it has lists of number that I want to create a chart from. For example:
{
fieldA,
x:[0,1,2,3,4,5,6...],
y:[2,4,8,...],
fieldB
...
}
I'd like to chart the x list vs the y list. We're using the AWS variant of the reporting tool and it doesn't support creating topics directly so I'm using iReportDesigner and writing the query with the fields I want back (x, y) in this example. I then upload the document to AWS Jaspersoft and use that as the topic. When I go to create the chart on the web frontend I get this error below. I have a double whammy n00b scenario as I am newish to both Mongo and Jasper and I'd appreciate any pointers.
Hi, I am having converting string to date and integer. In mongodb both date and numbers stored as string. During chart creation, I put date string as X axis and number string as y axis. But ireport is complaining that it can't convert string to date. Anyone know how to convert date string to java.util.Date so that chart can display date as x-axis. Similary how to convert string to integer so taht chart can display y axis with integer value.
Hi,
Does the query works when using iReport.
To work with our MongoDB connector you will need to use our query language, you can find more information here: http://community.jaspersoft.com/wiki/jaspersoft-mongodb-query-language
Thanks,
Assaf