SPJS Chart v6 .0.1 BETA : Table Chart Bugs

Home Forums SPJS Charts for SharePoint SPJS Chart v6 .0.1 BETA : Table Chart Bugs

Viewing 14 reply threads
  • Author
    Posts
    • #14508
      Jhap
      Participant

        Hi Sir Alexander

        I have tested the SPJS Chart v6 .0.1 BETA 1 and in my scenario I have a calculated single line text column and once the data is rendered using Table chart it shows extra text string;#

        Please refer on the attached image.

        Thank you.

      • #14561
        Alexander Bautz
        Keymaster

          I’m not able to recreate this issue. Can you share a bit more details about how your datasource looks like, and how you have set up the chart?

          Alexander

        • #14581
          Jhap
          Participant

            Hi Sir Alexander

            Here are the screenshot for your reference please.

            Column 1 :: Date
            =TEXT(Period,”mmm yyyy”)

            Column 2 :: Remark
            =IF((AND([Project Title]=”SK BUTADIENE”,Indicator=”Active”)),Remarks,””)

            Chart Type :: Table

            Thank you.

          • #14679
            Alexander Bautz
            Keymaster

              Sorry for the late reply. I cannot recreate this using calculated columns in a table chart. Could you possibly share a screenshot of the configuration for your table chart as well?

              Alexander

            • #14687
              Jhap
              Participant

                Hi Sir Alexander

                I have a list with this fields…

                Field 1 : “Period” (the user enter the complete date)

                Field 2 : “Project Title”

                Field 3 :: “DateFilter” reading the “Period” field
                =TEXT(Period,”mmm yyyy”)

                Field 4 : “Project” (the user selecting the name in the drop list)

                Field 5 : “Remarks”

                Field 5 :: “Butadien Remark”
                =IF((AND([Project Title]=”SK BUTADIENE”,Indicator=”Active”)),[Remarks],””)

                =============================================================

                My list has a filter and that will only show the ACTIVE items. The field “Butadien Remark” on the otherhand will only show data if it meet the condition.

                As you can see in the screenshot it show the content, but the table chart also render the empty column and it shows “string;#”

                PS: this is the same setting I have in SPJS Chart v5 and is working very fine.

                =============================================================

                My Table chart configuration as per the screenshot

              • #14694
                Alexander Bautz
                Keymaster

                  Thanks,
                  I was able to recreate it and will fix it in the next release.

                  Best regards,
                  Alexander

                • #14836
                  Jhap
                  Participant

                    Hi Sir Alexander

                      1. the “string;#” is gone, but the empty row still remain.

                      2. In the “dynamic” filter, will it be possible to enable or disable the “ALL” in the drop list and it will automatically default the very first option?

                    Please refer on the screenshot.

                    Thank you.

                    • This reply was modified 7 years, 9 months ago by Jhap.
                    Attachments:
                  • #14886
                    Alexander Bautz
                    Keymaster

                      1: Fixed in the upcoming release (if you use the “Remove items with no value in the first column” in the Options tab).

                      2: Yes, will be in the next release.

                      Alexander

                    • #15337
                      Jhap
                      Participant

                        Hi Sir Alexander,

                        Still the empty row is showing. Please the attached image.

                        THank you.

                      • #15443
                        Alexander Bautz
                        Keymaster

                          I thought I had this fixed… Could you email me a few screenshots so I can see how the list you get the data from looks like, and how the chart config looks like, and I’ll try to recreate it and get it fixed.

                          Alexander

                        • #15462
                          Jhap
                          Participant

                            Hi Sir Alexander,

                            Attached images described my list/column settings and the table chart configuration.

                            Thank you so much.

                            Attachments:
                          • #15468
                            Jhap
                            Participant

                              Table_Chart_Config

                            • #15545
                              Alexander Bautz
                              Keymaster

                                Sorry for the delay. I have looked at your screenshots and the setting “Remove items with no value in the first column” in the “Options” tab will not filter these rows away as this setting only applies to the first column.

                                There are however a much easier approach – just select a view you have already filtered on “PROJECT NAME = SK BUTADIENE” as the source for this chart.

                                Let me know how this works out.

                                Best regards,
                                Alexander

                              • #15560
                                Jhap
                                Participant

                                  Hi Sir Alexandader,

                                  Firstly, thank you so much for the great work.

                                  I just follow your suggestion and I have created filtered view and used it though I have to create at least 5 views for each of the table chart, but not a big deal.

                                • #15567
                                  Alexander Bautz
                                  Keymaster

                                    You can also use the Custom CAML option so you don’t have to create all the views – click the “Get CAML from selected view” button to read the CAML form the selected view and use this as the starting point. Ask if you need help with the CAML.

                                    Alexander

                                Viewing 14 reply threads
                                • You must be logged in to reply to this topic.