Dimension filter on id not working correctly
I have a dashboard with a dimension filter. The dimension filter table is a list of organizations and the products associated with those organizations. I have a widget displaying organization and product buy counts. When I filter on a product ID that is only associated with one organization it is affecting the counts of organizations that are not link to that product ID. If I filter for product ID on the fact table where I pull the buy counts from it works fine, but I want to use the dimension table so that it is filtered other places in the dashboard as well. I have verified this product is only linked to one organization. Why would a dimension table filter affect organizations that do not have that product ID linked to them?Solved2.9KViews0likes5CommentsCan use use Switchable Dimensions for Line and Area Charts
I am trying to use switchable dimensions pluggin in Sisense for a line chart and area chart using a date dimensional table where my dates are in numerical values for conventionality. I am trying to use this pluggin to go from monthly, quarterly, and yearly. Can this work?Solved1.7KViews0likes3Comments
Using Rankdesc to create a custom Column
Hi, I am a sisense newbie. I am trying to create a custom column in the data model to rank latest week and other weeks from latest to oldest. I am using a live model connected to a snowflake database. The data is such that once a week its refreshed and customer purchases for the range of that week are entered against a single day. Whenever I try to save this formula, I am getting an error. Can someone help me fix this formula please. Formula: RANKDESC("purchase date") Error: Parsing failed: SQL compilation error: Unknown function RANKDESCSolved2KViews1like4CommentsImport Active Directory Data (Staff Names, Photos, etc) on Sisense Cloud
Can anyone direct me to a guide on what I need to do to import Active Directory data within Sisense Cloud? The only documentation I can find is here: https://docs.sisense.com/main/SisenseLinux/connecting-to-microsoft-active-directory.htm However that talks about downloading and installing items which is obviously not an option on Sisense Cloud. Has anyone found any information on this? Thanks in advance!! Gannon1.6KViews2likes3Comments
Time periods by specific day of month (e.g. first Friday, Second Wednesday)
Like many businesses we bill clients monthly. We bill 25% of our clients split up between the first, second, third, and fourth Friday of the month. I could see a similar use case for periodic customer review meetings instead of reviewing by standard month/calendar. Looking for a data model or filter option to make it easy to select data based on this break down instead of having a user manually select dates on the calendar from the day after the last billing cycle to the last day of the current billing cycle. having the break down in the data model would also enable reporting of periods over time instead of reporting on actual calendars, reporting on the billing calendar. Is there a best practice to solve this problem?1.1KViews0likes2CommentsCustomize Embedded Dashboard Layout
We have some dashboards embedded in our site. We would like to have the ability for the end user to customize their dashboard layout if they choose to do so by dragging and dropping widgets. Is it possible for end users/viewers to have the ability to move a widget within a dashboard but not alter the widget level filtering that can be done by designers or owners of the dashboard? thanks, Zach2KViews1like3CommentsSisense Implement RLS in Bigquery to access data in sisense
Hi Currently I have an created dashboard which takes data from Bigquery. I am planning to add RLS(row-level-security) policies to Bigquery tables so that data belonged to particular user/tenant can only be shown. How can I update my dashboard or data-model to support these changesSolved1.5KViews0likes2CommentsSort and Filter multiple custom Values (formulas)
I want to create a bar chart. Under Categories would be "Common Term", which is dropdown field that has close to 300 distinct options a user can select. The size of each bar would be the number of Matters that contain each Common Term. The problem is that there's too many Common Terms, and my leadership has requested if there's a way to group similar terms. I came up with around ~25 groupings that we could 'bucket' the individual Common Terms into. Basically, instead of having 300 bars, we'd go down to just 25 bars. The matter counts for each should still total everything up appropriately (e.g. if Common Term A was 15 and Common Term B also was 15, then the combined grouping for those two would show 30). I've already figured out how to use Measured Values to accomplish this in the UI. Each grouping is a formula in the Values section of the widget that uses something like this: (count([Matters]),[Common Term]) Whereupon I'd click on the [Common Term] item, select "Edit Filter", and then select the individual Common Terms I want to be counted for this particular grouping. Since I had 25 particular groups I wanted to create, I now have 25 items under the Values section of the widget. This seemed to accomplish what I want. However, there's a few downsides to this method. First off, it seems like measured values always show in the view, regardless of their actual total (even if they're zero). Second, there's no way to automatically sort the measured values based on their totals. Third, there's no way to filter the groupings by Top N (as in: out of the 25 groupings, only show me the Top 5 groupings by number of matters). Fourth, there's no way drill into a particular grouping to see its underlying members. Lastly, this method is labor intensive to set up, difficult to modify or maintain, and is not scalable (imagine trying to apply a similar method to a field with over a thousand distinct values, with hundreds of potential groupings). At this point I realize the best solution would be to add a new column to the eCube for the groupings I need. Then this would just show as a new field in Sisense and I could simply put it in the "Category" section which would let me accomplish the various things I'm trying to do (sort, filter, etc). However, for various reasons, this is not a good option for me (i.e. modifying the eCube). We could potentially do this for this one specific situation (the Common Terms) but it would be difficult/tedious to maintain or make changes to the groupings. Plus, I'd like a solution that's more flexible and can be applied in a more ad-hoc or arbitrary manner, similar to how you can select multiple items in a pivot table in Excel and select "Group" to create temporary bespoke groupings (i.e. they only exist in that pivot table and not in the original data). Is this possible at all, using vanilla Sisense? If not, is there perhaps a plugin we can install that would allow us to achieve this sort of grouping? Or do I just need to bite the bullet and accept that this is really only possible through modifying the eCube?2.2KViews0likes5Comments
