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.6KViews0likes3Comments
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
export 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.1KViews0likes5CommentsFilter 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.2KViews0likes3Comments
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.7KViews0likes1Comment
Customizing smart label plugin
Hello, I am using the smart label widget to show the selected current year of the data. It works fine when there are several years available. But when I use the background filter to allow only one year, then the widget is showing "All" instead of the year. Is it possible to manipulate the smart label widget that it shows always the year? Thank you1.7KViews0likes1CommentSum 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
The Houdini Report
We are finally releasing our Analytics Suite to our customers and I would like to create a Dashboard/Report to specifically show items that have "Disappeared" from weekly sales. If an item was consistently sold for 3 weeks or more and then 3 weeks goes by WITHOUT it being sold, the system would flag this item and display it, display its weekly average (for when it was sold) and how much "Lost sales" this equates to in revenue. Items, quantity sold, and a line_extension (invoiced amount total per item) are the three metrics I believe I would need to interact with. These are the column headers (although not their actual names just to more easily understand this project) I'm sure this needs a bit more detail from me but I figured I could maybe get the ball rolling. Thanks in advance for your insight and help!1.2KViews0likes0CommentsScheduling 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.2KViews0likes0CommentsPASTWEEK() & 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.1KViews0likes0Comments
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.