Guidelines for calculating the total value within a specific time frame

Question

Guidelines for calculating the total value within a specific time frame

For my current project, I am using LocalStorage to store an array of dates and costs. When the code localStorage.getItem("todos"); is executed in the console, the output looks like this:

"[{"due":"28/10/2017","task":"80"},{"due":"06/10/2017","task":"15"}]"

In this array, "due" represents the date and "task" represents the amount.

I have successfully calculated the total cost by utilizing the following method:

total: {
  type: String,
  value: () => {
    var values = localStorage.getItem("todos");
    if (values === undefined || values === null) {
      return "0";
    }
    var data = JSON.parse(values);
    var sum = 0;
    data.forEach(function(ele){ sum+=Number(ele.task)}); return sum;
  }
}

My next challenge is to calculate the total cost for the past six months. I am unsure about the approach that should be taken to accomplish this task. Any suggestions on how I can achieve this?

javascript arrays sorting polymer local-storage

Answer 1

Answer №1

During your current iteration, ensure to implement a check to calculate the sum only for values within your specified date range. Incorporating a library such as moment can simplify this task significantly.

const data = [
  { due: '28/10/2017', task: 80 },
  { due: '06/10/2017', task: 15 },
  { due: '10/05/2000', task: 3000 }
];

const sixMonthsAgo = moment().subtract(6, 'months');

const total = data.reduce((acc, item) => {
  const dueDate = moment(item.due, 'DD/MM/YYYY');
  return acc + (dueDate.isAfter(sixMonthsAgo) ? item.task : 0);
}, 0);

console.log('total should equal 95: ', total);

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.19.1/moment.min.js"></script>

Answer 2

During your current iteration, ensure to implement a check to calculate the sum only for values within your specified date range. Incorporating a library such as moment can simplify this task significantly.

const data = [
  { due: '28/10/2017', task: 80 },
  { due: '06/10/2017', task: 15 },
  { due: '10/05/2000', task: 3000 }
];

const sixMonthsAgo = moment().subtract(6, 'months');

const total = data.reduce((acc, item) => {
  const dueDate = moment(item.due, 'DD/MM/YYYY');
  return acc + (dueDate.isAfter(sixMonthsAgo) ? item.task : 0);
}, 0);

console.log('total should equal 95: ', total);

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.19.1/moment.min.js"></script>

Answer 3

Answer №2

Here is a unique solution to help resolve the issue at hand:

// By utilizing a forEach loop and performing a test, we can find the solution.
// Setting up an array of objects with dates and corresponding tasks
var todos=[{"due":"28/10/2017","task":"80"},{"due":"06/10/2017","task":"15"},{"due":"06/04/2017","task":"15"},{"due":"06/02/2017","task":"15"}];
var sum = 0;
var minDate = new Date();
var month = minDate.getMonth()+1-6; // calculating current month minus 6 months
var year = minDate.getFullYear(); // retrieving current year
if(month < 1){ // adjusting month based on condition
month+=6;
year-= 1;
}
minDate.setMonth(month); // updating min date by subtracting 6 months
minDate.setYear(year); // updating year if needed

todos.forEach(function(ele){
var arr = ele.due.split("/"); // extracting day, month, year from French date string
if(arr.length==3){
var dueDate = new Date(arr[2],arr[1],arr[0]); // creating task date object
if(dueDate>minDate){ // checking if task date is not too old
sum+=parseInt(ele.task); // adding task value to sum
}
}
});
console.log(sum);

Answer 4

Here is a unique solution to help resolve the issue at hand:

// By utilizing a forEach loop and performing a test, we can find the solution.
// Setting up an array of objects with dates and corresponding tasks
var todos=[{"due":"28/10/2017","task":"80"},{"due":"06/10/2017","task":"15"},{"due":"06/04/2017","task":"15"},{"due":"06/02/2017","task":"15"}];
var sum = 0;
var minDate = new Date();
var month = minDate.getMonth()+1-6; // calculating current month minus 6 months
var year = minDate.getFullYear(); // retrieving current year
if(month < 1){ // adjusting month based on condition
month+=6;
year-= 1;
}
minDate.setMonth(month); // updating min date by subtracting 6 months
minDate.setYear(year); // updating year if needed

todos.forEach(function(ele){
var arr = ele.due.split("/"); // extracting day, month, year from French date string
if(arr.length==3){
var dueDate = new Date(arr[2],arr[1],arr[0]); // creating task date object
if(dueDate>minDate){ // checking if task date is not too old
sum+=parseInt(ele.task); // adding task value to sum
}
}
});
console.log(sum);

Guidelines for calculating the total value within a specific time frame

Answer №1

Answer №2

Similar questions

An error occurred when attempting to search for 'length' using the 'in' operator in the context of the Datatables plugin and jQuery 1.11.3

What steps can be taken to enable users to draw a path on a Google Map?

Error message: SDL2 (emscripten) is encountering an unidentified data structure called "SDL_RendererFlip"

Ways to transform date into a different structure using JavaScript

When using Jest, it is not possible to match 'undefined' using 'expect.any(Object)' or 'expect.anything()'

Using React JS to Sort an Array Based on a Specific String

Is there a way to refresh CSS styles when the window width is adjusted?

What is the method for concatenating two strings in JavaScript without any whitespace in between?

Firebase Authentication error code "auth/invalid-email" occurs when the email address provided is not in a valid format, triggering the message "The email address is

Select a different radio button to overwrite the currently checked one

Refreshing a Node.js server page upon receiving a JSON update

The React Native app mysteriously crashes repeatedly without generating any error logs when using the same component multiple

Passing a variable through jQuery onClick event to a URL via GET request and subsequently loading the content of

Change to JSONArray using angularjs

Obtain the final value within a URL's path segment

Searching for the search parameter in the Wordpress admin-ajax.php file. What could it

Is there a solution to resolve the Firestore issue stating: "FieldPath.documentId is not a recognized function"?

In order to indicate the checkbox as checked, I must ensure that its value is set to

Is there a way to verify the functionality of DigitalOcean features using doctl before transitioning to a live environment?

What is the best method for effectively eliminating duplicate objects with the same value from an array?