Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Grouped category for X axis for any CCC chart

  1. #1
    Join Date
    Feb 2013
    Posts
    530

    Default Grouped category for X axis for any CCC chart

    Hi Forum/Leao,

    I am excited to explore the example explained at http://jsfiddle.net/duarteleao/2nxheka0/

    I want to implement it to a normal bar graph or to a line graph( or XY type of graphs) with following data.

    i.e., top category = the_month , bottom category=quarter and then the value on series.

    quarter, the_month, unit_sales
    "Q1";"January";21628.0000
    "Q1";"February";20957.0000
    "Q1";"March";23706.0000
    "Q2";"April";20179.0000
    "Q2";"May";21081.0000
    "Q2";"June";21350.0000
    "Q3";"July";23763.0000
    "Q3";"August";21697.0000
    "Q3";"September";20388.0000
    "Q4";"October";19958.0000
    "Q4";"November";25270.0000
    "Q4";"December";26796.0000


    ( last but not the least, How can we generalize the script for more than 2 category groups)

    Thank you in Advance.
    - Sadakar Pochampalli

  2. #2
    Join Date
    Mar 2012
    Posts
    645

    Default

    So, your question seems to be how to map the dataset into the correct dimensions and visual roles.
    Try:

    readers: "category, category2, value".

    In what concerns using the composite/hierarchical axis, it's like the fiddle shows.

  3. #3

    Default

    Hey guys!
    I'm trying to implement this example, but I couldn't get the double x-axis to work.
    Could you guys give me a hint on what could be wrong? I'm using ba server 6.1
    Thanks!

    Name:  Capturar.jpg
Views: 68
Size:  15.4 KB

Tags for this Thread

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.