Assume a date dimension. It contains a series of dates. The latest date available as a value is not necessarily today or yesterday as it could be mentioned in the dashboard filters. The need is for the dashboard filter is to select the latest date av...
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.
I am trying to change the order of the columns. I would like the order be from the left: National, My-Group, Firm 2113, etc. Is it possible? Thanks! Kit
Hello Sisense Community! Is anyone aware of a method to dynamically round data labels so that: Any value >= 1000.00 shows two decimal points (green in the screenshot)Any value < 1000.00 shows 0 decimal points (yellow in the screenshot)
I have a BloX widget that builds a simple table of name/value pairs. The data has 16 rows and I have showCarousel set to false so all data is displayed. When the widget is rendered, only the first 10 rows of data are displayed. Using Chrome's deve...
I have a BloX widget that builds a small table of item/value pairs. I want to show the entire table so I have showCarousel set to false. The table builds fine but only the first 10 items are shown in the widget. (There are 16 total.) This page: ht...
Hello Everyone, We have come across one requirement for one of our customer, where days in Date as Dashboard filter and in an indicator widget primary value represents "count(Ids)" and in secondary value "pastmonth(count(Ids))". When we select filter...
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 ...
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...
Hello Sisense Community! Does anyone know of a way to remove the borderlines that appear on each widget? I have highlighted them in yellow in the example screenshot below.
Hi all, Through the REST API it's possible to give viewers access to starred filters and also let's them create those filters themselves. However, they do not have the option to overwrite/remove those starred filters. Is this possible? Or could this ...
If I, as the owner, make changes to a previously published dashboard and then decide that I want to discard those changes instead of publishing them and revert my local copy back to my published version, how can I accomplish that?
Hi all, I came across this article showing how change the date granularity for widgets using Blox: https://support.sisense.com/kb/en/article/relative-date-filter-in-blox However, in the Blox code it shows fixed entries (basically it forces curren...
Is anyone aware of how to format a column chart so that all columns with the same values are represented by a matching color? See the attached screenshot.
Hi,I have created a chart that is base on launch day and I want to count the number of IDs per each date in the chart but only if the ID has last_seen date that is >= from the day on the chart.And this the chart with only count unique IDs without the...
