Forum Discussion

Laris_Fdz's avatar
Laris_Fdz
Cloud Apps
04-26-2022

How to switch off Pivot2 columns?

I am looking for a script to switch off columns in pivot2. This option would be available to users, so I suppose I would link it to a Blox botton.

The case is that we use dates in columns and several values. So when half of the month passes the table becomes quite extensive. I would like to be able to switch off columns and have values aggregated by the current month. I have tried to use dimention changer (days / months) but when the agregation is by months, the widget ignores the dashboard filter and shows all months available in the datamodel.

Larisa

Dashboards & Reporting

2 Replies

Replies have been turned off for this discussion
  • GuyRaz's avatar
    GuyRaz
    Sisense Employee
    05-04-2022

    Hi Laris,

    The script can be found here.

    The behavior you experience is as follows:

    • As with any dimension, pivot columns can be filtered.
    • By default, if both widgets and dashboards have filters on the same dimension, then only the widget filter is applied.
    • There is one exception to the above rule - multiple filters on the same date dimension can be applied if they are set on a different date level. Dashboard and widget defined with date dimension filters with the same date level will only use widget filter 
    • Laris_Fdz's avatar
      Laris_Fdz
      Cloud Apps
      05-04-2022

      Hi, Guyraz,

      thank you for your reply. Indeed I have seen that script and tried to modify it but haven't succeed yet.

      I think I wasn't clear. The script you propose deals with the "Values", and I am looking for a way to let users switch on/off the columns without entering inside the widget.

      Larisa