custom queries in widgets

Question

I have a very simple ask. When I go into widgets I am able to click on the three dots and hit Analyze SQL Query but I don't see a way to edit it. I would like to be able to edit the query, is there a way to do that? I need to create custom calculated fields that sisense can't do, i.e. I need to do some complex window functions so they dynamically update as the user moves around the date range.

Thank you in advance

dray · Answer

Hi&nbsp;mbussey,
Here is some documentation that may help.&nbsp;
https://docs.sisense.com/main/SisenseLinux/editing-sql-statements.htm
https://docs.sisense.com/main/SisenseLinux/creating-and-editing-a-formula.htm
I hope that helps. If not please provide additional details around your use case and we will help in any way we can.

dray · Answer

Hi&nbsp;mbussey,
I wanted to follow up to see if the solution offered worked for you.
If so, please click the 'Accept as Solution' button so that other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.
Thank you.

Forum Discussion

custom queries in widgets

2 Replies

Recent Discussions

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

Blox conditional formatting up and down indicators

Remove Widget Title Box

Change Legend Category Names

Rename the Pivot Grand Total

Sisense

Support

Resources