Build Analytics

Resolved! Previous Month Comparison when Previous Month has Fewer Days(Indicator Widget)

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...

Tips on Managing Formulas / Getting Consistent Calculations

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 ...

How to create a table with a range of dates?

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...

Resolved! Remove Widget Lines When Exporting to PDF

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.

Let viewers remove their starred filters

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 ...

Resolved! How to discard dashboard changes

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?

Resolved! Relative dates using Blox

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...

Format Chart Columns with Same Values

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.

Conditional formula based on value from chart

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...

Resolved! Customize Pulse notification alerts

Hello! I have Pulse notifications setup for build alerts. The default alert notification only indicates whether a build was success or failure. In an event a scheduled build has failed, is there a way to customize the build alert notifications to in...

Resolved! Show blank values in pivot table instead of not showing line at all

Hi,In the data model I have main table that is linked to another table using an index.Not all rows exists on the other table.When I try to display in the Pivot table column from the other table it omits from the table the non linked rows.Is there a w...

Pagination in Blox?

Hi, new to blox and trying to figure out how to create pagination on a list. So I have a container holding a column set with 3 columns and different information in each. Is there an option I am missing that can show lets say 5 of these containers ...

Rolling 30 Calculations: Counts NOT Avg/Sum

Hi all!I found this article: https://community.sisense.com/t5/knowledge/rolling-trailing-12-months/ta-p/565on how to do rolling calculations if you have averages or sums.Unfortunately, I need to do a rolling 30 day unique count - I want to know the r...

Conditional border color for Blox container

Hi, I need to change the left border color of the blox container if it falls in a particular range.

Displaying metrics in Rows

We have a requirement where user want to see the metric in rows and dimension in columns, Is there a way to achieve this in sisense

Sisense Community

Forum Posts

Resolved! Previous Month Comparison when Previous Month has Fewer Days(Indicator Widget)

Tips on Managing Formulas / Getting Consistent Calculations

How to create a table with a range of dates?

Resolved! Remove Widget Lines When Exporting to PDF

Let viewers remove their starred filters

Resolved! How to discard dashboard changes

Resolved! Relative dates using Blox

Format Chart Columns with Same Values

Conditional formula based on value from chart

Resolved! Customize Pulse notification alerts

Resolved! Show blank values in pivot table instead of not showing line at all

Pagination in Blox?

Rolling 30 Calculations: Counts NOT Avg/Sum

Conditional border color for Blox container

Displaying metrics in Rows

Community Content Spotlight

Content you missed that you never planned on reading

Data model

Change the order of layers Stacked Area Chart

Pivot Widget - Maximum Number of Values

Add a drop-down for sorting

Using RSUM results in BE#208517 Internal Analytica...

Sisense Implement RLS in Bigquery to access data i...

In a Pivot Table I need to hide a column when no d...

Filter remains in jumping to dashboard even when i...

Can use use Switchable Dimensions for Line and Are...

RSUM with Display Missing as Zero and BreakBy

Data model

Re: Rename the Pivot Grand Total

Disabling the "Allow multiselect for lists" toggle...

Possible to comment out in formula editor?