Filter widgets (show/hide)
I would like to implement a filter on the dashboard that enables users to filter widgets. How can I achieve this using JavaScript without relying on plugins? For example: Filter Name: Widget Filter Filter Values: A, B, C Widgets: A', B', C' When the value "A" is selected, only widget "A'" should be displayed, while hiding the rest of the widgets.2.1KViews0likes3Commentsexport only the visible widgets to PDF using the Tabber plugin
I am building a dashboard using the Tabber plugin. However, during the export process to pdf, all widgets are included, even those hidden by Tabber. Is there a way to address this issue without relying on other plugins? I am specifically looking for a script-based solution. Thanks,Solved2.1KViews0likes5Comments
Sorting Bug in Pivot Table
I'm getting an odd bug in Fusion Pivot tables where columns will not sort (except first column which /can/ sort). The first column (a list of the names of various schools) will sort just fine ASC and DESC. For any other column sorting has no effect. Anyone else have this bug? Is there a setting I've changed which is causing this? Other pivot tables in my instance work just fine.1.7KViews0likes1CommentPASTWEEK() & PASTYEAR() formulas in widget
Hello, I am having an issue creating a report looking at the week as defined by my dashboard filter versus the previous week as well as the equivalent week in the year before. Basically, I get my 'original' week very easily. We use Last week in the dashboad filter on the TransactionDate for it to report on the latest (most current) completed week. I saved that as a 'TW Units' which basically comes just down to 'sum([Quantity])', likely the easiest formular available in Sisense. Using the formula PASTWEEK(TW Units) I am getting the results for the previous week and they match what I pull via SQL from the raw data as well. In my mind I should just need to use PASTYEAR(TW Units) and should be getting the results from the preceding year for the week I am actually looking at. Instead I am getting returned the same results of the week I am looking at for the current year. Are those 2 formulas different somehow? There is noting in my elasticube that treats the dates any different.1.1KViews0likes0CommentsSum of last 3 months data in Pivot
Hi, We need to fetch some accounts that have not made any purchases in the last 3 months. In SSMS I use below code, but this seems to be not working correctly when I use it in the cube (as table query). SUM(Amount) OVER (order by Date ROWS BETWEEN 3 PRECEDING AND current row) = 0 Would appreciate any inputs on how to use this in the cube. Thank you!1.6KViews0likes2Comments
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.7KViews0likes3Comments
Scheduling system
I am looking for a program that can integrate both google sheets and Salesforce together. My main objective is to find an Artificial Intelligence tool that can make a schedule for a film studio based on the info we have provided from the Google sheets. This info will be basic info like what studio that they prefer, which host they prefer, and what green screen they have done. I am hoping that the AI can do those steps itself from the data provided from past studio visits. From there would it be possibly to enter all that data into our Salesforce. I see that this program comes with a lot of widgets, but I’m not sure if it can do those activists. This a very brief description of what I am looking to do, but based on what I have provided do you think there is any chance that this program could do that? Any info will be apricated. Thanks,1.2KViews0likes0CommentsConcurrent users loggin
Hi everyone! Is there in Sisense a possibility to limit viewer logging in from one account, like a "concurrent" logging? So, if the user logs in with his username, then this username logs out of Sisense on all other devices where the login was previously performed.816Views0likes0CommentsExport 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.2KViews0likes2CommentsCustom Blox Filter for measure
Hello, I was wondering if there is a way to create a measure filter in my case customer spend filter, where the user can define a number and the views are filtered by it? so basically I want to filter my view for customers who spent more than XYZ number. I want to give my users the ability to input there number932Views0likes0Comments
Filter widgets (show/hide)
I would like to implement a filter on the dashboard that enables users to filter widgets. How can I achieve this using JavaScript without relying on plugins? For example: Filter Name: Widget Filter Filter Values: A, B, C Widgets: A', B', C' When the value "A" is selected, only widget "A'" should be displayed, while hiding the rest of the widgets.