topic Re: Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix. in Dashboards & Visualizations

Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

leonjxtan — Thu, 06 Jul 2017 01:27:00 GMT

Hi, as in attached pic.
My use case is that I have a column chart with reasonably many columns, so that if I do not set orientation to 45 degree, all names are shortened to "xxx...yyy"

But after setting orientation to 45 degree, my boss found that the first column, no matter how short the name is, will always be shortened to "xxx...yyy". I tried to switch to several different data set, and problem still persist.
In the attached pic example, the "Ada...itz" is only 10 characters in length; the "Anthony xxxxxx" is 14 characters in length, but it is not shortened.

Could you please advise if I configured the chart wrong, or could you please help to fix this problem?

Thanks.

Re: Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

oda — Thu, 06 Jul 2017 01:55:42 GMT

I think that it will not be a fundamental solution but I think that it will work if it is 45.
Not -45.

Re: Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

adonio — Thu, 06 Jul 2017 02:01:26 GMT

tried here and seems to work as anticipated:
code:

<dashboard>
  <label>legend attempt</label>
  <row>
    <panel>
      <chart>
        <search>
          <query>index = _internal | stats count by sourcetype</query>
          <earliest>-4h@m</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">-45</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">column</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">gaps</option>
        <option name="charting.chart.showDataLabels">none</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.placement">right</option>
        <option name="trellis.enabled">0</option>
        <option name="trellis.scales.shared">1</option>
        <option name="trellis.size">medium</option>
      </chart>
    </panel>
  </row>
</dashboard>

screenshots:

Re: Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

leonjxtan — Thu, 06 Jul 2017 02:33:13 GMT

@adonio, I created another column chart from GUI wizard, and pasted all options tags in your code to the column chart source code, but still seeing first column text being shortened.

at the same time, I confirmed that if I change the orientation to horizontal, the name can be displayed correctly.

Could you further advise? The Splunk Enterprise version in my company is 6.5.2, if this helps.

Re: Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

leonjxtan — Thu, 06 Jul 2017 02:34:39 GMT

Hi @adonio, sorry had to post my reply in main comment as only there allows me to attach picture. Could you please advise?

Thanks.

Re: Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

leonjxtan — Thu, 06 Jul 2017 02:37:40 GMT

@oda thanks it works!

@Splunk could you add this to the bug queue? 🙂

Re: Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

woodcock — Thu, 06 Jul 2017 03:20:57 GMT

If it really is a bug, add the bug tag and also open a P2 support case with your entitlement.