SPJS Chart v6 .0.1 BETA : Table Chart Bugs

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

This topic contains 14 replies, has 2 voices, and was last updated by  Alexander Bautz 8 months, 1 week ago.

  • Author
    Posts
  • #14508

    Danny
    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

    Danny
    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

    Danny
    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

    Danny
    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 9 months, 3 weeks ago by  Danny.
    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

    Danny
    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

    Danny
    Participant

    Hi Sir Alexander,

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

    Thank you so much.

    Attachments:
  • #15468

    Danny
    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

    Danny
    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

You must be logged in to reply to this topic.