ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Replace Values with Text - Pivot Table Widget Hi...checking back in...can anyone answer the above simple question? Does this only work in Elasticube environments or should this work in a Live Data environment? Re: Replace Values with Text - Pivot Table Widget All, Does this script only work in Elasticube Environments? I cannot get this to work in my Live Data environment. Thank you! Re: changing start of week for last week filter in Live Data environment Thank you, Jacqueline! 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! Re: 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! Re: 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! Excluding 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! SolvedRe: Transferring Grand Total from Pivot when converting widget to Indicator? Try this... Assuming that Project ID is a unique identifying field available... SUM([Project ID],CASE WHEN ([Total budget] - [Total amount]>=0 THEN 1ELSE 0 END) Re: looking to create a custom Dashboard filter from a result from another widget (Live Data Model) Daniel...thank you! Re: 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!