Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-1197

When level contains nulls, the values are not sorted correctly on the chart

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.4.1 GA (4.5.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      See screenshot. If you sort A->Z or Z->A on State, the behavior is unexpected. You can reproduce on steel-wheels with this report XML:

      <report xmlns="http://www.pentaho.com" freezeRows="true" freezeColumns="true" autoRefresh="true" version="7" showDrillLinks="false" emptyCellDisplay="-" showEmptyCells="false" useNonVisualTotals="false" showColumnGrandTotal="false" showRowGrandTotal="false" reportTypeEnum="JSON" cube="SteelWheelsSales" catalog="SteelWheels">
      <measures><measure showAggregate="true" showSum="false" showAverage="false" showCount="false" showMin="false" showMax="false" measureTypeEnum="VALUE" sortOrderEnum="NONE" formula="[Measures].[Sales]" id="[MEASURE:0]" gembarOrdinal="0" gembarId="measures"/></measures>
      <columnAttributes/>
      <rowAttributes><attribute showSubtotal="false" sortOrderEnum="DESC" formula="[Markets].[State Province]" gembarId="rows" gembarOrdinal="0"/></rowAttributes>
      <filters><filter viewFilterEnum="MULTIPLE" formula="[Time].[Quarters]"><predicates><predicate ordinal="1" operatorEnum="AFTER"><member pos="0" formula="[Time].[2003].[QTR1]" caption="QTR1"/></predicate></predicates></filter><filter viewFilterEnum="MULTIPLE" formula="[Markets].[State Province]"><predicates><predicate ordinal="1" operatorEnum="EQUAL"><member pos="0" formula="[Markets].[NA].[USA].[CA]" caption="CA"/><member pos="0" formula="[Markets].null.[South Africa].null" caption="Not Available"/><member pos="0" formula="[Markets].[APAC].[Australia].[Queensland]" caption="Queensland"/></predicate></predicates></filter></filters>
      <chartOptions legendFontFamily="Default" labelFontFamily="Default" legendStyle="PLAIN" legendColor="#000000" legendSize="12" legendBackgroundColor="#ffffff" labelStyle="PLAIN" backgroundColorEnd="#ffffff" maxChartsPerRow="3" backgroundFill="NONE" labelSize="12" labelColor="#000000" backgroundColor="#ffffff" maxValues="100" lineShape="CIRCLE" lineWidth="2" displayUnitsSecondary="UNITS_0" autoRangeSecondary="true" displayUnits="UNITS_0" autoRange="true" showLegend="true" legendPosition="RIGHT" customChartType="ccc_barstacked" chartType="CUSTOM"/>
      <selectionFilters/>

      <pageSetup excelScalingPageTall="1" excelScalingPageWide="1" excelScalingPercent="100" excelScalingType="PERCENT" pdfOrientation="LANDSCAPE" excelOrientation="LANDSCAPE" pdfPageSize="LETTER" excelPageSize="LETTER"/>
      </report>

        Attachments

        1. mondrian1197.PNG
          mondrian1197.PNG
          243 kB
        2. mondrian1197.xanalyzer
          2 kB
        3. screenshot-1.jpg
          screenshot-1.jpg
          210 kB
        4. screenshot-2.jpg
          screenshot-2.jpg
          122 kB

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              bchow Benny Chow
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: