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

Forum Posts

RSUM not producing desired result when filtering

I've built a widget that uses RSUM to sum the values for multiple rows/RSUM of Fiscal Period of Year as shown in column Avg YTD Revenue shown in the two screen shots below: Works great. However, if I filter the pivot down to a single Fiscal Period th...

Capto_Capture 2023-02-15_05-58-45_PM.png Capto_Capture 2023-02-15_05-59-22_PM.png Capto_Capture 2023-02-15_06-02-57_PM.png

Resolved! How to decrypt the encrypted columns

I have a few columns in the database that are encrypted. I checked with my data warehouse team and they said it is something Sisense is doing. Does anyone know how to decrypt these columns?

zach_myt by 9 - Travel Pro
  • 563 Views
  • 2 replies
  • 0 kudos

Option to drill down in Funnel Chart?

I'm wondering if there is a widget script available to enable "drilling down" into a category of a Funnel Chart. When I right click on a Funnel Chart category, no menu appears. Drilling down is available for Pie Charts, which summarizes data in the s...

ebambury by 8 - Cloud Apps
  • 455 Views
  • 1 replies
  • 0 kudos

Resolved! Dynamic heat map for Gradient color in pivot

Hi Team,I am creating a gradient heat map for pivot and using this script. But, this only works for the second column. I tried to tweak the var tag but it's not working, can anyone help me with this.Thank you cc: @harikm007 // select color theme from...

zohebakber_0-1676275471972.png

Enable/Disable Pivot columns based on selected filter

Sometimes we need to hide or show few columns in pivot table based on a filter selected. Here is a script to achieve this. Reference: https://www.binextlevel.com/post/enable-disable-pivot-columns-based-on-selected-filter Steps: Create a Pivot table A...

harikm007_0-1676035891224.png
harikm007 by 13 - Data Warehouse
  • 499 Views
  • 1 replies
  • 4 kudos

Resolved! Dashboard time filter from dynamic TODAY until forever

Hi. I have searched and cant seem to find this specific answer and I have tried multiple attempts of using currentdate(), today(), etc. I need a dashboard time filter that starts TODAY, end date doesn't matter as I can make it 20 years into the futur...

mccoy1000 by 7 - Data Storage
  • 542 Views
  • 2 replies
  • 0 kudos

Resolved! Hide column until drilled into

I want to hide a column until the user drills into the chart. Example of what it currently looks like below: I would like to hide the "Videos in Module" until the user clicks the drill into. So it would look like this initially. Then when a user clic...

zach_myt_1-1675717179390.png zach_myt_2-1675717305528.png zach_myt_3-1675717362327.png
zach_myt by 9 - Travel Pro
  • 884 Views
  • 5 replies
  • 0 kudos

How to hide a column in a table widget?

Does anyone know how to hide a column in a table widget? I saw the old post here (https://community.sisense.com/t5/build-analytics/pivot-2-0-hiding-columns-from-the-display/td-p/3607) for pivot table but that doesn't work on table widget. Thank you.

DXC by 7 - Data Storage
  • 1128 Views
  • 5 replies
  • 0 kudos

Filter by two values on same widget

Anyone know how I can filter two values independently? In the chart below the first 4 bars are from my "days in R/I stage formula. The next 4 are related to the Insulation-Prime formula.Each formula has a filter built in to only look at jobs from the...

CLewis_1-1675379465185.png
CLewis by 8 - Cloud Apps
  • 396 Views
  • 1 replies
  • 0 kudos

Resolved! Custom Column for Pivot

Hello all, I am trying to create a custom column with the following conditions: IF ( (SUM([Sale Price])<361000, [Sale Price ]/1.2, SUM([Sale Price ])), (SUM([Sale Price])<450000, [Sale Price ]+21350/1.3, SUM([Sale Price ])), (SUM([Sale Price])>450001...

Yeg2023 by 7 - Data Storage
  • 493 Views
  • 1 replies
  • 0 kudos
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 community@sisense.com