Javascript fill missing dates with day and 0 count in array

Question

I have an array generated through a code where I'm calculating, for each day from now to 7 days ago, the daily occurrences. Right now my code is skipping the days where there aren't occurrences, but I would like to insert those days together with a 0 count value. Here's my code:

var myObj;
fetch('https://blahblahblah?'+param1+param2+"FromDate"+"="+moment().subtract(7,'d').format('YYYY-MM-DD'))
.then(res=>res.json())
.then(data=>myObj= data);

var myRes= [];

myObj.forEach(function (elem) {
    var date = elem.CreatedDate.split(' ')[0];


    if (myRes[date]) {
        myRes[date] += 1;
    } else {
        myRes[date] = 1;
    }
});

Right now I'm getting a similar result:

2020-12-11: 1
2020-12-12: 2
2020-12-13: 1
2020-12-15: 2
2020-12-16: 1

Because on 12-10 I didn't have any value and on 12-14 neither. Given the startTime moment().subtract(7,'d').format('YYYY-MM-DD')

how can I output the days with 0 values like in the format below?:

2020-12-10: 0
2020-12-11: 1
2020-12-12: 2
2020-12-13: 1
2020-12-14: 0
2020-12-15: 2
2020-12-16: 1

Thank you very much

Edit: here's my obj:

[{Id, Var1, Var2, CreationDate},
{1, 123, Var2, 2020-12-11},
{2, 1234, Var2, 2020-12-12},
{3, 12345, Var2, 2020-12-12},
{4, 1234, Var2, 2020-12-13},
{5, 321, Var2, 2020-12-15},
{6, 3214, Var2, 2020-12-15},
{7, 5432, Var2, 2020-12-16}]

Can you add what you have in myObj?

Md Sabbir Alam
– Md Sabbir Alam

2020-12-16 17:12:00 +00:00
Commented Dec 16, 2020 at 17:12 — Md Sabbir Alam
– Md Sabbir Alam, Commented Dec 16, 2020 at 17:12
updated the question with myObj

thranduil90
– thranduil90

2020-12-16 17:19:02 +00:00
Commented Dec 16, 2020 at 17:19 — thranduil90
– thranduil90, Commented Dec 16, 2020 at 17:19

Md Sabbir Alam · Accepted Answer · 2020-12-16 18:11:20Z

2

Once you calculate myRes You can create an array with last 7 days date and then compare with myRes to create finalResult with the missing dates.

let myRes = {
    '2020-12-11': 1,
    '2020-12-12': 2,
    '2020-12-13': 1,
    '2020-12-15': 2,
    '2020-12-16': 1,
}


const dates = [];
const NUM_OF_DAYS = 7; // get last 7 dates.

for (let i = 0; i < NUM_OF_DAYS; i++) {
  let date = moment();
  date.subtract(i, 'day');
  dates.push(date.format('YYYY-MM-DD'));
}


let finalResult = {};
dates.reverse().forEach(date => {
    if(!myRes.hasOwnProperty(date)) {
        finalResult[date] = 0;
    } else {
        finalResult[date] = myRes[date];
    }
});

console.log(finalResult);

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

edited Dec 16, 2020 at 18:11

answered Dec 16, 2020 at 17:19

Md Sabbir Alam

5,0643 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

thranduil90 Over a year ago

Thanks, that worked! But in some cases I'm not starting from 10 but from 11. How is that possible?

Md Sabbir Alam Over a year ago

Can you explain? I am not sure. Can you please mention those cases so we can debug?"

thranduil90 Over a year ago

Nothing, it was my issue. I need to sort the finalResult, in order to have the array starting from 7 days ago to now. How can I do that? finalResult.reverse() is not working

Md Sabbir Alam Over a year ago

Is your final result am array or object?

thranduil90 Over a year ago

I solved it by reverting dates once and modifying every forEach in order not to revert it every time. Thanks!

Vasilii Kovalev · Accepted Answer · 2020-12-16 17:20:40Z

1

Does this change work for you?

var myRes= new Array(7).fill(0);

answered Dec 16, 2020 at 17:20

Vasilii Kovalev

1561 gold badge2 silver badges7 bronze badges

Collectives™ on Stack Overflow

Javascript fill missing dates with day and 0 count in array

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related