Showing results for 
Search instead for 
Did you mean: 

Values not appearing in pivot table

10 - ETL
10 - ETL

Hi all, I am creating a pivot table widget in Sisense and the values are all showing up as 0. I double-checked the widget JAQL and they're all using the same table so that shouldn't be the issue. I also checked the Sisense analytics for the table and the values are appearing there. I attached images of how it looks in the Sisense table preview statistics and how it looks in the pivot table. I would greatly appreciate any help 🙂 



13 - Data Warehouse
13 - Data Warehouse

Hi @amelia ,

Can you share bit more details - 

1. Is there any widget/dashboard filters applied?

2. Can you share a screenshot of sample data of calendar_date and uniqueSubCount?


Hi @harikm007 

1. No, there aren't any widget filters applied 

2. Sure, here is the screenshot for calenda_date and uniqueSubCount - they are separate screenshots because there are many columns between 😅