Forum Discussion

marcush's avatar
marcush
Frequent Visitor
8 years ago

Finding the average date an event happens

I'm trying to create a report and find the average date range that a product of ours is sold. I think I need to be able to use a measure so that the date range can be filtered and used for any product or groups of products that we have.

 

We have a very seasonal business, so what I'm trying to define for our products is the average date range that __% of that product is sold between. For example, if we sell 100 of product A in a given year. I want to know what date range were the middle 80 sold (units 11-90). 

 

In the end I am looking to probably use a 3 year average date range. Right now I'm stuck with even finding the date range for 1 year though.

 

Thanks,

Marcus

3 Replies

  • marcush's avatar
    marcush
    Frequent Visitor

    I'm trying to create a report and find the average date range that a product of ours is sold. I think I need to be able to use a measure so that the date range can be filtered and used for any product or groups of products that we have.

     

    We have a very seasonal business, so what I'm trying to define for our products is the average date range that __% of that product is sold between. For example, if we sell 100 of product A in a given year. I want to know what date range were the middle 80 sold (units 11-90). 

     

    In the end I am looking to probably use a 3 year average date range. Right now I'm stuck with even finding the date range for 1 year though.

     

    Thanks,

    Marcus

  • Anonymous's avatar
    Anonymous
    Not applicable

    marcush,

    Could you please share dummy data of your table and post expected result here?

    Regards,
    Lydia

    • marcush's avatar
      marcush
      Frequent Visitor

      Below is a picture of what I'm trying to do. It gets more complicated when there's multiple products in the same table. I also would like to create a 3 year average of the date range.