Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Line chart not displaying the correct flow of data.

  1. #1

    Default Line chart not displaying the correct flow of data.

    Hi All,

    I have a line chart that shows the sales value within a date range for a particular product. Here is the MDX query for that.

    select {[Measures].[Sales]} ON COLUMNS,
    {([Time].[Date].[2010-01-01] : [Time].[Date].[2010-01-10])} ON ROWS
    from [SampleCube]
    where [Product].[Category].[Product Name0]

    On certain dates, there is no sales for the product and the chart should look like.
    Name:  Saiku Image.jpg
Views: 39
Size:  6.5 KB
    which I am getting in Saiku.
    However, this is not what I get in JPivot/Dash Board.

    In dash board what I am getting is a 0-value-excluded line chart like this
    Name:  DashboardImage.jpg
Views: 37
Size:  8.0 KB

    What am I supposed to do to get the desired line chart?
    Last edited by AchuthanExelixir; 12-11-2012 at 08:00 AM.

  2. #2
    Join Date
    Mar 2011
    Posts
    257

    Default

    null =/= 0 I like the fact they do not show data for those points!
    you can do a coalesceEmpty to return 0 on those points.

    greetz,
    Hans

  3. #3
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    we don't consider null values to be zero. Add a calculated measure with [Measures].[Sales] + 0
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  4. #4

    Default

    Got it, thank you

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.