This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.

Accept
Reject
Preferences
Help
Build Analytics
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a Post

Formula to display null values

I have a widget that I would like to replace all null values with values of "0". I am trying to use the following formula: "CASE WHEN ISNULL (PASTYEAR(SUM([Total TotalSales]))) THEN 0 ELSE (PASTYEAR(SUM([Total TotalSales]))) END" but I am having no s...

Resolved! Filter remains in jumping to dashboard even when it has been deleted

Hi friends,I have the following issue. When I jump to dashboard, two filters remain: one of date and another one categorical to filter the last day of the month. I deleted both on the original dashboards, but every time I jump to it from another dash...

dani314 by • 7 - Data Storage
  • 1237 Views
  • 4 replies
  • 0 kudos

Show Title(dimension) with mode price in Pivot table values

Hi Team,I have a table where I am showing Mode Price of the products. I want to show a title of the product along with the mode price.However, this is not able to achieve.I have retailer in the columns. I want to show title and mode price under each ...

zohebakber_0-1711022099796.png

Return members from dashboard script

My goal is to have a dashboard filter be dynamically hidden based on number of values in an elasticube table that a user has access to.  Specifically, if [Tenant].[Tenant Name] returns more than one value, the dashboard filter should be visible.  Les...

cglowe by • 8 - Cloud Apps
  • 831 Views
  • 2 replies
  • 0 kudos

Resolved! Can use use Switchable Dimensions for Line and Area Charts

I am trying to use switchable dimensions pluggin in Sisense for a line chart and area chart using a date dimensional table where my dates are in numerical values for conventionality. I am trying to use this pluggin to go from monthly, quarterly, and ...

Astroraf by • 10 - ETL
  • 1037 Views
  • 3 replies
  • 0 kudos

Creating A Burndown Chart In Sisense

Hi all,  I want to create a burndown chart with my planned and actual hours for a project across time. I'm unsure what functions would be best to use here - has anyone created one in Sisense before and would like to give any advice? Would I use the R...

Share Dashboard folder public

Hello experts,In Sisense, assets are private by default. example if you organize your dashboard in a folder, it requires you to share that report individually for each user or groupI wonder if there is a way to make this publicly available? example. ...

Resolved! Pivot Widget - Maximum Number of Values

Hello community,We came across this post from the old community : https://community-old.sisense.com/hc/en-us/community/posts/115000896608-Table-Widget-Maximum-Number-of-ColumnsWe have tested this on Version L2023.9.0.308 and it seems to work.Is anyon...

MikeGre by • 9 - Travel Pro
  • 1259 Views
  • 5 replies
  • 0 kudos

Resolved! Reorder columns in pivot table

Hi Team,@Angelina_QBeeQI want to order the weeks displayed in below pivot in desc order i.e latest week first and so on.Also how to hide the "Header" word....i need the column but the column header should be blank.Please help !! 

gyanianand_0-1684134616028.png

Resolved! New Blox Border Snippet

I cannot figure out where in the editor to place the border snippet code to keep my blox widget from using the system defaulted corner radius.  No matter where I place it the corners of the widget remain rounded. { "spaceAround": "none|small|medium...

Resolved! script scatter map hover show more than top 10

When hovering over a data point in a scatter map, is there a way to view more results than the current max of 10 ("showing first 10 results")?  Perhaps there's a script I could use?

danblack by • 9 - Travel Pro
  • 711 Views
  • 1 replies
  • 1 kudos

Sum based on OR condition

Hi.I'm trying do a simple sum based on OR condition of 2 column of a table. For now I just want to display a number (that later I will use for a more complex widget) by summing the elements of the table that satisfies a string condition of a column a...

vatojavier_1-1710417835046.png

Jump to dashboard - respect drill-downs

I have a PivotTable show $ and Country. It has JTD set up.The user right-clicks on the Country "USA" to drill-down on it into Months. Then they click on "January" to see detailed information about sales in January.At the destination, the Month="Janua...

Tim by • 11 - Data Pipeline
  • 676 Views
  • 3 replies
  • 0 kudos

Community Content Spotlight

Content you missed that you never planned on reading

Updated: Dec 9
  1. Blog: 2024 Sisense Community Wrapped
  2. Blog: Creating a unique benchmarking visual with Sisense Blox and SVG
  3. KB Doc: Custom sort for Bar and Column Chart
  4. Sisense Academy: Build and Maintain a Healthy Elasticube Environment
  5. Sisense Docs: Dashboard and Widget JavaScript Extensions
Check out our Software Developer Communities!

They are a great place to connect, learn, and grow.

→Click here to check out the Software Developers Forum←

→Click here to check out the new Sisense Discord Server←

Copyright © 2024 Khoros, LLC