Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Average YTD with summarized data

I am attempting to show average ytd (Jan shows Jan, Feb shows av(Jan,Feb), Mar shows av(Jan,Feb,Mar)...) in a line graph, but I cannot figure it out. I have east coast and west coast data. Each ins...
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Didn't quite work. Date field not as robust. Sample data:

    NEED: average ytd quantity east as a percent of total quantity by period, (for month 1: av(month 1), for month 2: av(month1 and month 2)….

     

    MonthPeriodic Month Deadline DateTotal QuantityQuantity LocationQuantity EastMonthly Average of East/Total YTD%
    11/12/202218823East18823 
    11/12/20221243East1243 
    11/28/2022465743East465743 
    11/28/202224352West0 
    22/10/202223425West0 
    22/10/2022254254East254254 
    22/10/2022684East684 
    22/10/20223457West0 
    22/19/202234West0 
    22/19/2022757333East757333 
    22/19/20223456West0 
    22/28/202223525East23525 
    22/28/2022757West0 
    22/28/2022346West0 
    33/4/2022377658West0 
    33/4/20222654West0 
    33/4/202216382East16382 
    33/19/2022618647East618647 
    44/4/2022984West0 
    44/4/20226115West0 
    44/4/20226184West0 
    44/4/20224968136East4968136 
    44/19/20224984East4984 
    44/19/202213854East13854 
    44/19/20221683East1683 
    44/30/2022968413West0 
    44/30/20226814East6814 
    55/2/20228641West0 
    55/2/2022384341West0 
    55/2/20224684East4684 
    55/2/2022168616West0 
    55/12/20226484East6484 
    55/12/2022165West0 
    55/12/2022648West0