PASTWEEK() & PASTYEAR() formulas in widget
Hello, I am having an issue creating a report looking at the week as defined by my dashboard filter versus the previous week as well as the equivalent week in the year before. Basically, I get my 'original' week very easily. We use Last week in the dashboad filter on the TransactionDate for it to report on the latest (most current) completed week. I saved that as a 'TW Units' which basically comes just down to 'sum([Quantity])', likely the easiest formular available in Sisense. Using the formula PASTWEEK(TW Units) I am getting the results for the previous week and they match what I pull via SQL from the raw data as well. In my mind I should just need to use PASTYEAR(TW Units) and should be getting the results from the preceding year for the week I am actually looking at. Instead I am getting returned the same results of the week I am looking at for the current year. Are those 2 formulas different somehow? There is noting in my elasticube that treats the dates any different.1.1KViews0likes0CommentsConcurrent users loggin
Hi everyone! Is there in Sisense a possibility to limit viewer logging in from one account, like a "concurrent" logging? So, if the user logs in with his username, then this username logs out of Sisense on all other devices where the login was previously performed.799Views0likes0Comments
Export to PDF Customise
Hello, I would like to know if there are any best practice on creating a dashboard which will give me a clean pdf export currently, my basic charts are distorted and divided into 4 separate pages blox widgets are of uneven sizes Widget titles are exported even though I have hidden them on the dashboard level I am not using any tabbers here if there is a script I can use to customize the export and make it look cleaner it would be very helpful thank you2.1KViews0likes2Comments
Pie Chart with Multiple Values
I have a very specific use case to build a pie chart with multiple value labels. A rough example is below, but essentially the use case is to have a pie chart show the % based off one value, but then display a second metric below that. Any thoughts or suggestions on how to pursue this? I know a stacked bar should bring a similar analytical value to the company, but for this use case, I can't get around the need for this formatting.1.7KViews0likes1CommentCustom Blox Filter for measure
Hello, I was wondering if there is a way to create a measure filter in my case customer spend filter, where the user can define a number and the views are filtered by it? so basically I want to filter my view for customers who spent more than XYZ number. I want to give my users the ability to input there number911Views0likes0Comments
Update Dashboard Date filter from selected Date to Last 365 days
Hi Team, We have requirement where we need to update dashboard date filter dynamically from selected date to Last 365 days from the date selected. We have a working code for windows, we are looking the same for Linux, attaching the windows code below, please help in fixing. var TABLE = "tablename"; var COLUMN = "columnname"; var COUNT = 365; var max = null; dashboard.on("widgetbeforequery", function(d, a) { var item = a.query.metadata.find(function(i) { return i.panel === "scope" && $$get(i, "jaql.table") === TABLE && $$get(i, "jaql.column") === COLUMN }); var title = $$get(item, "jaql.title"); //debugger; if (title == "Date") { var selopt, unselopt, selrng; try { selopt = $$get(item,"jaql.filter.members"); } catch (e) { } try { unselopt = $$get(item,"jaql.filter.filter.exclude.members"); } catch (e) { } try { selrng = item.jaql.filter.to; } catch(e) { } var fItems=[], dItems=[]; if(selopt) { for(i=0;i<selopt.length;i++) { fItems.push(moment(selopt[i]).toISOString().slice(0,10)); } } if(unselopt) { for(i=0;i<unselopt.length;i++) { dItems.push(moment(unselopt[i]).toISOString().slice(0,10)); } } if(dItems.length>0) { for(i=0; i<dItems.length; i++) { var fl = fItems.length; for(j=0;j<fI;j++) { if(fItem[j]==dItem[i]) { fItem.splice(j,1); --fl; } } } } if(fItems.length>0) { fItems = fItems.sort(function(a,b) {return moment(a) - moment(b);}); max = fItems[fItems.length-1]; } else if(selrng) { max = selrng; } } else { // replacing members with last/next delete item.jaql.filter.from; delete item.jaql.filter.members; item.jaql.filter.last = { offset: 0, count: 365, anchor: max }; } }); Thanks Naz948Views0likes0Comments
How to change my widget breakdown with a viewer license (could not go to edit setting) ?
Hello, Is there a way to change my widget breakdown with a viewer license (could not go to edit setting) ? I mean I have 1 widget broken down by Client Segment (see below) And I want to be able to switch "Client segment" into "Length of Rental segment" without going to edit setting of the widget and with a viewer license. Thanks for your help.4.4KViews0likes5CommentsConditional Tooltip based on Date granularity
Hello, I am very new to sisense and have a typical requirement so I am using blox buttons to change the granularity in a widget In the same widget I would like to show comparisons in tooltip for last month, last quarter depending on the granularity selected in this button or if there is a way I can just show comparison in another widget but like for tooltip it needs to change with the selected granularity hope this makes sense1.1KViews0likes0Comments
Display values continuously over time with existing gaps in FACT data table
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 dimension table containing the date of every day (see screenshot attached). However, if there was not a movement for a specific product, there is no entry in the FACT table. Example: 01.01.22: stock level = 5 02.01.22: stock level = 4 06.01.22: stock level = 10 When displaying those stock levels on a line/column chart, I only display the 3 days by default. There exists a "time gap" in the data and I am looking for a way to display the stock level for every day as a "continuous" rate over time. As there are no values in the FACT table for 03/04/05th January, I would like to display the latest value available (in this case the value stock level = 4). Are there any ways to solve this on the dashboard side (maybe with function/script)? I have already enabled the widget option "Display missing values as 0" but instead of displaying a 0, I would like to display the latest available value from the FACT table. Please also see the screenshots attached. Happy about any kind of suggestions or tips! 🙂    7.3KViews0likes10Comments