Cognos Analytics

 View Only
  • 1.  Adding baseline to a linechart visualization

    Posted Fri November 20, 2020 02:07 PM
    Hi!
    I have got a dashboard with a linechart visualization to which I want to add a horisontal baseline in form of a constant medianvalue (the value is not avalible in the datasource, it´s the median from another year). I can not add any new colums in the database to fix this.

    Is this possible? How can I add this?

    ------------------------------
    Leif Glaes
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Adding baseline to a linechart visualization

    Posted Sat November 21, 2020 12:11 PM
      |   view attached
    Hi Leif,
    One way that you can do this is:
    select the table object where the measure is defined
    add a calculation set it's expression to the value of the baseline
    select this new calculation and set its usage:measure and aggregation:minimum
    add this new calculation to the y-axis box of the vis.

    Please let me know if your application needs a different value per year (or other period), then a different technique can be used w/o a lot of effort.
    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: Adding baseline to a linechart visualization

    Posted Tue November 24, 2020 04:28 PM
    Thank´s Henk!

    ------------------------------
    Leif Glaes
    ------------------------------