Forum Discussion

Amy's avatar
Amy
Data Storage
03-25-2022

Pivot Table widget - column headers and column data out of alignment

I am seeing odd behavior in a pivot table widget.  This is a widget that has been in production for some time, and it gets updated once a week with a new batch of data.  This week, for the first time, the column headers are out of alignment with the data columns.  

When I filter the data, the issue disappears in most cases, so I think it must be caused by something weird in the new batch of data (maybe an unexpected or invisible character, or a new combination of the dimensions), but I haven't been able to pinpoint any bad data yet.  

Even if it is a problem with the data, the behavior in Sisense seems strange so I thought I would post a question here, in case anyone has encountered a similar issue.  Attached is a screen shot.  The widget on top is a pared down version of the widget in production that demonstrates the issue.  The two widgets on the bottom show that the issue is resolved with some tweaks to the dimensions/rows.

Any thoughts would be appreciated.  Thanks!

dashboards & reporting

3 Replies

Replies have been turned off for this discussion
  • hlorosc's avatar
    hlorosc
    Cloud Apps
    03-28-2022

    Amy  I've run in to this a few times. Sometimes just resizing (and then sizing back), refreshing, or republishing fixes it for more. If not, I've gone in to edit the widget and usually just delete/re-add the column. Don't have a reason for it, but in all my cases it's been temporary.

    • Amy's avatar
      Amy
      Data Storage
      03-28-2022

      hlorosc - thanks so much for the response.  I did try some resizing and deleting/adding columns when the issue first appeared.  I also tried deleting and rebuilding the filters, wondering if the set of dependent filters was somehow causing the problem.  None of those things resolved it.    I ran through those things one more time just now - still no luck.

      The issue disappears when I filter on a different time period (Week Ending = 3/16/22 instead of Week Ending = 3/23/22, for instance.)  That makes me think it has something to do with the underlying data, something that Sisense is handling in a weird way.  I'll keep hunting.

      Thanks very much for the suggestion though.  Much appreciated.

      • AssafHanina's avatar
        AssafHanina
        Sisense Employee
        12-15-2024

        Hey Amy ,

        i do suggest to raise a support ticket for further assistance as it's sounds like misbehavior. 

        Additionally, i see 3 Pivots which are looks similarly which have different or additional grouping level:

        • State --> Contract
        • Contract --> State 
        • Contract --> Practice (State)

        Since the Metrics seems to be identical and the Dimensions are swapped, Suggest to review the ability of providing the Dimension group by as DropDown/Buttons. 

        Here is an Community Article as reference which might fit for the use case and it's not a premium solution. 
        Using Single pivot instead of 3 pivots can provide the users interaction with the dashboards and reduce the load time

        best regards