Forum Discussion

rpn7kor's avatar
rpn7kor
Frequent Visitor
6 years ago

Graph using multiple columns in X axis

Dear Together,   I got a requirement to create a graph to represent the project growth. I tried with some measures and tables. But couldnt get the desired output. So need your support.   We have ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi rpn7kor ,

Could you please provide the calculation logic of Running and Total? For example: Year 2018, why the number of running projects is 3, but the total number of projects is 6? How to calculate them?

Best Regards

Rena

rpn7kor's avatar
rpn7kor
Frequent Visitor
6 years ago

Hi Rene,

 

Thanks for your message.

 

Year 20142015201620172018
Running (Current year + previous years) 22323
Closed (which are completed) 11 1
Total Projects (Current year + previous years)22456

 

For example , 2018 has total of 6 projects (2 from 2014 + 2 from 2016 + 1 from 2017 + 1 from 2018)

                       and has 3 running projects (total project - closed projects)

 

Thanks.