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
  • 1301 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
  • 1327 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
  • 1171 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
  • 1302 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
  • 1712 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
  • 1242 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
  • 545 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!

Change line chart to Step chart

A step chart is a line chart in which points are connected by horizontal and vertical line segments, looking like steps of a staircase. Use below script to display line chart as steps. Refer: https://www.binextlevel.com/post/change-line-chart-to-step...

harikm007_0-1657210997832.png
harikm007 by 13 - Data Warehouse
  • 628 Views
  • 0 replies
  • 0 kudos