Srav_Sense
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Sum of last 3 months data in Pivot
Hi, We need to fetch some accounts that have not made any purchases in the last 3 months. In SSMS I use below code, but this seems to be not working correctly when I use it in the cube (as table query). SUM(Amount) OVER (order by Date ROWS BETWEEN 3 PRECEDING AND current row) = 0 Would appreciate any inputs on how to use this in the cube. Thank you!1.6KViews0likes2CommentsHover script to display description
Hi, In a Pivot table, we are displaying the IDs. The business would like to see the description when you hover over those IDs. For ex; I have Risk IDs from 1 to 4. When I hover over 1, it should display High Risk. Can anyone please help? Thank you!1KViews0likes0CommentsRe: How to avoid duplicate rows in BLOX pivot
Hi Sijo1995 , Thank you so much for your reply. The JTD looks okay but the data in the main table (BLOX pivot) has duplicate values. I am using the code from here for BLOX pivot - BLOX WIDGET: PIVOT INSIDE A PIVOT - Sisense Community Thank you!2.1KViews0likes0CommentsHow to avoid duplicate rows in BLOX pivot
Hello, We have a BLOX pivot from which there are multiple JTDs, from different columns. But the issue is that we are getting duplicate rows due to the different columns we are using. We are unable to hide certain columns since those are being passed as filters to JTDs. Is there a way to avoid this issue? Thank you!2.1KViews0likes4CommentsJTD - BLOX: script to include and exclude filters
Hi, We are using JTD from blox pivot, in which we want the JTD to use different filters. Currently it is defaulted to the dashboard filters. I am using include and exclude dim filters, but it is not working right. Can someone please help with what I am doing wrong? Here is the script I am using: "actions": [ { "type": "JTD", "title": "Phone", "data": { "dashboardId": "XXX", "args": { "displayDashboardsPane": false, "displayFilterPane": true, "excludeFilterDims": "[TableName.ColumnName]" }}} ]Solved4KViews0likes4CommentsRe: Navigate to another dashboard using action button. While ensure Dashboard filters remain applied
Hi harikm007 In our dashboard we need to include and exclude certain filters on JTD. Can you please give us an example on how to use ExcludeFilterDims and includeFilterDims the BLOX JTD script. Including those in the in the Actions seems to be not working. I am using JTD in Blox pivot, if that helps.4.2KViews0likes0Comments