Forum Discussion

SteelChampzz's avatar
SteelChampzz
Helper II
3 years ago
Solved

Average Per Working Days

Hello everyone,   I'm trying to create a measure where I can get the average week total amount just for "ART-RT",my data looks like this: To get this measure in Excel it was the ART-RT Total...
Need Help
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    Hi SteelChampzz 

    I'm not sure if this is what you want. (It seems too simple.)

    I made up some sample data and came up with a simple model.

    If this isn't what you want, I'll need some details on how you want to use it.

    (Also, a weekly average is an average of the whole week - NOT an average of the daily averages.)

    https://1drv.ms/u/s!AnF6rI36HAVkhPIeEthiRMCIS7mi5Q?e=1ZVmS6

     

     

SteelChampzz's avatar
SteelChampzz
Helper II
3 years ago

sure this how my data looks:

 

  • grantsamborn's avatar
    grantsamborn
    Solution Sage
    3 years ago

    Hi SteelChampzz 

    Does an OrderType of "R" indicate if it is "ART-RT"?

    • SteelChampzz's avatar
      SteelChampzz
      Helper II
      3 years ago

      Yes, that is correct

       

      • grantsamborn's avatar
        grantsamborn
        Solution Sage
        3 years ago

        Hi SteelChampzz 

        I'm not sure if this is what you want. (It seems too simple.)

        I made up some sample data and came up with a simple model.

        If this isn't what you want, I'll need some details on how you want to use it.

        (Also, a weekly average is an average of the whole week - NOT an average of the daily averages.)

        https://1drv.ms/u/s!AnF6rI36HAVkhPIeEthiRMCIS7mi5Q?e=1ZVmS6