Values not appearing in pivot table

[amelia]

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 🙂 

[harikm007]

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?

-Hari

[amelia]

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 😅