Hello! I'm trying to create a formula that will calculate the number of days between two dates. The first date would always be an "Open Date", which all items should have. The second date would be conditional: I want it to use a "Closed Date", or if ...
Hello, I am trying to create a pivot table for all of the campaigns that my company is running. Most of these can have an open date range, but one of them needs a closed date range. so far, I have the pivot in the widget. I have Campaign in the rows ...
I am using the conditions feature on BloX cards. Here is an example: "conditions": [ { "minRange": "-Infinity", "maxRange": -0.01, "color": "#FA5656", "image": "/plugins/BloX/blox-images/StockMarket/arrow-down.png" }, { "minRange": 0, "maxRange": "In...
There are features in the more current versions of Highchart that I want to be able to use. It looks like our server is on Highcharts v6.0.4. Does Sisense intend to move to a more modern version? Or is this something that we can upgrade ourselves?
Hello, How could I calculate weighted average in the widget's formula section ? Thanks
Anyone know how I can filter two values independently? In the chart below the first 4 bars are from my "days in R/I stage formula. The next 4 are related to the Insulation-Prime formula.Each formula has a filter built in to only look at jobs from the...
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 num...
Scenario: My organization has ACCOUNT that have multiple balances associated with them, and each account has a TYPE These accounts tie into a PORTFOLIO We have a Pivot that is to return all PORTFOLIOS and the SUMs of these ACCOUNTS. But we would like...
Hi, I'm trying to display the timezone of the country based on the value selected in the country dashboard filter, in a text widget. Using the below dashboard script as kindly shared by a fellow community member, but I don't see date getting populate...
Hi, We have a requirement where we have to display the local timezone of the country that is being selected from the dashboard filter. The dashboard filter on country has values like Italy, France, Netherlands, UK, US etc. When the user selects "Ital...
Hi Team, I need a hep, I have a line chart with one series and I need to highlight Max and Min values in the same chart. Could you please help me how to achieve this. Thanks SNH
I have a pivot table and I'm pretty happy with how it looks. However, I want to adjust the formula in two of the columns, if possible.The pivot table looks like this: There is a formula in 2 of the value columns: LTD Remaining to Goal, and Forecasted...
I am looking at a Goal vs. Actual column chart. I have two context cases for this framework: units goal and units sold, and revenue goal and revenue collected.I have my bar chart working correctly, but I want to change the design of it a bit to be mo...
We are finally releasing our Analytics Suite to our customers and I would like to create a Dashboard/Report to specifically show items that have "Disappeared" from weekly sales. If an item was consistently sold for 3 weeks or more and then 3 weeks go...
Hi - We have a requirement to access Sisense User Id in the Live model SQL Queries. Do we have any way we can access the Sisense User Id/ Group via some variables?
