psdutton315
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: example using SUM() function in a widget formula
Assuming you are using a pivot table? You don't need to use the SUM() function - you can just create a column that is column A + Column B For example - If Column A = TOTAL_GROSS_MARGIN and Column B = TOTAL_PT, in the pivot widget design you can use the function builder to create a 3rd column (value) that is TOTAL_GROSS_MARGIN + TOTAL_PT which would be the sum of Columns A and B alternatively - you could also create a calculated column in the data model that is Column A + Column B and then reference that new field in the pivot table design Hope this helps2.3KViews0likes2CommentsJump To Dashboard Exclude multiples filter syntax
Would like to exclude multiple columns in a pivot table as filters in a jump to dashboard. We are using the syntax below in a widget script on the dashboard that we are jumping from, but there is an issue and the filters are not being excluded. We built the script based on feedback in another post: https://community.sisense.com/t5/build-analytics/is-there-a-way-to-pass-specific-filters-for-jump-to-dashboard/m-p/4256 Here is the script we are using: prism.jumpToDashboard(widget, { displayDashboardsPane:false, displayToolbarRow :false, displayHeaderRow :false, excludeFilterDims: [ "[_drill_CSNAP_LOAD_DETAIL.CUST_CODE]", "[_drill_CSNAP_LOAD_DETAIL.Days In PICKUP_DATE (Calendar)]", "[_drill_CSNAP_LOAD_DETAIL.Origin City State]", "[_drill_CSNAP_LOAD_DETAIL.Destination City State]", "[_drill_CSNAP_LOAD_DETAIL.CARRIER_MODE]", "[_drill_CSNAP_LOAD_DETAIL.CARRIER_SERVICE]" ], includeFilterDims: [ "[_drill_CSNAP_LOAD_DETAIL.LOAD_NBR]" ] }); but it doesn't seem to be working. Any advice would be appreciated Thanks!1.8KViews0likes2CommentsChange a dashbord filter by selecting a value on in a pivot table in a widget within the dashboard
We have an activity by customer dashboard that allows the end users to changes customers using a dashboard filter. One of the widgets on the dashboard is a pivot table displaying basic information about accounts that are related to the account that is used to filter the dashboard (parents, children or peers of the selected account). Is it possible to display the related Account code as a hyperlink and when clicked, it would apply the selected related account code as the main dashboard filter and refresh? Instead of a jump to, it would be just changing the dashboard filter and refreshing? Thanks in advance767Views0likes0Comments