satyamarigold
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Apply preset filters to an Embedded Dashboard using Sisense Js
We are embedding a Pivot Table dashboard using Sisense.js and the pivot table needs to be filtered specific to the user that's viewing the data. We did figure out how to filter the table using a jaql query, but that Jaql only seems to work with an iFrame and not a sisense.js embed.1.5KViews1like6CommentsRe: How to model changing Membership Types when calculating Historical Data
Thank you! This helped solve that issue though I have a separate related issue now. Suppose for the example above - the user John is of membershipType "Alpha" till March 23 and "Beta" & "Gamma" afterwards, documentation for John should count towards both when breaking down by membership. But I don't want to create multiple rows in the dimension table, with documentation table linking to both. One solution I can think of is to create a second duplicate row in the documentation table (linking it to the second membership) but I want to avoid such an approach if possible.2.3KViews0likes0CommentsHow to model changing Membership Types when calculating Historical Data
I have a user table with a property MembershipType. I also have a second table with documentations that our staff are filling for each user over time The common key here is "username". I need to create a breakdown of # of documents filled per membership type. The problem comes when trying to get sisense and it's Dim Dates Table to pick start dates and end dates for memberships. Eg: if a user John is of membershipType "Alpha" till March 23 and "Beta" afterwards, documentation for John should count towards Alpha before March 23 and Beta after March 23.Solved2.3KViews0likes2Comments