[Jhap]

Hi Sir Alexander

:: SPJS CHART V6 B3 : CUSTOM CAML & FILTER

My setting is the same (SPJS Chart V6B2) as before and I have applied SPJS Chart V6B3 and the filter doesnt show any results with selecting any other option excet selecting ALL.

This happens in DYNAMIC and STATIC filter. I deleted the chart setting and do a fresh configuration, but the same.

Please see the attached images.

Thank you.

Attachments:

1. 

   SPJS_CHART_V6B3_Dynamic_Filter.jpg
   

[Jhap]

Hi Sir Alexander

Still the issue persist.

Please see the attached image.

Thank you.

Attachments:

1. 

   2017-01-09_072240.jpg
   

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

Attachments:

1. 

   Table_Chart.jpg
   

[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
   

[Jhap]

Thank you so much Sir Alexander.

This is working as expected in DFFS v4.2.2.2

[Jhap]

Hi Sir Alexander

I have updated the “spjs-charts-i18n.js” and is it OK now. Thank you so much.

Is it possible to omet the All? I also wanted to sort descending and automatically select the last option?

Thanks again ^_^

[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
   

[Jhap]

Hi Sir Alexander,

I noticed that if the page has already a chart/s and if I add new chart the Chart ID got rearranged autmatically.

Example: I already have 4 charts (Chart ID: Pages_Default0_aspx_0, Chart ID: Pages_Default0_aspx_1, Chart ID: Pages_Default0_aspx_2, Chart ID: Pages_Default0_aspx_3) in a page and I added new chart above the already available Chart ID got rearranged by itself.

So the newly added chart got the Chart ID: Pages_Default0_aspx_0 and used the already configured chart configuration with Chart ID: Pages_Default0_aspx_0 and the previous Chart ID: Pages_Default0_aspx_0 got the configuration of Chart ID: Pages_Default0_aspx_1 and so on.

[Jhap]

Hi Sir Alexander,

Is the isse addressed in BETA 5? I have applied BETA 5, but the chart ID numbering issue still exist.

Thank you.

[Jhap]

Hi Sir, Alexander,

Yes the data are fetch from CHOICE field type. It is OK now. I remove all the option configuration and re-enter it again

Thank you.

• This reply was modified 7 years, 10 months ago by Jhap.

[Jhap]

Hi Sir Alexander,

I noticed that I used the option colorByLabel in column chart and is working fine. When I use in pie chart it doesn’t work, but the below it works in pie chart only it ramdomly assign the colors to each legend. Like the color of High is showing in Low.

color {
“Low”: “#ffcd00”,
“Medium”: “#ffa300”,
“High”: “#e35205”
}

—–
Regards,

[Jhap]

Hi Sir Alexander,

My column is calculated column in number format and it will display 0 value when empty.

The “Remove items with no value in the first column” doesn’t help.

Thank you.

[Jhap]

HI Sir Alexander,

Ignore this please. I got it working.

Thank you.

[Jhap]

THank you very much Sir. It is working now by applying BETA 4…

[Jhap]

Thank you very much Sir. It is working now.

[Author]

Posts