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

Forum Posts

Sum does not except 3 parameters

Any help gratefully received, please.I've hit a wall: apparently I cannot use three parameters in a measure on a widget. Anyone know of a work around?[Total total_client_facing_hours]-sum([work_department],[work_title],[Total total_capacity_hours_on_...

RockyDylan by 7 - Data Storage
  • 1931 Views
  • 3 replies
  • 0 kudos

Resolved! Clickable URL in pivots - Linux update to make it work

Hi, If you are trying to implement a clickable URL in your pivot tables, and you are trying to follow the following article: Clickable URL Links In Pivot Rows   You are going to get a pivot table with all the HTML code (<a href="...">) instead of a...

Advanced Date Filter - Allow User to Select Different Dates

I have dashboards that I want to be filtered, by default, to current month + previous 12 months, as shown below.  However, I also want end users to have the ability to select a different date range if they want.  My issue is that when end users go to...

cglowe_0-1645633335090.png
cglowe by 9 - Travel Pro
  • 1970 Views
  • 1 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 specifi...

Breeds.png

Dashboard layout change

Hi,  I'm trying to change the layout of a dashboard with two columns so I can have the following structure: - the widgets in the two first rows span across the entire dashboard width; the first row has the title while the second row is being populate...

szimmermann_0-1637160358826.png
cw_meg01 by 7 - Data Storage
  • 2187 Views
  • 1 replies
  • 0 kudos

Relative gradient coloring per row basis in Pivot table

Hi all, I would like to color the rows of pivot table in a gradient manner, based on the min value and max value of each row. I am able to put conditional formatting for the whole pivot table based on min and max value for the whole table however, I ...

TJ by 7 - Data Storage
  • 1179 Views
  • 0 replies
  • 0 kudos

Resolved! Filter by both the dimension and the break by on the dashboard

Hi all,   Let's say I have a bar chart in my dashboard displaying number of customers over time with customer segments (small, regular, top) in the break by field. When I turn on 'widget affects dashboard filters' I noticed that the dashboard filters...

ScheurK by 9 - Travel Pro
  • 3201 Views
  • 2 replies
  • 1 kudos

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

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! DONUT CHART DATA LABELS

Hello Sisense Community! Any suggestions on how to make the data labels' percent appear underneath the categories, where the values currently are? In instances where a donut slice is too small (Category 24), it is challenging to interpret this when t...

cartercjb_0-1643056610627.png

Creating rolling sum for 30 days

We are trying to build a pivot where each week will show the running sum of the past 30 days , is there any way we can achieve this in dashboard level   

Screen Shot 2022-02-18 at 3.04.13 PM.png
datanerd by 8 - Cloud Apps
  • 1125 Views
  • 0 replies
  • 1 kudos

Resolved! Custom Map

Hi, We wanted to include additional granularity to the area map for which we found the 'Custom map' plugin offered by Sisense. We were able to download the plugin and add the GeoJSON file, but are facing issues with fetching the correct input from Ma...

MTD SUM BY EACH WEEK IN MONTH

Hello Sisense Community!I have the following draft of a column chart: There is a dashboard filter = last month (Jan. 2022). This is currently showing a sum value for each week based on this formula: (SUM([METRIC]),[Weeks in Date])  My goal is to mai...

cartercjb_0-1644379500321.png cartercjb_1-1644379824611.png

N/A appearing in dashboard filters

Hi All, I see a strange behaviour in the dashboard filter. As we all know that when we click on any category in a widget that category gets added in the dashbard filters and we can add or remove multiple number of categories from the list populated w...

Community Content Spotlight

Content you missed that you never planned on reading

Updated: Jan 15th
  1. Blog: Driving sales and cutting losses: how MPP uses Sisense for smarter decisions!
  2. Blog: Going above and beyond: celebrating our employee of the quarter for Q1 2025
  3. KB Doc: Custom error notification image
  4. Sisense Academy: Educational Webinar: Advanced Dashboards with Plug-ins and Scripts
  5. Sisense Docs: Generative AI (Beta)
Check out our Software Developer Communities!