Can use use Switchable Dimensions for Line and Area Charts
I am trying to use switchable dimensions pluggin in Sisense for a line chart and area chart using a date dimensional table where my dates are in numerical values for conventionality. I am trying to use this pluggin to go from monthly, quarterly, and yearly. Can this work?Solved1.7KViews0likes3Comments
Customize Embedded Dashboard Layout
We have some dashboards embedded in our site. We would like to have the ability for the end user to customize their dashboard layout if they choose to do so by dragging and dropping widgets. Is it possible for end users/viewers to have the ability to move a widget within a dashboard but not alter the widget level filtering that can be done by designers or owners of the dashboard? thanks, Zach2KViews1like3Comments
Is it possible to change the scroll bar color?
I have several pivots and tables that require scrolling through. Given that I have a dark background, the scroll bar is hard for users to see. I’d like to change the color to improve the user experience. Ideally, this would be done at a high level, but I would also be happy with any JS to do it at the widget level.4.8KViews0likes6CommentsInclude All filter to use values in list
When I use a filter in the dashboard and select all of the options Sisense doesn't include all of the options, it actually removes the "where clause" as the select all. So if I have three options in a filter and have all of them selected the filter behaves like there is no filter selection but what I really want is to filter by 3 three selected options, not the absence of a selection. Does this make sense? I want the filter actually filter by all of the selected items when all items are selected.Solved2.9KViews1like5CommentsWidget Custom Grouping
I have a pie chart of IP address that is counting logins. I would like to group the IP address that are similar into one group. So if the IP starts with 172.168.243.xxx then that would be group 1 then 174.166.222.xxx would be group 2. I can do this using MySQL statements but I would like to do this in the widget if possible so the elasticube doesn't need to change/build and someone building a dashboard or widget can have the ability to build these.Solved2.7KViews0likes4Comments
Tabber Automatic Switching
Hello All, I am creating a dashboard that is displayed on a TV monitor and someone will not be able to manually click between the tabs. Has anyone had success creating a script that would switch between the two tabs automatically every 30 seconds?Solved2.5KViews0likes5Comments
HTTP Error REST_API Jupyter Notebook
Hi, I am using REST_API from the custom code section and want to query my elasticube but i am getting a below error: {'error': {'status': 401, 'httpMessage': 'Unauthorized'}} I am using the below query: logical_sql_res = sisense_conn.get_logical_sql(query=logical_sql, cube_name=cube_name) results = [x[:] for x in logical_sql_res["values"]] But facing issues, this was working fine last week. Can someone help?1.5KViews0likes1Comment
Hyperlink KPI Widget
Hello Experts! Client requested to have the KPI widgets (Indicator) contain hyperlinks that would direct them to another dashboard or site link once clicked. Is that possible? Hoping someone can help me with this ask. Any tips will do! Thank you in advance.Solved3.6KViews0likes3Commentsnulls to 0 in pivot
I am trying to get nulls in a pivot to show as 0's, which seems like it should be very basic built in functionality. I have tried If's, case's, and jquery scripts and nothing seems to work. I can do this at the SQL level buy I am trying to count in the widget and not in the query. I have read threads for 9 years ago where this was still a problem. How is this still an issue and not a quick function or easy setting??? What I've tried: if(isnull(DUPCOUNT([device])),0, DUPCOUNT([device])) <-- this counts everything fine but blanks instead of 0 case when isnull(DUPCOUNT([device])) then 0 else DUPCOUNT([device]) end <-- this counts everything fine but blanks instead of 0 In the edit script section: widget.transformPivot( { type: ['member'] }, function (metadata, cell) { if(cell.value === '') { cell.content = '0'; } } ); AND widget.on('ready', function(){ $('td[class*=p-value] div').map(function(i, cell) { if(cell.innerHTML == " " ) cell.innerHTML='0'; }) }) }) Any ideas?Solved3.6KViews0likes2Comments
Export to PDF Customise
Hello, I would like to know if there are any best practice on creating a dashboard which will give me a clean pdf export currently, my basic charts are distorted and divided into 4 separate pages blox widgets are of uneven sizes Widget titles are exported even though I have hidden them on the dashboard level I am not using any tabbers here if there is a script I can use to customize the export and make it look cleaner it would be very helpful thank you2.1KViews0likes2Comments
