Cognos Analytics

Expand all | Collapse all

Adding baseline to a linechart visualization

  • 1.  Adding baseline to a linechart visualization

    Posted 6 days ago
    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
    ------------------------------


  • 2.  RE: Adding baseline to a linechart visualization

    Posted 5 days ago
      |   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 2 days ago
    Thank´s Henk!

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