An open source reporting tool based on IBM Lotus Notes/Domino
How can I display multi fields in one chart? TotalFieldTX is not a multi-value Thanks
Hi Mr Cheng (please correct me if this is not correct), Please give me a bit more information about what you need to achieve. The Total field needs to be a single value for it to work as a two dimensional chart. For each x and y value there can be only one Total value. I could guess that you have a document with three multi-value that are linked so: x[1] and y[1] and total[1] are a point on the chart and x[2] and y[2] and total[2] are another point Is this correct? Maybe I have not explained this very well. I will need more information on your data to understand what you need to achieve. Regards David
hi, Thanks for your quick response, I would like to display chart like this, http://yfrog.com/j2picmbkp Date A B C 2010/5/3 154 88 100 2010/4/27 122 99 100 2010/4/26 119 109 100 2010/4/23 119 90 100 2010/4/22 118 92 100 2010/4/21 120 78 100 2010/4/20 118 90 100 2010/4/19 119 80 100
Hi Thanks for that - now I understand. Notes Reconn Charts cannot currently handle data in that format. It is expecting the data in the following format where each document contains an X axis value, an optional Y axis value and a Total field. Date Type Value 2010/5/3 A 154 2010/5/3 B 88 2010/5/3 C 100 2010/4/27 A 122 2010/4/27 B 99 2010/4/27 C 100 2010/4/26 A 119 2010/4/26 B 109 2010/4/26 C 100 … I can't think of a quick fix for this. You could write some custom code without too much difficulty to do this. Let me know your thoughts. I can give you some pointers if you were going to write your own code to process the documents and then use Notes Reconn Script Libraries to do the charting. Regards David
Hi David, Actually I don't know how to start. Could you give me some hints for that? Or do you have any exapmles in document of xml data? Thannks Hui
Hi Hui, I can give you some hints in getting started. I've got a deadline at the end of next week so I can give you some help then. We won't have to worry about converting documents to XML. We just need to write code that will cycle through a document collection and then call a function called addEntry() to add the data points. Talk more soon. Regards David
hi David, I solve it out I edit addEntry() function Now I can display what I want now.. Thank you for your helping Regards Hui
Great job Hui, Hope that your boss & your client are very impressed with your work. :) If you have a minute, please give Notes Reconn a testimonial or give the project a rating. Thanks & Regards David
Hi,
Could you please explain me how did you edit the addEntry () function ?