# Kibana Table Chart Viz to show "-" for unique count of value on weekends **URL:** \ **Category:** Kibana\ **Tags:** kql-kibana-query-language\ **Created:** [September 11, 2023, 10:46am UTC](https://discuss.elastic.co/t/kibana-table-chart-viz-to-show-for-unique-count-of-value-on-weekends/342734 "2023-09-11T10:46:37Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![ArpithaS](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@ArpithaS](https://discuss.elastic.co/u/ArpithaS)\ **Post date:** [September 11, 2023, 10:46am UTC](https://discuss.elastic.co/t/kibana-table-chart-viz-to-show-for-unique-count-of-value-on-weekends/342734/1 "2023-09-11T10:46:37Z")
Hi Everyone, I am trying to create a table using lens viz in Kibana. I need the unique count of a field\_name to be displayed per day (using date histogram with interval: per day) . I have added a query to exclude the weekends . The issue is : - The unique count(field\_name) for the weekends is getting changed to 0 where as i want to set it ""-"(hypen). - When i am trying to make the 0 for weekends as "-", all the values across the table becomes 0 and no color is applied. - Why i need the above is to establish a clear understanding that on weekdays when we expect a value \> 0 and it is 0 , it is being indicated as Red(expected) and on weekends , since we are excluding the weekends from a query the values are being converted to 0 and showing as Red (not expected), because of the code scheme set. - Unable to exclude/ hide only weekend columns. PS: Using Kibana Version 7.14 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 9, 2023, 10:47am UTC](https://discuss.elastic.co/t/kibana-table-chart-viz-to-show-for-unique-count-of-value-on-weekends/342734/2 "2023-10-09T10:47:21Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.