Konrad
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Modify role permissions on a user duplicated dashboard
Hi sbatlanki , Out of the box it is not possible to forbid specific user from being able to modify the dashboards that they own. If user role in Sisense is a designer or above they will be able to duplicate the dashboards and take control over that. In this case to limit that user's privileges you can downgrade that user to viewer in admin tab in users settings. Alternatively you can also modify the permissions that particular user roles have in your Sisense. However this will apply to all users at particular role and to all their Sisense components of specific type. You can read more about it in following article: https://docs.sisense.com/main/SisenseLinux/customizing-user-roles.htm Always here to help, Konrad from QBeeQ konrad.wroblewski@qbeeq.io QBeeQ - Gold Implementation and Development Partner www.qbeeq.io1.8KViews1like0CommentsRe: Dynamic filter with input parameter
Hi TwieN , It is not possible to add parameter variable into Sisense filter directly. However with our plugin you can achieve desired functionality in different way. It depends from your naming convention and data structure, but the logic of formula would look like below: sum([OrderID], case when [Min Days Ago] <= @Days Ago then [Total Sales] else 0 end) Order ID would be unique key here for each single transaction. Next in "case" statement it can be Min,Max,Avg, etc. from Days Ago, it doesn't really matter it will just return numerical output for the comparison with parameter variable. Let us know if you still have any questions. We'd also like to encourage you to reach out to us directly if you'll have any questions or issues related to our plugins. -- Konrad Wróblewski QBeeQ2.7KViews2likes0CommentsRe: In Sisense, how can you "group by" in ranges?
Hi leo82 , I would do this on Elasticube level. It depends how your data structure looks like and what are the table names, but you can try implementing following logic: First I would create custom table, let's call it team_size_count. It will calculate the number of users in each group with following query: select a.[Team_id], case when count(a.[uesr_ID]) <= 5 then '0-5 member per team' when count(a.[user_ID]) > 5 and count(a.[user_ID]) <= 8 then '6-8 member per team' when count(a.[user_ID]) > 8 and count(a.[user_ID]) <= 12 then '9-12 member per team' end as Team_Size from [Users] a group by a.[Team_id] Then you can create a team_size custom column on Teams table with following query: lookup([Team_Size],[Team_Size_Count],[id],[team_id]) In next step you can achieve desired view by using this column in pivot table widget in rows section and as value simply count the number of teams -- Konrad Wróblewski QBeeQ2.5KViews1like0CommentsRe: Sharing folder access across Dashboard Designers
Hi mattmca, This is not possible out of the box to pass ownership over the folder or create / move dashboards to someone's folder. However you can have workarounds for that. If you'd like to just move existing dashboards you'll have to pass the ownership of dashboards to folder owner, who then can move them and pass the ownership back. If your designers would just need to create new dashboards, then folder owner can create a dashboard and pass the ownership over that dashboard to other user. Than that user will be able to manage this dashboard within that folder. Also if user further duplicate dashboard over which has ownership the copy will land in the same folder even if folder is owned by someone else. So in this case for each of your designers you can create an empty dashboard which they own and will duplicate it and rename each time they would like to create a new dashboard. QBeeQ also developed Dashboard Folder Management plugin which among other things would allow you to pass ownership over entire folder between users. Feel free to reach out to us directly if you would be interested in more details. -- Konrad Wróblewski QBeeQ4.5KViews3likes1Comment