abhinavt
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Retrieve Explicit Dashboard Filter values when "Include All" is selected
Hello All, I'm trying to get a dashboard filter values when Sisense dashboard is embedded in our website (using EmbedSDK). I was able to get the active filters when I use the below function and when "Include All" is not selected. // Function to retrieve filter values for the dashboard function getDashboardFilterValues() { const filter = prism.activeDashboard.filters.$$items.find(el => el.jaql && el.jaql.dim === dimension); return filter?.jaql?.filter?.members || []; } } Problem arises when a user selects "include all" (see below) instead of explicit selection, this function doesn't return any values. Ideally it should still return the 3 values as shown above.501Views0likes1CommentRe: Customize No Results Layout
Thanks for the help David. Looks like the plugin is around 6 years old so this has to tested across all environments and we might need more time on that. And on the link that you shared, it has the method to customize message or image but not the layout of the page. All we're looking for is to adjust the size of the No-Results page..1.4KViews0likes1CommentCustomize No Results Layout
Hello All, Is there a way to customize "No Results" layout, we have few buttons at the top being hidden when widget has no data. Also adding the html script we're using. TIA const dropdownWrapperHTML = ` <div class="dropdown-wrapper-${w.oid} ${dimname}-dropdown" style="position: relative; display: inline-block; width: 100%; max-width: fit-content;"> <label for="productDropdown-${w.oid}" style="cursor: pointer; margin-left: 21px; font-size: 12px; color: #007BFF;"> Product <span style="font-size: 10px; transition: transform 0.2s;">▼</span> </label> <span id="selectedProduct-${w.oid}" style="font-size: 12px; margin-left: 8px; color: #007BFF;">(None)</span> <div class="dd-container-${w.oid}" style="position: absolute; top: 100%; left: 0; z-index: 1000; background: #FFFFFF; border: 1px solid #E0E0E0; border-radius: 8px; display: none; padding: 10px; box-shadow: 0px 4px 12px rgba(0, 0, 0, 0.15);"> <input type="text" id="dropdown-search-${w.oid}" placeholder="Search products..." style="width: 100%; padding: 8px; margin-bottom: 5px; font-size: 12px; border: 1px solid #E0E0E0; border-radius: 4px;"> <div id="radioContainer-${w.oid}" style="max-height: 200px; overflow-y: auto;"></div> </div> </div> `;Solved1.5KViews0likes6CommentsMove A Chart Forward/Backward on Dual Axis Charts
Hello, Is there a way to bring a chart forward/backward in a dual axis chart? I would like to bring the lines on the below chart forward... Also, glad if there's a way to customize the fonts (size/color) for the Value labels and/or Axis labels. Thanks, AbhinavSolved779Views0likes1CommentRe: Cascading filters for independent dimensions
Posting the solution from another thread/discussion : https://community.sisense.com/t5/help-and-how-to/pass-dashboard-filter-value-to-data-model-as-a-parameter/m-p/22254#M468 " We found a working solution for this, we were advised to convert all our dashboard filters to background filters. Later we made some changes to the code while embedding such that only the relevant selections from our embed platform are passed to each dashboard filter. Note :This cannot be done through the frontend dashboard unless we add dependent filters. However, it's great that we found a solution through embedding "2.1KViews1like0CommentsRe: Pass Dashboard Filter value to Data Model as a Parameter
Hey David, We found a working solution for this, we were advised to convert all our dashboard filters to background filters. Later we made some changes to the code while embedding such that only the relevant selections from our embed platform are passed to each dashboard filter. Note :This cannot be done through the frontend dashboard unless we add dependent filters. However, it's great that we found a solution through embedding.2.9KViews1like0CommentsRe: Pass Dashboard Filter value to Data Model as a Parameter
Hi Javiers, We have discussed this workaround with the Sisense developer support team. Unfortunately this doesnt fit our use case as users can open multiple tabs with different request ids. But they have suggested a solution to convert filters to background filters and some JAQL changes while embedding. This helped to pass relevant filters for each but background filter. Although we are working to make sure the background filters stay single select (for our use case) as by default bg filters are multi select and will update once we found a permanent solution.2.9KViews0likes0CommentsRe: Cascading filters for independent dimensions
Hello David, We're discussing similar problem in another thread (https://community.sisense.com/t5/help-and-how-to/pass-dashboard-filter-value-to-data-model-as-a-parameter/m-p/21956#M386) and we've connected with Sisense Tech Lead and waiting for them to get back to us. Thanks, Abhinav T2.2KViews0likes0CommentsRe: Pass Dashboard Filter value to Data Model as a Parameter
Thanks for replying David. I had this thought while addressing a different problem regarding filters cascading/dependency. Currently this can be only achieved by using dependent filters, but we want to have control over each filter since we disable few of them in some widgets. We're using a flat view in live connection that holds a request_id (dashboard filter) that is updated every time user runs a new report in embed platform. If we include a WHERE clause with request_id in the live model then we dont have a problem working with dashboard filters. Thanks, Abhinav3KViews0likes0Comments