Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cumulative Unfinished Projects

Hi, I need both a bar graph and the underlying details (in a table) to show projects when they started until they finish, carrying over unfinished projects into the next quarter.   Basically the d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

This is amazing. Thanks you!  The final add is to get a count and sum of count if the value is populated. I cannot get the has one filter to work with these relationships.

Thanks

Brendan

 

lbendlin's avatar
lbendlin
Super User
2 years ago

what would the expected result look like?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago
    Fiscal Year QuarterProjectStatusCount
    2022Q1A 0
    2022Q1B 0
    2022Q2AIn Progress1
    2022Q2B 0
    2022Q3AIn Progress1
    2022Q3BNot Started1
    2022Q4ADone1
    2022Q4BNot Started1
    2023Q1A 0
    2023Q1BNot Started1
    2023Q2A 0
    2023Q2BNot Started1
    2023Q3A 0
    2023Q3BNot Started1
    2023Q4A 0
    2023Q4BNot Started1
    Total  9
      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I love this solution but if I try to graph this measure, I get a different result. I am hoping again to have the max status per project per quarter and I get multiple values here because of the sumx.  The table looks just great but definitely would need to adjust to see this more visually?

        Any thoughts.

         

        Thanks