2 Replies Latest reply on Aug 6, 2018 2:38 AM by meenu choudhary

    How to calculate elasticity per Months

    Goncalo Alemao

      Hello,

       

      I hope I can get some help from the Tableau community.

      Basically, I would like to calculate the elasticity of some of my products, meaning that, I would like to know what is the reaction of the Demand side when I offer more products of a certain type, in comparison with the previous month.

      You can see bellow a table the describes my database:

       

      Product IDDateQuantity Offered# of OrdersElasticity MoM
      1Jan1020-
      1Feb2030(30-20)/(20-10)
      1Mar2525(25-30)/(25-20)
      2Jan510-
      2Feb1030(30-10)/(10-5)

       

      The ultimate idea is to see on a chart the evolution of my demand according with the supply that I'm offering and see what is the optimal point.

       

      Thank you for helping me!

       

      Hope you have an amazing day!