custom queries in widgets

[mbussey]

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]

Hi @mbussey,

Here is some documentation that may help. 

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]

Hi @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.