ContributionsMost RecentNewest TopicsMost LikesSolutionsNext quarter instead of Past Quarter on widget level Hi, I'm looking to replace the 'Past Quarter' function on the widget level with the 'Next Quarter'. I see that there is no in-built function as such for that, ca someone help me how I get that function on the widget? Advanced filter to pull all dates after today Hi, { "next": { "count": 360, "offset": 1 } } While using this gives me only next 360 days, how can i not limit it certain days and keep it open-ended to filter it to all dates after today? Re: Allowing only specific columns in pivot to drill down harikm007 any suggestions on this? I know that JTD doesn't allow disable drill down on certain columns, but can we do this using the scripting? Re: Tabber selected filters harikm007 please suggest. Tabber selected filters Hi, I have two tabbers for two different teams for eg: Sales and Marketing to view their respective metrics on their respective tabbers. I also have a filter name called 'Manager' to filter those who head each of these team. I want to default one manager (ex: Jack) to Sales tabber and another manager (ex: Jill) to Marketing tabber. Also, how can I default various filters on these tabs? Exclude specific filters on JTD script not working Hi, I'm trying to use this script to disable a filter on jump-to-dashboard, but its not working. prism.jumpToDashboard(widget, { excludeFilterDims : "[country.Country],[brand.Brand]"}) I'm using L2022.6.0 version. Please suggest what's the right way to do disable the JTD filter. SolvedDo not display zero value rows in Pivot table Hi, I have two 'value' columns in pivot table that have both zero and non-zero values in them. But there are also some rows with zero values in both the columns. I cant really use the column1>0 filter, this would eliminate rows where there could be non-zero value in column2. I just want to eliminate rows where both the columns have zero values. Suggestions please. SolvedAllowing only specific columns in pivot to drill down I have a pivot table with 9 columns and I have added a jump-to-dashboard to this pivot table, but I want only 3 out of those 9 columns to be enabled for drilling into that JTD and not all the 9 columns. Also, is it possible to connect different JTDs to a single pivot table on different columns? Display a selected filter as a text widget on dashboard Hi, I want to display a selected item on a text filter as a simple text on dashboard. for example: I have a filter called account name and I filter it to the name 'Google', I want 'Google' to be displayed in the form of text widget on the dashboard. Thanks. SolvedRe: Display number of rows from pivot table as a numeric widget Hi Hari, I think I found a way to do it. Thank you for your response. I really appreciate it!