andrew
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Trying to use the Contribution() function with PASTYEAR() data results in error
Has anyone been able to use the contribution() function in conjunction with PASTYEAR()? in PIVOT2 E.g. we have CONTRIBUTION( [ Sales ] ) working fine but attempting CONTRIBUTION( PASTYEAR( [ Sales ] ) ) results in error when adding to a pivot widget. I have attempted the same using [ Sales ] / ( [ Sales ] , ALL([ Rows ]) ) but this doesn't work if you employ subtotals & grand totals as the subtotal will be 100 % as opposed to the percentage of the contribution of the subtotal to the grand total. Can anyone help or at least confirm they get an error too when using CONTRIBUTION( PASTYEAR( [ Sales ] ) )1.3KViews0likes2CommentsProblem changing Break by dimension in Scatter Chart via Switchable Dimensions plugin
Hi all, I've been able to switch dimensions for both category and break by panels in a bar chart using the official Switchable Dimensions plugin but need to do this for a scatter chart. I cannot get the break by panel to change. I can manipulate the others (x-axis, y-axis & point). Does anyone else know where I'm going wrong? Thanks, Andrew1.6KViews1like1CommentNew feature - set default formatting of measures. i.e. decimal place, currency symbol, abbreviations
Would like to see the ability in the elasticube (or somewhere else) the ability to set default formatting for measures. For example, you know that field A is a field containing a monetary value. You set the default number of decimal places, symbol and abbreviation options just once and this is inherited whenever you use the field in a widget. Would still need to override the default settings.1.1KViews1like0CommentsAuto Filter on current user
Hi all, I found this plugin which looked like it would do what I wanted: Auto Add Filter Based On User - Sisense Support Knowledge Base However I don't seem to be able to get it to work with our version? Does anyone know if this code is still current and if there is another way to grab the current logged in users email and pass to the dashboard filters? Thanks AndySolved2.8KViews0likes2CommentsLeft Outer Join Plugin
Hi all, I've installed the plugin from here: https://support.sisense.com/kb/en/article/include-all-dimension-values-left-outer-join This does what I want in that it shows all dimensions including ones with no values. Two issues I have are that it breaks the exports to excel and csv. All values come out as 1000 and not the ons in the pivot. Secondly I'd like to show a 0 in place of a n/a value. Any ideas? Thanks, Andrew1.6KViews0likes1Comment