String – merge duplicates

Home Forums SPJS Charts for SharePoint String – merge duplicates

Viewing 4 reply threads
  • Author
    Posts
    • #11442
      DCH
      Participant

        Alexander,

        My first test was to replicate the setup of an existing chart in the new version. I don’t see the “String – merge duplicates” format available, and when I choose just “String” I get the following error:

        Error: Row 0 has 1 columns, but must have 3

        Thanks!

        • This topic was modified 8 years, 7 months ago by DCH.
      • #11447
        Alexander Bautz
        Keymaster

          Hi,
          This task is now performed by “Grouping” at the bottom of the first tab – check the “Group by first column” – and possibly combine it with “Split options in separate series” if you are charting on a choice column.

          Hope this helps,
          Alexander

        • #11462
          DCH
          Participant

            Cool thanks.

            So my chart configuration is this:

            Index 0 – SLT field – Split (also tried String)
            Index 1 – Number field – Sum
            Index 2 – Number field – Sum
            Group by first column – True
            Aggregation function – Count (also tried Sum)

            And with that I am now getting this error:

            Error: Invalid type, Sum, for column “MyNumberColumn”

          • #11487
            Alexander Bautz
            Keymaster

              I’ll need to have a close look – could you email me some screenshots of your data-source list and your chart config?

              Alexander

            • #11584
              Alexander Bautz
              Keymaster

                This is caused by using “Sum” and not “Number” as type – I have just released a new BETA and the “Sum” option have been removed (relic from v4).

                Alexander

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