cw_meg01
Data Storage
Joined 4 years ago
User Profile
User Widgets
Contributions
Swap columns in pivot2
Hi everyone. I'm trying to find a way to order the columns of a pivot in ascending order, based on the number included in the description of the header. Below you'll find a screenshot with the content of the headers. The current order is "+150", "1-29", "120-149", "30-59", "60-89" and "90-119"; the last category ("90-119") is missing in the screenshot, but you get the idea. The correct order should be "1-29", "30-59", "60-89", "90-119", "120-149" and "+150". One thing: notice the "+" in front of the "150" in the "+150" category. I'm open to any suggestions (e.g., doing a dom modification when the widget is ready.... or using any method from the Pivot2 API documentation), but, in any case, I would like to avoid the approach described in the following post https://support.sisense.com/kb/en/article/pivot2-table-row-custom-sort Thanks in advance.2.1KViews0likes2CommentsRe: How to pass Sisense user id to the SQL Queries in Live Model
Try prism.user for information related to the user (id, group, etc.). The id is also available when the widget is ready (widget.userId). widget.on('ready', function(widget){ var userInfo1 = prism.user; // feel free to add the name of the attribute you are looking for once you identify it var userInfo2 = widget.userId; });2.5KViews0likes1CommentDashboard layout change
Hi, I'm trying to change the layout of a dashboard with two columns so I can have the following structure: - the widgets in the two first rows span across the entire dashboard width; the first row has the title while the second row is being populated by filters widgets (wiser); - the rest of the dashboard contains the graph widgets divided into two columns. The image below show what I am getting by using the drag and drop UI of Sisense, in a dashboard with two columns. As you can see, the text box for the title falls into one column, instead of going across the whole dash. Note: The reference image below only has the title row; I'm looking to get this row to go across the entire dash, and also a second row (composed by filter widgets). Reference image (taken from the user szimmermann in this post for reference purposes)2.4KViews0likes1Comment