Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am struggling with normalising data. I have some data of prices wrt different companies. I want to rescale the data so that the area between the price-company line and the x-axis(companies) is 1.
Thanks
Hi,
here is an example :
replace Group by company
and avg(sales) by your formula for price-company
regards
Can you add some sample data.
In the measure, add an if condition to create different ranges of price, by that Price - Company can form into different buckets.
Hi,
here is an example :
replace Group by company
and avg(sales) by your formula for price-company
regards
Thanks a lot. It works perfectly!
Have a good weekend.
Thank you!