Combined chart with multiple splines on one axis - line color / dashStyle

Posted on October 19, 2020 at 2:57am
0

Hi, 

I've created a combined chart with a stacked column chart on one axis and a stacked spline chart with 5 lines on the other axis but I have some problems with the style of the splines. 

First, one of the lines is thinner at the first and last x-axis value and I can't figure out why. 

Also, if  I change the dashStyle of one of the lines the other lines seem to have a dash in the background as well. 

Does anyone have an idea how to change that?

Thanks,

A.

 

JRXML:  

<hc:chart xmlns:hc="http://jaspersoft.com/highcharts"
          xsi:schemaLocation="http://jaspersoft.com/highcharts
                              http://jaspersoft.com/schema/highcharts.xsd"
          type="StackedColumnSpline">
   <hc:chartSetting name="default">
      <hc:chartProperty name="title.text" value=""/>
      <hc:chartProperty name="credits.enabled" value="false"/>
      <hc:chartProperty name="credits.href" value=""/>
      <hc:chartProperty name="credits.text" value=""/>
      <hc:chartProperty name="yAxis.title.text" value=""/>
      <hc:chartProperty name="chart.zoomType" value="xy"/>
      <hc:chartProperty name="chart.events.load">
         <hc:propertyExpression>
            <![CDATA["function(){"+"this.yAxis[0].endOnTick=false;"+
                                   "this.yAxis[1].endOnTick=false;"+
                                   "this.yAxis[0]
                                        .setExtremes(0,Math.max(this.yAxis[0]
                                                                    .getExtremes().max,this.yAxis[1]
                                                                    .getExtremes().max)
                                                      ,true);"+
                                   "this.yAxis[1]
                                        .setExtremes(0,Math.max(this.yAxis[0]
                                                                    .getExtremes().max,this.yAxis[1]
                                                                    .getExtremes().max)
                                                      ,true);"+
                                   "}"]]>
         </hc:propertyExpression>
      </hc:chartProperty>
      <hc:chartProperty name="chart.animation">
         <hc:propertyExpression>
            <![CDATA[false]]>
         </hc:propertyExpression>
      </hc:chartProperty>
      <hc:chartProperty name="legend.enabled_customSimpleMode" value="true"/>
      <hc:chartProperty name="legend.enabled">
         <hc:propertyExpression>
            <![CDATA[false]]>
         </hc:propertyExpression>
      </hc:chartProperty>
      <hc:chartProperty name="plotOptions.spline.marker.enabled_customSimpleMode"
                        value="true"/>
      <hc:chartProperty name="plotOptions.spline.marker.enabled">
         <hc:propertyExpression>
            <![CDATA[false]]>
         </hc:propertyExpression>
      </hc:chartProperty>
      <hc:chartProperty name="plotOptions.spline.dataLabels.enabled_customSimpleMode" value="true"/>
      <hc:chartProperty name="plotOptions.spline.dataLabels.enabled">
         <hc:propertyExpression>
            <![CDATA[true]]>
         </hc:propertyExpression>
      </hc:chartProperty>
      <hc:chartProperty name="plotOptions.spline.dataLabels.formatter">
         <hc:propertyExpression>
            <![CDATA["function() { var len = this.series.data.length; if(this.point.x == len-1) {return this.series.name;} else return null;}"]]>
         </hc:propertyExpression>
      </hc:chartProperty>
      <hc:chartProperty name="plotOptions.series.dataLabels.style.fontSize" value="10px"/>
      <hc:chartProperty name="plotOptions.series.dataLabels.style.fontWeight" value="normal"/>
      <hc:chartProperty name="plotOptions.series.dataLabels.style.textOutline" value="0px"/>
      <hc:chartProperty name="plotOptions.series.dataLabels.style.color" value="&quot;black&quot;"/>
      <hc:chartProperty name="com.jaspersoft.jasperreports.highcharts.interactive" value="false"/>
      <hc:chartProperty name="plotOptions.column.dataLabels.format">
         <hc:propertyExpression><![CDATA["{point.label}"]]></hc:propertyExpression>
      </hc:chartProperty>
      <hc:chartProperty name="colors_customSimpleMode" value="true"/>
      <hc:chartProperty name="colors">
         <hc:propertyExpression>
            <![CDATA[Arrays.asList("#FFFFFF","#f7a35c","#7cb5ec",
                                   "#90ed7d","#434348","#e4d354","#2b908f")]]>
         </hc:propertyExpression>
      </hc:chartProperty>
   </hc:chartSetting>
   <hc:chartSetting name="yAxis">
      <hc:chartProperty name="_jrAxisIndex">
         <hc:propertyExpression>
            <![CDATA[0]]>
         </hc:propertyExpression>
      </hc:chartProperty>
   </hc:chartSetting>
   <hc:chartSetting name="yAxis">
      <hc:chartProperty name="_jrAxisIndex">
         <hc:propertyExpression>
            <![CDATA[0]]>
         </hc:propertyExpression>
      </hc:chartProperty>
   </hc:chartSetting>
   <dataAxis axis="Rows">
      <axisLevel name="MONTH">
         <labelExpression>
            <![CDATA["Level Label expression"]]>
         </labelExpression>
         <axisLevelBucket order="None" class="java.lang.Comparable">
            <bucketExpression>
               <![CDATA[$F{MONTH}]]>
            </bucketExpression>
         </axisLevelBucket>
      </axisLevel>
   </dataAxis>
   <dataAxis axis="Columns">
      <axisLevel name="STACKRANK">
         <labelExpression><![CDATA[]]></labelExpression>
         <axisLevelBucket order="Descending" class="java.lang.Comparable">
            <bucketExpression><![CDATA[$F{STACKRANK}]]></bucketExpression>
            <labelExpression> <![CDATA[$F{TOOLTIP}]]>  </labelExpression>
            <bucketProperty name="color">
               <![CDATA[IF($F{STACKRANK}==2
                           , "#D3D3D3"
                           , IF(OR( AND($F{STACKRANK}>=3
                                        , $F{STACKRANK}<=14)
                                   ,AND($F{STACKRANK}>=27
                                        , $F{STACKRANK}<=38)
                                   ,AND($F{STACKRANK}>=51
                                        , $F{STACKRANK}<=62)
                                   ,AND($F{STACKRANK}>=75
                                        , $F{STACKRANK}<=86)
                                   ,AND($F{STACKRANK}>=99
                                        , $F{STACKRANK}<=110))
                           , "#7CB5EC"
                           , "#90ED7D"))]]>
            </bucketProperty>
            <bucketProperty name="label">
               <![CDATA[$F{LABEL}]]>
            </bucketProperty>
         </axisLevelBucket>
      </axisLevel>
   </dataAxis>
   <multiAxisMeasure name="STACK" class="java.lang.Number"
                     calculation="Nothing">
      <labelExpression><![CDATA[""]]>       </labelExpression>
      <valueExpression><![CDATA[$F{STACK}]]></valueExpression>
   </multiAxisMeasure>
   <multiAxisMeasure name="CTC_7" class="java.lang.Number"
                     calculation="Nothing">
      <labelExpression><![CDATA[""]]>       </labelExpression>
      <valueExpression><![CDATA[$F{CTC_7}]]></valueExpression>
   </multiAxisMeasure>
   <multiAxisMeasure name="CTC_6" class="java.lang.Number"
                     calculation="Nothing">
      <labelExpression><![CDATA[""]]>       </labelExpression>
      <valueExpression><![CDATA[$F{CTC_6}]]></valueExpression>
   </multiAxisMeasure>
   <multiAxisMeasure name="CTC_5" class="java.lang.Number"
                     calculation="Nothing">
      <labelExpression><![CDATA[""]]>       </labelExpression>
      <valueExpression><![CDATA[$F{CTC_5}]]></valueExpression>
   </multiAxisMeasure>
   <multiAxisMeasure name="CTC_4" class="java.lang.Number"
                     calculation="Nothing">
      <labelExpression><![CDATA[""]]>       </labelExpression>
      <valueExpression><![CDATA[$F{CTC_4}]]></valueExpression>
   </multiAxisMeasure>
   <multiAxisMeasure name="QUALIFIER" class="java.lang.Number"
                     calculation="Nothing">
      <labelExpression><![CDATA[""]]>           </labelExpression>
      <valueExpression><![CDATA[$F{QUALIFIER}]]></valueExpression>
   </multiAxisMeasure>
 
   </multiAxisData>
 
   <hc:series name="STACK">
      <hc:contributor name="SeriesProperty">
         <hc:contributorProperty name="yAxis" valueType="Expression">
            <hc:valueExpression><![CDATA[0]]></hc:valueExpression>
         </hc:contributorProperty>
         <hc:contributorProperty name="dataLabels.enabled" valueType="Expression">
            <hc:valueExpression><![CDATA[true]]></hc:valueExpression>
         </hc:contributorProperty>
      </hc:contributor>
      <hc:contributor name="SeriesItemProperty">
         <hc:contributorProperty name="color" valueType="Bucket" value="STACKRANK.color"/>
         <hc:contributorProperty name="label" valueType="Bucket" value="STACKRANK.label"/>
      </hc:contributor>
   </hc:series>
   <hc:series name="CTC_7">
      <hc:contributor name="SeriesProperty">
         <hc:contributorProperty name="yAxis" valueType="Expression">
            <hc:valueExpression><![CDATA[1]]></hc:valueExpression>
         </hc:contributorProperty>
         <hc:contributorProperty name="type" valueType="Constant" value="spline"/>
         <hc:contributorProperty name="dashStyle" valueType="Constant" value="solid"/>
      </hc:contributor>
   </hc:series>
   <hc:series name="CTC_6">
      <hc:contributor name="SeriesProperty">
         <hc:contributorProperty name="yAxis" valueType="Expression">
            <hc:valueExpression><![CDATA[1]]></hc:valueExpression>
         </hc:contributorProperty>
         <hc:contributorProperty name="type" valueType="Constant" value="spline"/>
         <hc:contributorProperty name="dashStyle" valueType="Constant" value="solid"/>
      </hc:contributor>
   </hc:series>
   <hc:series name="CTC_5">
      <hc:contributor name="SeriesProperty">
         <hc:contributorProperty name="yAxis" valueType="Expression">
            <hc:valueExpression><![CDATA[1]]></hc:valueExpression>
         </hc:contributorProperty>
         <hc:contributorProperty name="type" valueType="Constant" value="spline"/>
         <hc:contributorProperty name="dashStyle" valueType="Constant" value="solid"/>
      </hc:contributor>
   </hc:series>
   <hc:series name="CTC_4">
      <hc:contributor name="SeriesProperty">
         <hc:contributorProperty name="yAxis" valueType="Expression">
            <hc:valueExpression><![CDATA[1]]></hc:valueExpression>
         </hc:contributorProperty>
         <hc:contributorProperty name="type" valueType="Constant" value="spline"/>
         <hc:contributorProperty name="dashStyle" valueType="Constant" value="solid"/>
      </hc:contributor>
   </hc:series>
   <hc:series name="QUALIFIER">
      <hc:contributor name="SeriesProperty">
         <hc:contributorProperty name="yAxis" valueType="Expression">
            <hc:valueExpression><![CDATA[1]]></hc:valueExpression>
         </hc:contributorProperty>
         <hc:contributorProperty name="type" valueType="Constant" value="spline"/>
         <hc:contributorProperty name="dashStyle" valueType="Constant" value="dash"/>
         <hc:contributorProperty name="color" valueType="Expression">
            <hc:valueExpression><![CDATA["#000000"]]></hc:valueExpression>
         </hc:contributorProperty>
      </hc:contributor>
   </hc:series>

Attachments: 
Image icon splinechart.png
Jaspersoft® Studio
anna.czubernat's picture
anna.czubernat
13
Joined: May 1 2020 - 3:52am
Last seen: 7 months 1 week ago

1 Answer:

1
Posted on October 19, 2020 at 6:29am

I've found the problem myself. Any value that is not used or not available must be set to NULL in the query (not 0). Otherwise the lines are doubled. 

anna.czubernat's picture
anna.czubernat
13
Joined: May 1 2020 - 3:52am
Last seen: 7 months 1 week ago
Feedback
randomness