Forum Discussion
Solved
Target Value KPI Targets
Hello, Have a raw based table with target values for each month. Each raw has a link date for the first date of month. My KPI should calculated for previous day of month and compared with target v...
Hello,
Targets comes from SQL table as is.
One month = one raw devided by columns with different goals values.
Link date field looks like dd-mm-yyyy where day always equal to firtst day of the month.
My KPI is calsulated per day of month.
It mean I need some how to say that IF KPI is calculated for current date, the target value should be picked up for the first date of month or just like a sum for current month (because only one target record exist).
Why the KPI goal target value is not calculated in the same way as
the same formula showing right result for Card visual..