bminehart
ETL
Joined 01-23-2023
User Profile
User Widgets
Contributions
Re: CASE WHEN syntax w/ multiple conditions
Thanks AssafHanina. We're trying to apply the formula at the widget level and it is not working. I'll get a snippet of the complete function and error to share here. Also: you say it's "not supported on the dashboard level" -- I don't understand how CASE WHEN logic can be used at the Dashboard layer? It's syntax used in a function, and aren't functions only a feature within widgets?350Views0likes1CommentCASE WHEN syntax w/ multiple conditions
We're trying to build a formula using CASE WHEN syntax with multiple conditions using AND. Example: CASE WHEN MIN(MNDIFF([time A], [time B])) <= 30 AND [column A]='Value' THEN DUPCOUNT([column B]) ELSE 0 This syntax is not working. Any tips?468Views0likes6Commentsnew vs. legacy filtering UI -- are there functional differences?
We haven't enabled the new filtering UI in our Sisense tenant yet, because I am unaware of any compelling functionality changes/improves with the new UI. But now that I see that Sisense is forcing the new UI in an upcoming release, I am re-evaluating whether we should start using the new UI. So to that end, and since I cannot find any comparisons online, and disregarding the look and feel of the new filtering UI: are there functional differences with how filtering works with the new UI?Solved763Views0likes4CommentsRe: Reset to Default Filters Button using BloX
There has been a bunch of chatter under my old 2024 question in this thread. Any chance someone knows now if what I'm asking is possible? Our users often get into a situation where they've accidentally created disparate sets of widget-level filters and I'd like a button that will reset all of the widget-level filters back to the default (i.e., inherit all fo the filters from the dashboard and remove all widget-level filters). Any bright ideas?2.2KViews0likes0Commentsexporting Tables and Pivot Tables that have been modified by a script
Hello: I've been exploring a few ways to modify values contained in Table and Pivot Table widgets using the script editor. While I have successfully been able to modify the widget in my browser, when I export the data to CSV or Excel, I'm still getting the original/underlying values from the data model. Is there any way to get around this? -Ben630Views0likes3Commentscreate string concatenation function at the dashboard layer
Our users often ask about concatenating strings contained in two separate columns as a calculated column in pivot tables. Although this is possible at the data model layer, it is not possible at the dashboard layer. We do not expose data model design and administration to our end users. Would be very helpful for Sisense to introduce this functionality.361Views3likes2CommentsRe: concat strings at the dashboard layer?
We already do this for some combinations of columns, but because we've embedded Sisense in an app that is intended to be adaptable/universal for a variety of customers and use cases, there are too many variations of string concatentations for us to build into the data layer. We really need it at the user/Dashboard layer.1.8KViews0likes1CommentRe: Custom sort for Bar and Column Chart
rapidbisupport - is there a variation of this script that would allow me to perfom custom sorting in a pivot table or table column? Example, I have categories, Apple, Banana, Cherry. Normally it sorts in that order. But I want the sort to be Banana, Apple, Cherry. Is that possible?1.4KViews0likes0Comments