Forum Discussion

CarlBlunck's avatar
CarlBlunck
Resolver I
3 years ago
Solved

KPI Target

Hi all,   I am using the KPI visual for the 1st time and I am wanting to add a calculated target, but I can't get it to work.   My dataset has a column that contains values (TimeToFill) like so (...
Need Help
  • CarlBlunck's avatar
    CarlBlunck
    3 years ago

    Solved it 🙂 needed to all the ALL function in.

    TimeToFill-Target = 
VAR StartDate = EOMONTH(TODAY(),-14)+1
VAR EndDate = EOMONTH(TODAY(),-1)
VAR Result =
Calculate(
    AVERAGE(fact_PageUpReqData[TimeToFill-OfferAccepted]),
    DATESBETWEEN( fact_PageUpReqData[dim_FirstOfferAccepted.FirstOfferAccepted], StartDate, EndDate ),
    ALL(fact_PageUpReqData)
)
RETURN
Result



CarlBlunck's avatar
CarlBlunck
Resolver I
3 years ago

Solved it 🙂 needed to all the ALL function in.

TimeToFill-Target = 
VAR StartDate = EOMONTH(TODAY(),-14)+1
VAR EndDate = EOMONTH(TODAY(),-1)
VAR Result =
Calculate(
    AVERAGE(fact_PageUpReqData[TimeToFill-OfferAccepted]),
    DATESBETWEEN( fact_PageUpReqData[dim_FirstOfferAccepted.FirstOfferAccepted], StartDate, EndDate ),
    ALL(fact_PageUpReqData)
)
RETURN
Result