General Discussion

 View Only
  • 1.  CTool Heat Map colour

    Posted 12-06-2021 19:13
    Hi All,

    I'm having trouble to make the Heat Map's colour fix for the specific box.
    The client does not want the colour based on the total number, but based on the location of the box

    Actual Requirement form the client.
    Name:  Actual.PNG
Views: 848
Size:  14.9 KB
    All colours should follow the exec as above regardless the total number.

    But the standard heat map only showing colour based on the total number.
    We are able to create the heat map as above but the colour in dynamic.
    Name:  Pentaho.jpg
Views: 541
Size:  14.8 KB

    Is there any option to make the colour fix/predefined based on the location of each box?

    Thanks in advance.

    ------------------------------
    Syed Syed
    Systems Engineer
    GRC Partners Asia Sdn Bhd
    ------------------------------


  • 2.  RE: CTool Heat Map colour

    Posted 12-08-2021 11:12
    hi @Syed Syed i cant help with your question but i would love to know how you created the risk heat map ​! We use that diagram but do it in excel, would love to be able to do it in pentaho

    ------------------------------
    Penelope Jackson
    Systems Engineer
    computershare
    ------------------------------



  • 3.  RE: CTool Heat Map colour

    Posted 12-13-2021 10:50
    Hi @Penelope Jackson

    I'm not an expert, I just edit the existing report, I can give you the code of the SQL queries, please PM me for details.

    Thanks​

    ------------------------------
    Syed Syed
    Systems Engineer
    GRC Partners Asia Sdn Bhd
    ------------------------------



  • 4.  RE: CTool Heat Map colour

    Posted 12-09-2021 12:15

    Hi, isn't this quesion a duplicate of

    https://community.hitachivantara.com/communities/community-home/digestviewer/viewthread?GroupId=139&MessageKey=cf88892c-632f-4fbe-a2b0-b3a812481c63&CommunityKey=e0eaa1d8-5ecc-4721-a6a7-75d4e890ee0d&tab=digestviewer

    to which you'd added a solution yourself?



    ------------------------------
    Duarte Cunha Leao
    Software Development Engineer - Specialist
    Hitachi Vantara
    ------------------------------



  • 5.  RE: CTool Heat Map colour

    Posted 12-13-2021 10:50
    Yes, sorry, OI'm new here. How do i lock this one or delete this one?

    ------------------------------
    Syed Syed
    Systems Engineer
    GRC Partners Asia Sdn Bhd
    ------------------------------