Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Unable to calculate % of projects in green status in performance analytics

Arjun Reddy Yer
Mega Sage

Required help on the below requirement @Ankur Bawiskar @Vasantharajan N @Ahmmed Ali @RaghavSh 

As in Performance Analytics I was trying to display the Projects in Green Status but when ever the Project Status changes from one color to another color the % in the report is not getting change.

Tried with Formula Indicators but unable to get the result. 

Number of green projects has changed in the last few weeks, so the percentage in the chart is to change a little as well. But it shows the same number of % for week, which doesn't match.

 

Result Graph: 

ArjunReddyYer_0-1759866836978.png

Indicator Source:

ArjunReddyYer_1-1759867034970.png

ArjunReddyYer_2-1759867134150.png

Indicators:

ArjunReddyYer_3-1759867299402.png

ArjunReddyYer_4-1759867339344.png

ArjunReddyYer_5-1759867421802.png

Formula Indicator:

ArjunReddyYer_6-1759867548322.png

ArjunReddyYer_7-1759867596090.png

ArjunReddyYer_8-1759867673047.png

ArjunReddyYer_9-1759867715525.png

Widget:

ArjunReddyYer_10-1759867836819.png

ArjunReddyYer_11-1759867876848.png

ArjunReddyYer_12-1759867912063.png

ArjunReddyYer_13-1759867955846.png

Scheduled Data Collection:

ArjunReddyYer_14-1759868124344.png

ArjunReddyYer_15-1759868204179.png

 

1 ACCEPTED SOLUTION

Arjun Reddy Yer
Mega Sage

Got the solution by doing changes as mentioned below

ArjunReddyYer_0-1760031526718.png

ArjunReddyYer_1-1760031580916.png

ArjunReddyYer_2-1760031662210.png

 

View solution in original post

6 REPLIES 6

RaghavSh
Mega Patron

@Arjun Reddy Yer what is in the job logs? Is it collected successfully ?


Raghav
MVP 2023
LinkedIn

It's collecting successfully

ArjunReddyYer_0-1759928116137.png

 

 

% of the Green projects is not getting decrease when the status of the project changes from Green to Yellow.

Goal/Goal*90 doesn’t seems to be a valid formula?


Raghav
MVP 2023
LinkedIn