6 Replies Latest reply on Aug 5, 2018 10:22 PM by sada.ambati

# Variations in dates

HI All,

I want calculates the manager performance based on their dates suppose

i have 5 manger information under 5 manager each manger handing the 10 projects so each project have 'start date' and 'planned end date' and 'Actual end date'

so based on planned end date and actual end dates i want  calculating the performance  is there is chance plan end date have chance to exceed the 20% of that project days means  plan end date (1-jul-2018)and actual end date(31-sep-2018) is 90days  in that 90days  calculates percentages 20% of  90 days suppose 15 days chance to exceeds projects end if it is 200 then 20% is 40 days like that same thing to 'before end date' is if project ends before end date at that time also we need to consider the 20% of the project example  plan end date (1-jul-2018)and actual end date(31-may-2018) so difference is 60 days you calculate the percentage of 60  if 20% is 15 days so this project will end before 15 dyas to end if it cross the 15 days the only it change to another color

how the graph looks  like below the image

and attaching sample data in excel

can any suggest to how to do that graph

• ###### 1. Re: Variations in dates

Nut sure what you are trying to say. But you can use below formula to calculate percentage.

planned no of days:

DATEDIFF('day',start_date,planned end date)

Actual no of days:

DATEDIFF('day',start_date,actual end date)

Then you can play with these 2 measures to get the percentages you want.

• ###### 2. Re: Variations in dates

HI Anik,

can you give the proper deatils

• ###### 3. Re: Variations in dates

I have date difference for every project in that date difference firstly i need to consider the every project date difference 100% if it is date difference is '1 or 200' also i need to consider the 100%

suppose protect no  date diff         date diff Percentages

1                  15                100%

2                     30               100%

3                     45                  100%

4                     -50                 -100%

5                      -60             -100%

in that percentages for  percentages  +20% to -20% is one color  and >20% is one color and >-20% is one color

Please provide me any suggestion or graphs for that

Thanks

• ###### 4. Re: Variations in dates

is it  possible or not

• ###### 5. Re: Variations in dates

You can find the percent diff using below formula:

(DATEDIFF('day',start_date,planned end date)-DATEDIFF('day',start_date,actual end date))/DATEDIFF('day',start_date,actual end date)

then u can put if conditions as per your requirement.

• ###### 6. Re: Variations in dates

Hi Ankit

it was considering like total percentage but i need each date difference as 100%