ssoltz
Cloud Apps
Joined 02-04-2024
User Profile
User Widgets
Contributions
changing start of week for last week filter in Live Data environment
Hi All, Anyone have any ideas in how to get around the Monday through Sunday grouping for weeks in the Live Data model (non-Elasticube)? Also would be curious if we could identify Day of the week through scripting as well. Thank you!1.3KViews0likes5CommentsRe: Excluding from an existing Dashboard filter using BLOX
Daniel rapidbisupport , Here is the new video: Video I have a feeling your new solution paired with the old one will work. My biggest question is where to put the script. The old one was placed as a Dashboard script. So, I either have to merge old code with new there or understand which widget to add the script to. By the way, here is my hacked version of your code to create the same filtered records on equivalent Dashboard filters from two different datasets: const targetWidgetWithResultOid = '65c79382dbb6a200328554a3' const targetFilterTitle = 'CAD Inc Num Filter' const targetFilterTitle1 = 'EMS Inc Num Filter' dashboard.on('domready', () => { $('#filterButton').on('click', () => { const targetWidgetWithResult = prism.activeDashboard.widgets.$$widgets.find((w) => { return w.oid === targetWidgetWithResultOid }) const targetWidgetResponse = targetWidgetWithResult.queryResult.loadService.data.data[0].data.map((r) => { return r.value }) const targetFilter = prism.activeDashboard.filters.flatten().find((f) => { return f.jaql.title === targetFilterTitle }) const targetFilter1 = prism.activeDashboard.filters.flatten().find((f) => { return f.jaql.title === targetFilterTitle1 }) delete targetFilter.jaql.filter.all targetFilter.jaql.filter.members = targetWidgetResponse prism.activeDashboard.refresh() delete targetFilter1.jaql.filter.all targetFilter1.jaql.filter.members = targetWidgetResponse prism.activeDashboard.refresh() }) }) Thank you AGAIN for your assistance!3.1KViews0likes1CommentRe: Excluding from an existing Dashboard filter using BLOX
Daniel, I am working on this currently. I will make a video shortly if I cannot get this to work (no luck so far). So, my confusion currently is that the original solution you created for me was embedding the script in the Dashboard script not a widget script as you state above. So, I'm either trying to use this as a widget script (in this case, which widget...the new button widget? This is not working)...or combining this new script with the old Dashboard script (this is not working yet as I do not know the syntax). Thank you!3.1KViews0likes0CommentsExcluding from an existing Dashboard filter using BLOX
Hello, I had an earlier challenge which was solved by Daniel (@rapidbisupport). Thank you! Now, I'm hoping to take this one step further. After the Dashboard filter has been created, I'd like to create another BLOX button to remove specific filter entries from the list (either remove from the include or exclude) using a similar method as previous. Here is the link to the last request / post: link to post Thank you in advance!Solved3.4KViews0likes8CommentsRe: looking to create a custom Dashboard filter from a result from another widget (Live Data Model)
So, I can't express how much this solution has helped me. This is huge! I cannot thank you enough. Once I figured out how to get the widget OID, it pretty much worked OOTB. Perfect solution... I cannot thank you enough!2.1KViews0likes1Comment