tomlinton
Sisense Employee
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Formula for counting the views per user
Hi! Have you looked at the pre-built "Usage - Dashboards" dashboard provided by Sisense? This has a few charts that already show dashboard viewers. In short, to get the views of a dashboard by user, you would need that information from the "FactActions" table in the Usage Analytics Model. DUPCOUNT does work on non-numeric fields. So if I wanted to see the number of views a dashboard got per user, I might bring in the following information: username from DimUsers, dashboardID from FactActions, and DUPCOUNT(username). This would show me the views per dashboard by user. Reasons you may get an "unrealistic" number is that the FactActions table is capturing a lot of actions. So if I am viewing a dashboard, I might select different filters which is causing the dashboard to reload. All of these events might be viewed as me viewing the dashboard, but in reality, I was just viewing it once and interacting with it. Play around with filters from FactActions to see if there are any ActionTypes that you can filter out to get the number down. Hope this helps!1.4KViews0likes0CommentsRe: bringing carousel for images in Blox .
Hi! First, your data needs to look like the table below. Once it's in that format, it's as simple as creating an image block with the url set as {panel:ImageURL} and setting showCarousel: true. CategoryName ImageURL bears https://www.mysite.com/images/bears beats https://www.mysite.com/images/beats Battlestar Galactica https://www.mysite.com/images/battlestargalactica1.9KViews0likes0CommentsRe: Dashboard Custom advanced Filter
Hi - there is no "getDate()" functionality that I am aware of to be used here. Have you explored the "Time Frame" filter where you can set offsets? See the screenshot attached. Based on the date level you select, it will allow you to offset based on today's date. In my example, I am selecting yesterday. Would that work for you? The only downside is that this would only work if you are trying to do a rolling X number of days. There is definitely a way to set the anchor date like you have done and programmatically change the "to" date with a dashboard script. You would basically grab the filters on dashboard initialization and set the "to" date. Here is some code that I used in the dashboard script: dashboard.on('initialized',function(s,e) { let newFilter = e.dashboard.filters.item(0); let today = new Date() let todayParsed = parsedDate = today.toISOString().substr(0,10) newFilter.jaql.filter.to = todayParsed e.dashboard.filters.update(newFilter,{refresh: true, save: true}) });3.1KViews0likes0CommentsRe: Responsive PieChart
SisenseJS will draw into the HTML container its given. Looking at your picture, the iPhone XR resolution is 896px wide. I'm guessing your div spans the whole screen which is why Sisense is drawing that large. You can test this by setting a fixed width to see how the chart changes. Once you see the change, I would then fix the width to be dynamic to the size you want.2KViews0likes0CommentsRe: NLQ on Embedding
Hi Adityak! Yes you can absolutely access the simply ask functionality within an embedded application. To do so depends on the type of embedding. Assuming you have enabled simply ask on a dashboard already.... iFrame: To have it available on the iframe, you need to ensure you include the toolbar when generating your iframe. The simply ask feature will be exactly where it is on a normal Sisense dashboard. SisenseJS: Check out this instructional on how to embed the simply ask functionality with SisenseJS. For a working example, check out this website. It has both types of simply ask embedded within it. If you click on the pencil icon it will take you to the iframe embed. Below is a picture of it.5.6KViews1like0Comments