Forum Discussion

amelia's avatar
amelia
ETL
05-06-2022

Values not appearing in pivot table

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 🙂 

 

dashboards & reporting
data models

2 Replies

Replies have been turned off for this discussion
  • harikm007's avatar
    harikm007
    Data Warehouse
    05-08-2022

    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's avatar
      amelia
      ETL
      05-09-2022

      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 😅