cancel
Showing results for 
Search instead for 
Did you mean: 

custom queries in widgets

mbussey
7 - Data Storage
7 - Data Storage

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

2 REPLIES 2

DRay
Community Team Member
Community Team Member

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.

David Raynor (DRay)

DRay
Community Team Member
Community Team Member

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.

David Raynor (DRay)