Forum Discussion

amarada's avatar
amarada
Regular Visitor
8 years ago

Any idea to calculate this data ?

I need to calculate the next data: the maximun value from a calculate measure / average form the reste values except the maximun. That is I have two columns: one of them is the city and the other is the sales conversion rate (average format) and I need to calculate the daily average dispersion of this way:

 

(maximun value of sales conversion rate/(average of the rest values-except the masimun value-)-1).

 

Any idea? Thank you very much and sorry for my english

Need Help

5 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    8 years ago

    have no idea if this could work but give it a bash

     

    amarada

     

    conversion =
    var maxconversion = max(table[conversionrate])
    var otheraverage = calculate (average(table[conversionrate]), filter(table[conversionrate]] < maxconversion ))
    return divide(maxconversion , otheraverage)

    • amarada's avatar
      amarada
      Regular Visitor
      8 years ago

       

       Thank you very much, I`m going to try this formula today and then I'll tell you how it was...it looks good

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Could you please share some data and the exact output exxpected.

     

     

    Cheers

     

    CheenuSing