exporting Tables and Pivot Tables that have been modified by a script

[bminehart]

Hello: I've been exploring a few ways to modify values contained in Table and Pivot Table widgets using the script editor. While I have successfully been able to modify the widget in my browser, when I export the data to CSV or Excel, I'm still getting the original/underlying values from the data model. Is there any way to get around this?

-Ben

[DRay]

Hi @bminehart,

Thank you for reaching out. 

The export function works by running the report in a headless browser and exporting the result, so it does not run the widget scripts because those are run while rendering the visualization. Some of those instances have been resolved in newer version, but it depends on what format you are exporting to. Do you know your current Sisense version?

[bminehart]

We're on 24.3, @DRay 

[jacobd]

I'm having the same issue. I just want the ability to build a percent difference between two pivoted columns. I'm guessing that you are trying to do something similar. I've been using JS to do this, but a client wants to export to excel. If Javascript doesn't load while exporting to Excel is there a Sisense function built in that could be used to pull in two different values from different columns to make calculations?