• Chart Axis

    By mhcheng70 cheng 1 decade ago

    How can I display multi fields in one chart?



    TotalFieldTX is not a multi-value



    Thanks

    • Need more info

      By David Jeyachandran 1 decade ago

      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

      • By mhcheng70 cheng 1 decade ago

        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

        • Ok - that makes sense

          By David Jeyachandran 1 decade ago

          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

          • By mhcheng70 cheng 1 decade ago

            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

            • Getting started

              By David Jeyachandran 1 decade ago

              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

              • By mhcheng70 cheng 1 decade ago

                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

                • Well Done!

                  By David Jeyachandran 1 decade ago

                  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

                • Source code

                  By Cyril Karim Niang 1 decade ago

                  Hi,

                  Could you please explain me how did you edit the addEntry () function ?