Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Pentaho Chart - Tooltip issue

  1. #1
    Join Date
    Oct 2013
    Posts
    7

    Question Pentaho Chart - Tooltip issue

    I’m facing an issue in displaying the tooltip in the pentaho scatter plot chart.

    Below is the result set returned by the query used to render the chart.


    productCode
    product
    Date
    Quantity
    status
    statusCode
    0
    A
    2012-01-11 23:59:53
    5
    Processed
    2
    1
    B
    2012-01-21 23:59:53
    7
    Shipped
    3
    2
    C
    2012-01-05 23:59:58
    2
    Processing
    1
    3
    D
    2012-01-01 23:59:51
    12
    Shipped
    3
    4
    E
    2012-01-07 23:59:56
    15
    Processed
    2
    5
    F
    2012-01-12 23:59:52
    2
    Processing
    1
    6
    G
    2012-01-10 23:59:51
    7
    Shipped
    3
    7
    H
    2012-01-03 23:59:56
    9
    Processing
    1


    In the chart, productCode is plotted along x-axis and statusCode along y-axis. Status column is used in Series-by-field attribute of the chart.

    The query would always return 8 rows for the 8 products A through H and hence the scatter plot would always have 8 points in it.


    On each point, I want to display the tooltip containing the data from the columns Product name, Date and Quantity. When I use the formula expression to render the tooltip, each point always shows the data for the product H, which is always the last row in the result set.

    If I use the chart::x-value and chart::y-value in the tooltip formula expression, each point displays the appropriate data.

    Is it possible to display for each point, the corresponding product, date and quantity values in the tooltip, even though these columns are not plotted in any axes?
    Last edited by ayush.goel; 05-19-2014 at 05:41 AM.

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.