Percentage Increase on Bar
Hello All, I am replicating bar and column charts in Sisense from Tableau, and cannot find a way to show the percentage increase/decrease from the previous bar. Tableau has a function, where you could show the percentage increase/decrease. Please let me know if there is any function to show percentage increase Thank you!5.4KViews1like3Comments
Setting the Borders for Individual Widgets in the Dashboard
Hi All, Is there any way to set the borders for particular individual widgets in the Dashboard? I have found the Dashboard script where it will apply the the style settings for all the widgets in it. But would like to know to set the style settings for an individual widget in the Dashboard?Solved4.6KViews0likes3Comments
Need to change the filter colors when something is selected
Hi All, I have several filters in my dashboard, i want to change the colors when something is selected in the filters to distinguish between selected and unselected filters . currently i am using $('.uc-tag').css('background-color','#006ecf'); $('.uc-tag').css('color','white'); as filter colors and backgroundSolved3.2KViews0likes7Comments
Hide column until drilled into
I want to hide a column until the user drills into the chart. Example of what it currently looks like below: I would like to hide the "Videos in Module" until the user clicks the drill into. So it would look like this initially. Then when a user clicks drill into it would look like this: "Videos in modules" are not always the same count throughout organizations so I am unable to just display the min or max video count.Solved3.1KViews0likes5Comments
Top and Bottom Performer by calculating percentage
Hello, I need to create report for top and bottom performers for a parameter. It should be based on overall percentage and not by Ranking. How can I achieve the same using Sisense? For example: In below table, top 30% performers are highlighted in Red and bottom 30% are in Green. Days in Date FullName X (Hours) 2/28/22 AK 4.95 AL 5.27 AJ 6.71 BL 5.12 DS 5.01 IH 4.03 KL 4.74 PU 4.91 SN 4.37 SM 5.56 TS 5.45 UN 5.112.8KViews0likes2Comments
Number per year where a different date is within a year of the first
I was creating a dashboard for someone, and one of the widgets was a column chart that plotted out the number of people per year of hire. So, x-axis is the year of hire from left-to-right, then each column is the number of people who were hired that year. So far so good. I was asked if we could filter the chart so it only shows people who also had a different date occur within a year of them being hired. In other words: can we focus on just the new hires? Not the new hires right now, but people who were new hires at the time that this second date occurred. Let's call the first date (that I'm plotting by) "Hire Date" and the second date (that I want to filter by) "Opened Date". As far as the data is structured, these are on different tables and can be a one-to-many situation (i.e. a given person only has one hire date but may be associated with multiple records and thus have multiple Opened Dates). At first I thought this would be relatively simple. I added a new measure and used the following formula: DDiff([Days in Opened Date],[Days in Hire Date]). Then I thought "all I need to do is filter for the ones that are 365 or less". This didn't work. Let's say a given year originally showed 10 people, and out of those, 5 were a "new hire" at the time they had an Opened Date (i.e. the other 5 people had Opened Dates that were after their year of hire). However, when I added my formula and then applied the filter, the amount would change to something much higher, like 47. When I change the view to something else like Table, it becomes clear that the filter is somehow duplicating rows when its present, but I don't understand why. If i deactivate/remove the filter then the duplicate rows go away, but then obviously I'm not getting the filtering that I need. I also tried using a conditional formula. Something like: IF( DDiff([Days in Opened Date],[Days in Hire Date]) < 366, 1, 0). My hope was that, if this worked, then I could simply filter for the records that resolved to "1", and I could get proper counts by summing all the 1's. Unfortunately I keep on getting an inscrutable error message that says "Error in function definition (IF) in the 'condition': Expecting parameter of type 'Boolean' that consists of expression types 'Member Expression'. Instead found 'Dimension Expression'." This doesn't make sense to me, since why would "DDiff([Days in Opened Date],[Days in Hire Date]) < 366" NOT be a boolean? "DDiff([Days in Opened Date],[Days in Hire Date])" itself will always resolve to some sort of number, so we should always have something to compare to "366", and thus we should always be able to respond TRUE or FALSE, right? In any case, does anyone have a good way of achieving the sort of filtering I need to do? PLEASE NOTE: I do not have access to our eCube configuration, so any solutions that involve modifying the eCube or creating any new columns in the eCube are non-starters for me. Thanks!Solved2.7KViews0likes3CommentsTabber 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.5KViews0likes5Commentsproblem in downloading pivot widget in to pdf
Hi Community We have an issue in downloading pivot widget to pdf. In sisense windows environment we have Pivot widgets in these widgets some columns are hidden we made this hide in script but when we download a particular widget to pdf it is showing the hidden columns also in the pdf so any one any solution for avoiding hidden columns in pdf please let me know.....2.4KViews0likes3Commentslooking to create a custom Dashboard filter from a result from another widget (Live Data Model)
Dear Sisense Community, I am looking to see if there is a way through scripting that I can use the values from a Pivot table (one column of text data) to create a custom (Advanced) filter for the Dashboard. By the way, although I'm capable with the Sisense interface (Dashboards, Widgets, formulas, etc.), I am not a coder whatsoever. Please see the link for details: https://vimeo.com/909839916?share=copy Thank you in advance!Solved2.2KViews0likes4Comments