1 of 1 people found this helpful
You can perform conditional formatting based on your DATEDIFF() calculation.
Assuming you have created a calculated field to compute the date differences:
You can create another calculated field to specify two outcomes: one where your date difference is lower than 20, and one where it is equal or higher than 20.
Place that field onto the Color shelf on the Marks card and your date difference results will be formatted by one of two colors depending on the value. You might have to change the colors to your liking.
(I used my own dummy data to test it, don't worry that it doesn't match your example.)
Thanks for quick reply
But i need split the project 1 and 3 also
project 1 has 59 days under 59 < 20 days is green and >20 is red like that i need graph
Continuing from my example, if you were to place the calculated field "Date Diff Color" onto Filter, you could 'split' your projects by keeping only 'green' or 'red' projects, if I undestand you correctly.
For instance, you could filter on 'Green', then duplicate the sheet, and adjust the filter to 'Red' on the duplicated sheet. Then you can create two graphs where 'green' and 'red' projects are split.