Sisense Iframe embedded feature - I want to pass the parameters for the filter dynamically.
In my case, I have GetUserAuditReport Store Procedure with the param UserId. Based on this SP I need to create a table view in sisense. I need to embed this into my application. In this case, how can I achieve this? I going to embed only a widget table based on filtration.1.1KViews0likes1Comment
Quest -Rolling average model
Here I am trying to create a rolling average quest model however Quest fails to load the model when deployed Here is the code : from sisense import pandas as pd import json def main(event, context): window = 5 # Format JSON into data frame for easy manipulation data = event['data'] df = pd.DataFrame() for col in data: if col['datatype'] == "numeric": df[col['name']] = col['values'] # Calculate rolling average df["rolling"] = df.iloc[:, 0].rolling(window=window).mean() # Return output in JSON output = df.to_dict(orient='records') return output856Views0likes0CommentsBloX custom script which adjusts functionality to existing solution for date filter
You can refer to the following article: https://community.sisense.com/t5/knowledge/creating-from-to-date-using-blox/ta-p/771 which already does have a working solution on how to create a date filter with BloX widget, however 100% of customers are expecting after selecting dates within the BloX widget to stay selected, even If the page would be refreshed. This guide would explain and walk you through on how to accomplish such functionality.789Views1like0Comments
Trying to Access the lastBuildTime via the elasticubeMetadata in Linux
Trying to go into the Metadata being bulled in from the Dashboard in order to display whenever the last time the elasticube was updated last. Accessed this when using the windows version buy going into the Meta data can calling on elasticubeMetadata.lastBuiltUtc after pulling in the datasource from the URL. Since switching over to using Linux now getting and error that is stating it is undefined. Does anyone know if there was an update or change with the Linux version. I checked the Documentation and it Mentions trying to call it as lastBuildTime or Last Published but neither of these work.870Views0likes0CommentsExporting Widget to PNG not utilizing dashboard filters
When exporting a widget using the rest API, the result does not include the dashboard filters that affect that widget, is there a way around this. Also is there a method to remove the dashboard title from the PNG that is returned?Solved2.4KViews0likes2Comments
BloX widget height
Hi, I'm new to BloX and I am currently using the transpose pivot template to create a custom table: https://support.sisense.com/kb/en/article/transposed-pivot-table-with-blox I have an issue that the BloX widget is always a fixed height, leaving a lot of white space below the table. I can resize it on the dashboard layout, but every time I edit it, it bounces back to the default height. How can I set the height manually to what I want it to be, or set it to be dynamic to the table contained inside? Thanks!Solved8KViews0likes10Comments
Embedding periscope dashboard in CRM
Hello there, We are using periscope dashboard which are authenticated through google SSO. Now we have a requirement to embed this dashboard in our in house CRM tool with proper authentication. I have read this procedure(https://dtdocs.sisense.com/article/embed-api) on how to achieve but would like to know if anyone have done similar setup with proper authentication..1.3KViews0likes0Comments
showing excluded filters in sisense sdk
Hi, I am working on some functionality where I want to reset t the default filters on every page refresh so to achieve this I am added applyFilter() in sisense sdk implementation but it is only taking active filters in members array it does not show the filters which are in excluded array. Is there any way to reset to default filters on page refresh in sisense sdk ? or what jaql query I can try to pass excluded filters. Note:I have added sisense dashboard using sisense sdk approach.1.2KViews0likes0Comments
How do you have multiple developers work on a single dashboard?
We have several dashboards which we are embedding into a product of ours. We would like to be able to have our dashboard developers go in and edit a dashboard which we are embedding, but it seems like 1) Only an owner can edit a dashboard and then publish it out 2) Changing the "owner" of a dashboard requires exporting and then importing The issue is that the embed link is used by other systems for giving our clients. Is there any way, short of a shared login, to develop dashboards? For example, let's say that we have a dashboard which is embedded in our application that is used my multiple users. We don't want to be in a situation where only one person on our team can edit and publish.2.3KViews0likes3Comments
Formula for counting the views per user
Sisense provides our company with a usage analytics model. now what i want is to count the total number of views per user ? like how many times they have seen a dashboard? how do i do this ? i tried to do count all like DUPCOUNT [Userid] , but this shows unrealistic values. it shows I viewed a dashboard 567 times in the past 7 days. That's not true. then I realized that DUPCOUNT only works on numeric values, does anyone know how to go about this ? i have attached screenshots on the fields available to me, if that helps. thank you.1.5KViews0likes1Comment
BloX custom script which adjusts functionality to existing solution for date filter
You can refer to the following article: https://community.sisense.com/t5/knowledge/creating-from-to-date-using-blox/ta-p/771 which already does have a working solution on how to create a date filter with BloX widget, however 100% of customers are expecting after selecting dates within the BloX widget to stay selected, even If the page would be refreshed. This guide would explain and walk you through on how to accomplish such functionality.
