Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Table component column grand total - guoup by field and aggrations

  1. #1
    Join Date
    Feb 2013
    Posts
    530

    Default Table component column grand total - guoup by field and aggrations

    Hi Forum,
    All about table component in pentaho CDE - Out of the box.

    1) How can I remove the default row banding colors or over ride the colors with some other?
    2) How can I remove the drop down list of no.Of rows ? (5,10,25....)... How to customize if I want to show 25 columns in each page ?
    3) How to do column aggregations(sum value) for table component columns ?
    4) How to group by table component by a field and show that field as an heading ,also how to show the aggravations on grouped by data ?
    5) How to give conditional coloring for numeric values ? ( for eg : value>=100 then green color value else red colored value).
    6) How to neatly format table page numbers 1,2,3,4,5 .. ? when using classic model of table it is over-ridding and giving a bad look .
    7) If I have 10 pages in table component, how to show the column aggregations for each of the page specific only and grand aggregation at the end of the last page ?
    `
    Thank you.
    Sadakar
    BI developer

  2. #2
    Join Date
    Feb 2013
    Posts
    530

    Default

    4th one is partially done as per the AddIn reference example..

    Now focused on , aggregations on grouped data and the grand sum.. should show for each of the page .

    ( If I select 10 in the drop down it has to show the aggregation of 10 values , if I select 25 to show it has to show the grand total of 25 values --- This is without group by )

  3. #3
    Join Date
    Feb 2013
    Posts
    530

    Default

    Need the exact functionality of this example

    http://datatables.net/examples/advan..._callback.html

    1) Summation per page and the grand total

    In another case, summation group by, summation per page & grand total as shown in example...

    CA Burbank 3086.0000 6577.3300
    CA Burlingame 198.0000 407.3800
    CA Chula Vista 2999.0000 6284.3000
    CA Colma 129.0000 287.7800
    CA Concord 105.0000 219.7700

    OR Albany 6806.0000 14109.8100
    OR Beaverton 4558.0000 9565.0700
    OR Corvallis 9539.0000 20035.1600
    OR Lake Oswego 4910.0000 10375.9400
    OR Lebanon 9596.0000 20257.4200

    WA Ballard 2559.0000 5443.5700
    WA Bellingham 758.0000 1624.6400
    WA Bremerton 12177.0000 26297.2900
    WA Burien 2783.0000 5916.5900
    WA Edmonds 2041.0000 4195.5500


    How to implement the jquery code to make it work properly..


    Sample image is

    Name:  table image.png
Views: 431
Size:  34.5 KB


    Thank you...

  4. #4
    Join Date
    Feb 2013
    Posts
    530

    Default

    Group by table component aggregations is an urgent requirement for me .. Did any one try this ?

  5. #5
    Join Date
    Dec 2017
    Posts
    1

    Default Would you please share me how you solve the fourth or4th issue? Thank you in advance.

    Quote Originally Posted by sadakar View Post
    4th one is partially done as per the AddIn reference example..

    Now focused on , aggregations on grouped data and the grand sum.. should show for each of the page .

    ( If I select 10 in the drop down it has to show the aggregation of 10 values , if I select 25 to show it has to show the grand total of 25 values --- This is without group by )
    Would you please share me how you solve the fourth or4th issue? Thank you in advance.

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.