Transposing Pivot Table
Current format ^ The format I want to achieve ^ Hi everyone, I am currently working on a project and the client wants the values to be displayed in rows, grouped by Country (as seen in the image above). However, the default in Sisense is to put the values in columns. Switching the rows and columns also does not seem to resolve this issue. I've attached the current format of the table I have in Sisense, as well as the desired format I am going for. Essentially, I want to recreate the format of the Tableau table in Sisense 🙂 Thank you and please let me know if anything was unclear.Solved7.1KViews0likes6Comments
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.8KViews0likes6CommentsWhat are your preferred ways for making a lot of details available to your users?
We have a lot of very detailed information available for our users, and there's often a need to drill into these details from the dashboard. There's variety of techniques available for this; we usually use the Jump To Dashboard feature to link to more detailed dashboards or have set up drill hierarchies within a pivot but these each have their own limits as well. What have you found to be good ways to allow users to go into lots of very specific detail while still giving useful overviews?4.7KViews1like5Comments
Parsing a string
Hello! I am fairly new to Sisense and hope to get some insights on how best to solve a string parsing problem. The following are some examples of long strings/array that I need to parse and separate out the values for further analysis. The challenge is that not every string has the same length and I almost feel like I need some sort of programming looping structure to loop through each element of the array and extract individual values from it. In the examples below, I need to extract values that are within [ and ]. Any thoughts and ideas are much appreciated. Thank you! [1,"0"],[16,"8938473"],[17,"0"],[21,"*"] [2,"40000"],[16,"35000"] [1,"0"],[14,"1554025"],[15,"0"],[20,"*"],[40,"0"] [1,"0.00"],[12,"0.00"],[13,"0.00"],[21,"0.00"],[41,"0.00"]Solved4.1KViews0likes2Comments
nulls 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
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
Code example using Blox dropdown to select dashboards
I have been searching the web for a couple of days with no success. I need a code example using Blox dropdown to select dashboards. I have 10 regional locations, each will have a set of dashboards. I am able to create and use 10 buttons on a dashboard but it would be cleaner and better if I can use a dropdown to open the url and go to the selected regional dashboard. I am thinking I need to use an Action Set but have not figured out how to make it work with a Blox dropdown or a radio button. I have found dropdown filter examples but have not been able to translate that to calling the action goto url.Solved3.5KViews0likes3CommentsInclude 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.9KViews1like5Comments
