I have a calculation sample/formula that outputs the site score mainly based on these parameters,
- Page Views
- Average Session Duration (Floating point number that is in minutes and seconds i.e. 1 minute 30 seconds would be 1.30.
- Top 3 Geolocations from which the website is most frequently visited and their percentages (e.g. (UK 30%, US 16%, Germany 10%).
- Site Revenue (Monthly Avg. Net)
This works fine in MS Excel.
Here's the calculation sample/formula
Calculation image removed because of client safety and policy.
Now the thing is that I am trying to reproduce this exact formula into JavaScript code, and I am not that familiar with JavaScript Maths, plus some things from the calculation sample are slightly unclear to me.
Here's what I tried:
const siteEvaluationFormula = ((PageViews - 100000) / 750000 * AvgSessionDuration * (totalPercent * 60) ... nothing after this I just gave up in confusion);
I'm stuck when it comes to calculating the minimum of two numbers. What do I use to calculate the minimum in JavaScript?
CodePudding user response:
I think you are looking for Math.min to complete your formula
const siteEvaluationFormula = Math.min(60, ((PageViews - 100000) / 750000 * AvgSessionDuration * (totalPercent * 60) Math.min(40, SiteRevenue/5000*40));