Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Line Chart values Labels

    Posted 21 days ago

    In a report, I have a line chart with 4 measures displayed.

    I want to have values labels only for two measures, like this example :

    Do you think it's possible, with a legacy graph or a visualization ? 



    ------------------------------
    Pierre-Frank MOUZON
    ------------------------------


  • 2.  RE: Line Chart values Labels
    Best Answer

    Posted 21 days ago

    Hi Pierre-Frank,


    that's a task for the "Charts", whioch can be selected i the zop right corner of the "Visualization gallery" window.

    You just have to add a second chart type to the "Combinations" property. Select the chart, click "Combinations", add a second chart type to "Primary Axis". Add your measure and you'll end up with to individual chart types that can be modified. 

    In my case I just show values for "Revenue" but not for "Planned revenue" on the second chart type. To modify the properties of the chart, just select the tiny chart icon next to the measure name.

    There might the same approach with "Visualizations" but I haven't tried this out.



    ------------------------------
    Robert Dostal
    Principal Expert BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Kupferzell
    ------------------------------



  • 3.  RE: Line Chart values Labels

    Posted 17 days ago

    It works perfectly with legacy charts, as I wanted :-)

    Axis scale is preserved.

    Many thanks Robert



    ------------------------------
    Pierre-Frank MOUZON
    ------------------------------



  • 4.  RE: Line Chart values Labels

    Posted 17 days ago

    Hi all, here more examples "of the power of legacy charts" ;-)

    Show only the values of actual month and last month:

    https://www.cognoise.de/diagramme-formatieren-in-ibm-cognos-10-report-studio-3343

    IBCS / Hichert Style Charts:

    https://www.cognoise.de/charts-im-hichert-style-mit-cognos-3579

    Values perfect placed under the bars:

    https://www.cognoise.de/werte-korrekt-unter-saeulen-platzieren-diagramme-33381

    :-) Jens



    ------------------------------
    Cognos Tipps: https://www.cognoise.de
    Lernvideos: https://apparo.university (also in english - please PM)

    Jens Bäumler
    Cognos Analytics, Planning Analytics and watsonx BI
    Apparo Group, Germany
    www.apparo.de
    ------------------------------



  • 5.  RE: Line Chart values Labels

    Posted 16 days ago

    Conditional display of values? Wow, didn't know this is possible and had just recently this requirement. Thanks for sharing!



    ------------------------------
    Philipp Hornung
    Product Owner & BI Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------



  • 6.  RE: Line Chart values Labels

    Posted 15 days ago

    I found a solution, with a query calculation, not using conditional display.

    Add a second primary axis and a query calculation with expression like : if ([month]=12) then ([quantity]) else (null)
    In my example if want values only for December month :
    Now you have just to adapt the if condition to meet your requirement.
    For the second primary axis, I put a dot only style, no line to display



    ------------------------------
    Pierre-Frank MOUZON
    ------------------------------