Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Help with box plot needed

  1. #1
    Join Date
    Oct 2015
    Posts
    9

    Default Help with box plot needed

    I'm using a Mondrian MDX query as a datasource for a box plot on my CDE dashboard.

    The MDX query:
    SELECT
    [Month].[Month].Members on 1,
    {[Measures].[Median],[Measures].[P25],[Measures].[P75],[Measures].[P5],[Measures].[P95]} on 0
    FROM [StationData]

    I've not changed any of the default settings on the box plot chart. But instead of rendering as a box plot, every measure is treated as new series. So in Januari, I'm getting five dashes, one for the Median of the Median, one for the Median of P25 etc.

    I've tried giving each measure its own dimension, but Mondrian won't allow that.

    How can I get Pentaho to render the box chart correctly.
    Attached Images Attached Images  

  2. #2
    Join Date
    Oct 2015
    Posts
    9

    Default

    Making the following settings in the CDE chart solved it:
    - dataMeasuresInColumns: True
    - dataIgnoreMetadataLabels: True
    - isMultiValued: True

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.