Cognos Analytics

 View Only
  • 1.  clustered bar chart - column color

    Posted Wed March 06, 2019 08:14 AM
    Hello everyone,
    I created a clustered bar chart that shows the variance of effort of a project as a Y axis and the date as an X axis. 
    How can I create a column bar with different colors (e.g. red fill color if Y<0 and green if Y>=0)?
    I created a field that returns the color code based on the values of Y and I assigned it to the item color property, but nothing happens (the columns are always the same color).
    Any help would be welcome.
    Regards


    ------------------------------
    Alessandro Tomasini
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: clustered bar chart - column color

    Posted Thu March 07, 2019 07:05 PM
    Could you attach a copy of your report spec or sample report spec. I would want to see what chart engine you are trying to use.

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: clustered bar chart - column color

    Posted Fri March 08, 2019 04:20 AM
    Hi Denny
    thank you for reply. I attached you three images, one to show you how I tried to set column bar color (Page Design.jpg), one with the color field definition (Query Design.jpg) and one with a report preview (Report Preview.jpg).
    I hope you really can help me...
    Regards

    ------------------------------
    alessandro TOM Tomasini
    ------------------------------



  • 4.  RE: clustered bar chart - column color

    Posted Fri March 08, 2019 06:39 AM

    Hello Alessandro,
    Thanks for uploading the files. I will review and get back to you shortly.



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 5.  RE: clustered bar chart - column color

    Posted Fri March 08, 2019 09:19 AM
    Edited by System Fri January 20, 2023 04:19 PM

    I've attached a sample report spec, using 11.0.13, showing two different options.

    Option 1 - uses a union approach, but you have limited control over the palette colors. However, with 11.1.1 you can create a custom palette.

    Option 2 - uses a conditional palette with our Cognos 10 chart engine.



    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Attachment(s)

    txt
    IBM_Sample_Spec_R13.txt   9 KB 1 version


  • 6.  RE: clustered bar chart - column color

    Posted Fri March 08, 2019 10:43 AM
    Hi Denny,
    now I got how to manage (I think I will use the UNION "trick"...).
    Thank you so much for your help.
    Ciao

    ------------------------------
    Alessandro Tomasini
    ------------------------------