Forum Discussion

lukas_alex's avatar
lukas_alex
Frequent Visitor
9 years ago

Averaging data based on a Date range in a visual

I am looking to create a report on mark up data.  To make this report each entry has a start date, an end date, and a markup percentage.  I want to create a visual that shows the average markup month...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

How big is the date range between each entry?

lukas_alex's avatar
lukas_alex
Frequent Visitor
9 years ago

On average 5-6 months

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    So do you want an entry that goes from January to June to be weighted in the average of every month from January to June? 

    • lukas_alex's avatar
      lukas_alex
      Frequent Visitor
      9 years ago

      yes that is what I am looking for

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        I don't think there's another way you could do it without creating another table. 

         

        The January-June entry would need to somehow have the value of each month from January-June in one sliceable column but idk how that could be done.

         

        But with another table you could easily go:

         

        calculate(average[metric],filter([Start Date]<=[Date] && [End Date]>=[Date]