Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Swap columns in pivot2

Hi everyone. I'm trying to find a way to order the columns of a pivot in ascending order, based on the number included in the description of the header. Below you'll find a screenshot with the content of the headers. The current order is "+150", "1-2...

image pivot2 sort community.png
cw_meg01 by 7 - Data Storage
  • 1287 Views
  • 2 replies
  • 0 kudos

Add description to Widget

Here is a method to add detailed information about the chart and data that will always appear at the bottom of a widget. Refer: https://www.binextlevel.com/post/add-description-to-widget Steps: Create widget Add below script to widget. Update text to...

harikm007_0-1657908270289.png harikm007_1-1657908365852.png
harikm007 by 13 - Data Warehouse
  • 1306 Views
  • 3 replies
  • 0 kudos

Blox - Display 0 instead of No Results

In my Blox Code, if the "Panel" value is not returned, the display shows No Results. Is there anyway to display a 0 instead? Blox Code is as below: { "style": { "verticalAlignment": "center" }, "script": "", "title": "", "showCarousel": true, "carous...

mirzay by 8 - Cloud Apps
  • 1156 Views
  • 1 replies
  • 0 kudos

Existing Dashboard Page Not Loading - Error 500

I have been working on a dashboard and lots of custom Blox code since a couple of days. This has been working fine before. I did add a column to a view that is pulled via Live Model and published the Data Model. However, since, I am unable to get int...

mirzay by 8 - Cloud Apps
  • 1288 Views
  • 1 replies
  • 0 kudos

Resolved! Dynamic filter with input parameter

I have this parameter from QbeeQ plugin called [@Days_Ago]. It should be used as a filter in formulas For example: Calculate total sales with [Days Ago] < = [@Days_Ago]The formula would look like ([Total Sales] , [Days Ago]) while [Days Ago] column s...

TwieN_0-1657807825331.png
TwieN by 8 - Cloud Apps
  • 1692 Views
  • 1 replies
  • 0 kudos

Changing Legend sequence on a stacked bar

Hi there! Is there a way to order the legend in a custom sequence ( not used the break by as there are number of variables that needs to be added) without changing the chart or altering the visualisation.

Renaming the names of legend in a stacked bar chart

Hi there! I have a field called "ABC" which is a boolean with "Yes" and "No" records. I am breaking by "ABC" in a column chart where the legends appear as "YES" and "NO" wherein I wanted to rename/append it as " ABC Yes" and "ABC No" on the widget le...

Creating Custom Column in View with filtered column

There is a metric that I am using for a view in a widget, as shown below: `(COUNT([user_id], [status])/COUNT([user_id])` I have a view where I have a user_id and status column. I want to create a metric with only a count of user_id where status = 'AC...

amelia by 10 - ETL
  • 1207 Views
  • 2 replies
  • 0 kudos

Replicating DIFFPASTWEEK logic in BigQuery

My current view has a date column and a column with metric 1 (as shown in screenshot). In the Sisense widget front-end, I aggregate the dates as weeks. This sums up metric 1 for all the dates in a week. I then use the DIFFPASTWEEK function to create ...

amelia by 10 - ETL
  • 524 Views
  • 0 replies
  • 0 kudos

Resolved! Hide Widget Detail icon

Hi, Is there a way to hide the 'i' icon showing the widget details at the top right corner of every widget? Thanks in Advance!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]