Forum Discussion

Antonio195754's avatar
Antonio195754
Icon for Helper IV rankHelper IV
3 years ago
Solved

In a table visual using a date field with other measures in table, how to display dates with 0 data

Hi i am bringing in data to later export where the first table is what i'm currently displaying. I have several sellers where i'm trying to show by each seller what activity they had by date, and when there is no data for the given day, to show that as zero. I'm trying to have my end result look like the second table.  I've created a date table and created a relationship between date to date field where my seller activity resides.  I tried the "show items with no date" using the date field in my seller activity table (also tried bringing in the date field from my created date table) and that didn't work.  I tried creating a measure for quantity +0 logic and that didn't work.  Can someone please help with what i'm missing to fill in the dates with no activity please

 

NameDateQuantity
Alex01.02.231
Alex01.04.233
Alex01.06.237
Alex01.12.232
Alex01.27.233

 

NameDateQuantity
Alex01.02.231
Alex01.03.230
Alex01.04.233
Alex01.05.230
Alex01.07.236
Brian01.01.235
Brian01.02.233
Brian01.03.230
Brian01.04.230
Brian01.05.231

 

3 Replies