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
------------------------------
Original Message:
Sent: Fri November 20, 2020 02:07 PM
From: Leif Glaes
Subject: Adding baseline to a linechart visualization
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