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...
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...
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 ...
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...
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 ...
Hi Team,I want to show the subtotals at the top rather than at the bottom of each group.Can somebody help in this regardThanks
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...
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. ...
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...
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 !!
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...
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?
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...
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...
In viewing widgets, there are 3 options to control number of rows displayed per page. they are 25, 50 and 75. What controls the default to 25? I'd like to default to 75 rows per page but I am not sure how to do so.
