Forum Discussion

cubedweller's avatar
cubedweller
Regular Visitor
8 years ago

fill in missing dates

Hi,

I would like to fill in missing dates and add zeros as their count.

For example, I have 9/16/17 (count=2) and 9/18/17 (count=3).

I would like to add 9/17/17 with count=0.

Thank you.

 

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Going to be very difficult to answer without sample data, but you might be able to use something like a Date/Calendar table that has all of the dates and a measure or calculated column in the format of:

     

    IF(ISBLANK(COUNT([column)),0,COUNT([column])