SPJS Chart v6 .0.1 BETA : Table Chart Bugs

[Jhap]

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.

Attachments:

1. 

   chart_v6.0.1_BETA_Table_Chart_Bugs.jpg
   

[Alexander Bautz]

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

[Jhap]

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.

Attachments:

1. 

   Date_singleText_calculatedColumn.jpg
   

2. 

   remark_singleText_calculated_column.jpg
   

[Alexander Bautz]

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

[Jhap]

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

Attachments:

1. 

   Table_Chart_Config.jpg
   

2. 

   List.jpg
   

[Alexander Bautz]

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

Best regards,
Alexander

[Jhap]

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, 10 months ago by Jhap.

Attachments:

1. 

   Table_Chart.jpg
   

[Alexander Bautz]

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

[Jhap]

Hi Sir Alexander,

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

THank you.

Attachments:

1. 

   SPJS_Chart-v6.1.0_TableChart_Empty_Row.jpg
   

[Alexander Bautz]

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

[Jhap]

Hi Sir Alexander,

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

Thank you so much.

Attachments:

1. 

   List_Config.jpg
   

[Jhap]

Table_Chart_Config

Attachments:

1. 

   Table_Chart_Config.jpg
   

[Alexander Bautz]

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

[Jhap]

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.

[Alexander Bautz]

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

[Author]

Posts