Forum Discussion

Ritaf's avatar
Ritaf
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Kpis modeling - general question

Hi all, I am creating my first kpi's dashboard. I have some doubts  whith what is the best practice to create it. Specialy my question is about goals and targets. For Example my first  KPI relate...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • tex628's avatar
    tex628
    6 years ago

    If the amount of KPI-target values are few there is no issue with having them as constants in a measure. If anything i would move the "0.8" into a different measure in case that you need to use the target value in other calculations. 

    Target % = 0.8

TargetValue = [NumOrders]*[Target %]

     

Ritaf's avatar
Ritaf
Icon for Responsive Resident rankResponsive Resident
6 years ago

 

Hi ,

Thank you for your repli

The goals are preety stable .

I just not sure , that my way is a good enough because it's my firt skpi's project.

I think it's can be simple mesure like:

Target = [NumOrders]*0.8 (for goal)

And 

NumTypedOrders = calculate (distinctcount([NumOrders), filter(TimeOrdering = "0-1 days))/[NumOrders] (for excecution)

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

If the amount of KPI-target values are few there is no issue with having them as constants in a measure. If anything i would move the "0.8" into a different measure in case that you need to use the target value in other calculations. 

Target % = 0.8

TargetValue = [NumOrders]*[Target %]

 

  • Ritaf's avatar
    Ritaf
    Icon for Responsive Resident rankResponsive Resident
    6 years ago

    Thanks a lot . I will go by this way ğŸ™‚