Forum Discussion

klio's avatar
klio
New Member
6 years ago

Predicting Days Until a Goal

Good night my goal is to create a dashboard that helps me know how many days i have left to reach my goal based on my current progress

since I have duplicates I am using a distinctive count to know what is the progress , my goal is 40 unique records

 
 

3 Replies

  • az38's avatar
    az38
    Community Champion

    Hi klio 

    please, provide a desired output based on your data sample

    • klio's avatar
      klio
      New Member

      hello this is what I have what I need to add are two indicators, one that tells me how many days have elapsed since my first registration and another that tells me how many days I have left to meet my goal

      https://ibb.co/Ch2TPBg

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support

        Hi klio 

        From the two columns, i can't find any rule to define goal and current progress.

        Do you have any other columns to define when is the goal and when is the current progress?

         

        Best Regards

        Maggie