Has anyone else run into a situation where Elasticube builds succeed, but only return a partial set of records? I'm finding that it is only happening in our largest Redshift table. There are 1.5 million records...the build is shown as successful but ...
I am having issues with setting up Data Security - The goal is to create a hierarchy in which each employee can see only his/her data alone. I have set up the ElastiCube to also join manager emails so a manager can see his/her whole team. Upon showin...
This is my first time using Sisense, I was asked as part of the interview process to get myself familiar with Sisense platform so I signed up for a free trial to use Sisense. I'm wondering if I can connect MySQL to Sisense on MacOS? Because I saw tha...
Hi I need help with this error I receive after I have created a custom column and I want to use the same columns to do calculation on. Example of the custom column: Select (Case When [NPS_rating_Answer_Value]>=9 thenCount([Result_ID]) Else Null END) ...
hello I am using dynamic buckets to show number of customers in each spend range for the selected time period, I am using the dynamic bucket plugin. My issue is the highest bucket range i.e. 800 is wrong as the maximum spend I have in my view is 741 ...
I need to create a custom column on one of my tables. This column will be a LOOKUP from another table. However, if the current row has no match in the remote table, I want to use the value from the current match column. Here is what I am attempting t...
Hi, I need to create a healthcare pivot table with three columns. Provider Name, number of claims by provider, and earliest date of encounter for each provider. Something like above.. However this being a pivot table is it possible to achieve the las...
Hello all, I want to know whether there's a possible alternate for Lag and Lead functions in Sisense. I want to design a table where the row values are to be calculated based on the previous row values. The example of the model I want create is attac...
Problem: One of our teams uses Sunday as the calendar week start day, which is different than our other teams that use Monday as the week start day. I have created a special column in a date dimensional table where the date reflects Sunday and am usi...
Hello, I am trying to create a column that links to our gift pages on our crm. The problem is when it goes to the url, it has the donor data at the top from the last viewed donor, instead of the donor data of the gift. Our solution is first to open t...
Is there an easy way to pull some of the user data that's stored in Sisense into an elasticube? Specifically what I'm trying to do is pull a table of user IDs and names for all of our users with Sisense accounts and use this data in a dashboard. I ca...
Sisense documentation lists Data Dictionary as one of the product features. Documentation for that is shown here: Creating Data Dictionaries. However, this feature only supports the creation of table and column description information. This is helpfu...
Hi all I have a dataset containing numeric values for audit scores, a date field, and an auditee field. I can create a line chart with the score over time, however the data is "gappy" because the frequency of these audits is inconsistent. This presen...
My cubes can take 15-20 minutes during the initializing and finalizing steps when building. This is out of the 25-30 minutes it takes to do the entire build - so over 50% of our build time is coming from these steps. Does anyone have an idea what cou...
Hi! I have one metric here that is using the PREV() function to get data from 4 weeks ago. Hence, the date rows go all the way to 4 weeks in the future here. I have included a widget filter called current_date_flag, which is basically a row in my EC ...
