Dashboards & Visualizations

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

leonjxtan
Path Finder

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.

alt text

Tags (1)
0 Karma

leonjxtan
Path Finder

@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.

alt textalt text

0 Karma

adonio
Ultra Champion

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:
alt text

alt text

0 Karma

leonjxtan
Path Finder

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

Thanks.

0 Karma

oda
Communicator

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

0 Karma

leonjxtan
Path Finder

@oda thanks it works!

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

0 Karma

woodcock
Esteemed Legend

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

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...