Forum Discussion

jbrolland's avatar
jbrolland
Frequent Visitor
5 years ago
Solved

Improper calculation for non closed items within a month

  current behavior I feel like I am overcomplicating my table but here is the graph I am generating today       However the Open Vs Closed (orange) is not correct for 2021-06. It should ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    jbrolland  You may need to do these as MEASURES not columns because in your calculated table, the value for 6 June is 72 (not 75) because the Opened Year and Month is still in May... 

     

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

jbrolland  You may need to do these as MEASURES not columns because in your calculated table, the value for 6 June is 72 (not 75) because the Opened Year and Month is still in May... 

 

  • jbrolland's avatar
    jbrolland
    Frequent Visitor
    5 years ago

    Thanks I manage to find the solution thanks to your advice, please check my initial post casue there are too many restrictions on replying for unknown reason (I guess because a copy paste it s really frustrating and time consuming).