Forum Discussion

xxenoss's avatar
xxenoss
Icon for Helper I rankHelper I
6 years ago

Calculate rolling Measure Percentage

So I know that this topic has been covered in hundred threads, and I probably have read them all, but still cant make it work. I have this data set https://drive.google.com/file/d/1lah5UpgkTd1umJAy...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi  xxenoss ,

 

The percentages you are calculating are based on what values? Can you share how they are calculated?

  • xxenoss's avatar
    xxenoss
    Icon for Helper I rankHelper I
    6 years ago

    Calculation is as follows

    Measure as it is shown in the example devided by sum of Measure For specific Date, LocatoinA, LocationB, but not Duration.

    For example in the screenshot in will be 127/798, 143/798, 131/798. Basically I need to find Sum of Measure and the devide Mesure by its SUM.