Reordering the X axis for a Line Chart
I created a line chart and the x-axis is ordered alphabetically, which is not what I want. How am I able to order it in a way that I want?
Forum Posts
Is there a way to iterate or break an entire widget by a dimension field?
USE CASE: I have a dimension field - let's call it state that has 50 possible values but these change based on the data range selected. I'd like a bar chart with 2 columns # of Yes's and # of No's to break by each state into its own widget instead of...
Horizontal scroll on Table Widget
Hello, I am working with a client's dashboard and trying to get a horizontal scroll bar to appear on a table widget. I have tried this code:dashboard.on('widgetready', (el, args) => { $('.p-mid', 'widget[widgetid=' + args.widget.oid + ']').scroll((sc...
User/Group table - Data Security
Is there a way to grab a table of all the users per groups that have been set-up in Data Security?
Customization of YTD
Hello everyone,I have a question on how to customize the YTD that is available when constructing a widget. I thought this was possible but now I'm not so sure. How would I go about getting the sum of the YTD between April-March versus Jan-Dec?
Pass Dashboard Filter value to Data Model as a Parameter
Hi Team,I was wondering if there is way to pass one dashboard filter value ( report id ) to the SQL query in the Data Model.We have a scenario, when a user loads the dashboard one of the dashboard filters gets dynamically updated while in embedded mo...
Cascading filters for independent dimensions
Hello Team,We have a use case for dependent filters where we want to control(lock/unlock) each filter unlike existing dependent filters functionality where filters are grouped.We're using a live connection. For eg, If we have Product, Geography & Tim...
Resolved! Wrong SSO User with Cloud Sisense & Iframed Dashboards
I am trying to find the best solution for a problem at a new job. We use Sisense Cloud (linux) and use iframes to display dashboards from it on a Wordpress site.Sisense is under one subdomain on our main domain, Wordpress on another.Our PCs are share...
Drilling into a new style widget
Does anyone know of a way to drill into one style of widget, and turn the drill to widget into a new style? For example, drilling into a bar of a bar graph and displaying a pivot table of names from a list. Let me know if you have any ideas. Thanks!
Dynamic ElasticCubes config for many\multiple dashboards
Is it possible to configure Dynamic ElasticCubes for several dashboards at once? We currently have a very long, repetitive config file and it is getting difficult to maintain. For example, if we could change this to allow a list of dashboard names or...
changing start of week for last week filter in Live Data environment
Hi All,Anyone have any ideas in how to get around the Monday through Sunday grouping for weeks in the Live Data model (non-Elasticube)?Also would be curious if we could identify Day of the week through scripting as well.Thank you!
Count two dates
I have 3 columns DueDate, FinishedDate, ID What i want a metric of, is for a given time period, what is the ratio of finished date / due datebasically, in september, you had 40 records with a duedate in september, but only finished 20... the x axis d...
Counting by the Day of the Week in a Pivot Table
Hello:I am attempting to count incidents by the day of the week across a month. I am hoping for: MON TUE WED THU FRI SAT SUNShift A 3 6 2 5 11 8 7Shift B 2 8 x x x x xShift C and so forth.Here is what I have so far, but I can't figure out how to tell...
Flowiseai + Sisense = RAG from a dashboard (all widgets chart data value of a dashboard)
In the previous post, I showed how to use the Sisense Rest-API to get the data values of a specific widget and RAG them through the LLM. (ref https://community.sisense.com/t5/help-and-how-to/flowiseai-sisense-rag-from-widget-data-values/m-p/21591#M25...
