Forum Discussion
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 me to visualize the days where there are no hours worked.
Do you know how to solve this problem?
Thank you very much
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
7 Replies
Hi PamelaS
Click on your table and then, in the Visualizations pane, right click on your 'Date' field and select 'Show items with no data'.
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.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
Thank you all,
I tried to use the function "show item with no data", but as @Xiaoxin Sheng said, unfortunately it doesn't work.
Thank you very much for your help
Pamela
Hi Anonymous
I'd like to see in the table below even the days with zero hours worked...
Thanks a lot
Pamela
