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

Forum Posts

Resolved! Year-To-Date for Only Completed Months

Hello, I have a pivot table where I am calculating YTD vs. LYTD metrics by month, like this: I want to exclude April from this table as it is not a completed month and thus doesn't provide useful information. I can't figure out how to do that from th...

lharrison_0-1649101570166.png
lharrison by 8 - Cloud Apps
  • 1759 Views
  • 3 replies
  • 0 kudos

Default Selections - Multiple Tabbers

I am trying to make two dynamically related tabbers that behave like this: TABBER 1: has 5 tabs with FINANCIAL as the default selection. This works without any issues. Tabber 2: I am trying to incorporate a 2nd tabber that is dependent on the CASELOA...

cartercjb_0-1649096129917.png cartercjb_1-1649096129676.png

Resolved! Non Repeating Blox Header

Hi Community! I have the following blox widget based on this code: { "style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}", "titleSty...

cartercjb_1-1649095612143.png

Resolved! Arranging widgets in a dashboard

I'd like to layout widgets better on my page, and I reckon I need to use blox to do that - almost like old-school HTML and divs for controlling layout (stop me if I'm wrong!) .What I can't figure out is how to put widgets into a blox container. Can a...

BLOX TABLE WITH HYPERLINKED URL

I am trying to create a dashboard that contains a Blox widget with custom hyperlinked resources in it. This was what I came up with. Does anyone have a better idea/suggestions for achieving this? { "style": "", "script": "", "titleStyle": [ { "displa...

cartercjb_0-1648527528310.png

BLOX WIDGET: PIVOT INSIDE A PIVOT

I have the following blox widget: with the following code: { "style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}", "showCarousel": f...

cartercjb_1-1647629460323.png cartercjb_2-1647629509001.png cartercjb_6-1647629674234.png cartercjb_5-1647629627259.png

REFERENCING WIDGETID AS VARIABLE IN TABBER

Can anyone recommend the best-practice approach for defining each widget ID as its own variable so that I can reference the names in this script instead? I'm having a difficult time keeping each tab accurately updated. This is what I have currently c...

cartercjb_0-1647369623530.png cartercjb_0-1647438460281.png cartercjb_1-1647438639783.gif

Resolved! DYNAMIC SUBTOTAL TEXT

I am trying to remove the Total text portion from the subtotal row so that it only reads the row value - COTA (highlighted in yellow): Referencing this KB article, I was able successfully this with the manual text replacement, but I'd rather it be dy...

cartercjb_0-1647278470219.png cartercjb_0-1647282802080.png

Resolved! Blox - Color format words in text string

Hello Sisense Community, Despite on-line HTML references, I cannot properly code a BloX "text" string to change color of specific words in the text line. I'm sure this is straightforward coding; can't find an example in other BloX templates. I have a...

Dennis_M by 9 - Travel Pro
  • 1648 Views
  • 2 replies
  • 0 kudos

Resolved! Use of Conditions in BloX Column sets/columns

I would like to be able to filter BloX column Panel Items & Values based on a conditional. In my use case we have something similar to the mockup below: The goal is to be able to filter the panel values in each column in the column set to a specific ...

Breeds.png

Resolved! DEFAULT TABBER SELECTION

I have the following tabber created: Is there a way to dynamically set the default selection so that when the dashboard opens, it opens to the correct day? So if I were to open it today, it would select Monday. If I were to open this on a Wednesday, ...

cartercjb_0-1645463305749.png

APPLY CONDITIONAL FORMAT TO ENTIRE ROW

Is there a way to apply conditional formatting to an entire row, based on the conditions of 1 value? I'm pretty sure I could copy the formula to all other values, but that would be annoying with hows many we have in the pivot. PLUS it would not cover...

cartercjb_2-1645233131494.png

Resolved! Text Wrap in Bar Charts

I am trying to get the x-axis in the widget to wrap text. I originally thought that this Sisense Support KB (Labels & Legend Sorting In Stacked Charts) would resolve it but it didn't. One reason might be because their scenario is cutting off the text...

cartercjb_0-1645219387980.png

Resolved! Transposing Pivot Table

Current format ^   The format I want to achieve ^ Hi everyone, I am currently working on a project and the client wants the values to be displayed in rows, grouped by Country (as seen in the image above). However, the default in Sisense is to put the...

Screen Shot 2022-02-16 at 1.43.17 PM.png Screen Shot 2022-02-16 at 1.43.28 PM.png
amelia by 10 - ETL
  • 4496 Views
  • 6 replies
  • 0 kudos

Resolved! + sign for values in Blox

Hi, I was looking for a way to add '+' sign to a value whenever the result is positive in Blox. Please let me know if there is a way to add this feature Thanks in Advance!