I am trying to figure out is there a way to grant View only Access on the Elasticubes to Designers/Contributor Role so that they can view the Model while developing the reports without modifying the underlying model.I tried to set via RestAPI but I a...
I am using Generic JDBC connector to import data from our MongoDB.For certain requirements, I want to only import data from the past 7 days wrt the current date using the timestamp field present in the data.I have tried a bunch of regular SQL functio...
Hi,I am trying to create two boolean Custom Columns in my DimDate table to flag data in the current week, and data in the same week, previous year. This type of flag is easy to create for a monthly resolution, but weeks are tricky because they can sp...
Hi All,I have the following use case:I want to visualize the overall stock level of 2 different products over time. The source for the stock levels is a FACT table containing the log data of the stock movements. The FACT table is connected to a date ...
Hello all, I have what I hope is a simple question. We have a database that can be boiled down to the image below. Each entry has a date (YYYYMM) and whatever the monthly member count is for that entry (Members). We want an average member count of Q4...
Im looking to use the answer from one calculation in another calculation on a separate widget with different filter set up. This is my first calculation, it counts how many sales we have prior to drafting for each model and divides by the total numbe...
Hi Sisense Community!! Please reference the attached workbook that I drafted in Excel. I am trying to draft a daily view by week, of each employee's time worked. This screenshot shows an example of actual hours worked by day by employee. I am trying ...
Can you give me some tips on how to connect an elasticube to a PI Historian server? Is there an add on for PI Historian that I need? We want to combine data from an Oracle database with PI Historian data to show both in a dashboard.
Hi,I have a use case were I have this tableI want to plot in a chart in continues dates (i.e. from the minimum date of launch_time to the current date).e.g. 1/1/20 - 1/12/22 and count the number of instances that were alive in a certain date based on...
We are using enterprise version of Sisense using another UserName , when we connect directly from Sisense source connection MsSQLserver we are able to successfully login Azure cloud SQL(this is the vendor cloud- where the Sisense IP is whitelisted in...
Question for y'all: How do you maintain consistent calculations of key metrics? Custom columns in the data model won't work b/c I need aggregations that can be easily filtered (e.g. can't add activation % to my base table b/c my stakeholders want to ...
We have a lot of very detailed information available for our users, and there's often a need to drill into these details from the dashboard.There's variety of techniques available for this; we usually use the Jump To Dashboard feature to link to more...
I was looking for a way to analyse EC Builds in an easy way to identify where potential bottlenecks within the buildprocess could be. I have created a python script which exports EC build logs (can only export latest build logs) to JSON and converts ...
What is the best approach in Sisense for sharing benchmarking information while maintaining customer confidentiality? When I was a Sisense customer a key differentiator for us was showing our customers how their performance metrics compared to others...
