cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Values not appearing in pivot table

amelia
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 ๐Ÿ™‚ 

 

2 REPLIES 2

harikm007
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?

-Hari

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 ๐Ÿ˜