Forum Discussion

PamelaS's avatar
PamelaS
New Member
6 years ago
Solved

Show days with zero value

Good morning, I could use a hint. I have a data table with the hours worked by each employee I tried to visualize the totals for each day for each dependant, but I noticed that it does not allow m...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi PamelaS,

    I'm not so sure what visual you use, can you please explain more detail? 
    If you are working with table visual, you can right-click on its fields and choose 'do not summarize' and 'show item with no data' options to force display whole items.

    If you are working with charts, it is impossible to display records with blank/zero values, they will be summarized based on category fields. (Current you can't ignore/cancel this operation)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You give up to easily. Can you provide some sample data of your structure so i can show you how to do this?

PamelaS's avatar
PamelaS
New Member
6 years ago

Hi Anonymous 

I'd like to see in the table below even the days with zero hours worked...

Thanks a lot

Pamela

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    When i press show items with no data it does work. it does show me all the dates in my date table tho. So you have to filter that somehow.