Force Pivot Table to display count as "0" when nothing has been entered for that filter

[Lori Wilson]

Hello, 
I want to display pivot tables using Count function that will show ONLY the count of items that have been entered, depending on filters. I've gotten this to work perfectly when there is data entered to match a filter. But when there is no data for that filter, I want a "0" to display. Instead, when there is no data, the empty table displays until data is entered for that filter. How can I get this to simply display the number 0 instead of trying to display the table? The top table, displaying a simple "1" is perfect. Now all I need is for a "0" to appear instead of the empty table when nothing matches the filter I've set up on the TableView.

  

[Nikita Kamai]

Hello,

I am Nikita from Stiltsoft - we are developing Table Filter, Charts & Spreadsheets for Confluence .

Please, wrap your source config with Table Transformer and add the following SQL (my custom example):

SELECT 'Count'::string as 'Count ' FROM T1

NB. In the Pivot Table settings, make sure you uncheck the option Show single-cell result as text and check it in the Table Transformer instead.

This should display 0 in case the table is empty.

Best wishes,
Nikita