Ido_QBeeQ
ETL
Joined 10-26-2021
User Profile
User Widgets
Contributions
Re: Views bookmarking: Use case of a financial technology company
Hi TriAnthony thank you for sharing this. This is a great use case and awesome implementation. What really resonates here is not just the technical solution itself, but the philosophy behind it. Empowering viewers with meaningful self-service capabilities without actually promoting them to full designer level is exactly where Sisense shines when implemented thoughtfully. It gives business users freedom to explore and pivot perspectives, while still protecting them from the complexity and risk of working directly with full schemas and models. At QBeeQ, we heavily invest in bridging this gap between viewers and designers. For this purpose we created the Self-Service Analytics PowerUp, a suite of powerful plugins designed to empower viewers with more capabilities. The goal is to reduce viewer dependency on dashboard builders for every small change, while freeing designers and data teams to focus on building next-generation data products rather than maintaining already-released data apps. In that context, we wanted to share that we offer a solution that overlaps strongly with what you demonstrated, with some additional capabilities. Our Dashboard Views plugin (formerly Filter Bookmarks) works seamlessly with our Widget Controller, allowing viewers to: Toggle dimensions and measures on any widget type, not just pivots Create presets of filter scopes and widget configurations Save and switch between complete analytical perspectives, or “views” Turn a single widget into the equivalent of many widgets, and a single dashboard into the equivalent of many dashboards Define a default view for themselves From a practical standpoint, one important difference is that our approach is fully supported and production-ready. It does not rely on community plugins, scripts, or BloX, and it works consistently across all Sisense widget types. This keeps implementations lightweight and very easy to maintain over time. For anyone interested, here is a short video showing Dashboard Views in action: https://youtu.be/tsi9CzccdJo?si=akAwsSyHKT4iTJkd And for reference: Dashboard Views: https://www.qbeeq.io/sisense-dashboard-view Widget Controller: https://www.qbeeq.io/sisense-widget-controller Blog post: https://www.qbeeq.io/post/dashboard-views-solving-the-pain-of-a-one-size-fits-all-dashboard QBeeQ Self-Service Analytics PowerUp: https://www.qbeeq.io/self-service-for-sisense Finally, a big thank you again for contributing this to the community. Posts like this help move the conversation forward around true self-service analytics. For those curious to explore further, all of our plugins are free to test and trial. By the way, we just released our all-new FREE Starter PowerUp which holds 10 FREE plugins that take any Sisense dashboard to the next level, check it out! Really appreciate the contribution and the inspiration. Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news!Re: How to Filter Dates for a date that is greater than another date?
Hi Astroraf There are a few ways to achieve this, both would require creating custom columns in the EC table, or creating a new side table to assist with this. You could use the CASE/WHEN but the condition would require int values that represent the dates, or by creating a measured value, that its filter to a flag that applies only to rows which the dates fall into your needed condition. I would go about this by either of the below options Create a custom column in the EC table that compares the 2 dates using DAYDIFF(end,start) see this link . If you need to know how many days in between then just use that function, if you only need to know if date 1 is after date 2 then create a CASE/WHEN comparing the 2 dates and just give a 1 or 0 depending on your logic. Then wither use the actual numeric date difference in a CASE/WHEN statement and the condition should check if the new custom columns value is positive or negative. If you end up getting the binary value, just use that in a measured value, and filter to the 1's or 0's accordingly. Create a custom column in the EC table that converts the dates to an int representation with the formula below Integer (e.g., YYYYMMDD): getyear(Date)*10000 + getmonth(Date)*100 + getday(Date). Then use these int values to compare the dates and see if they end up positive or negative in your formula. Check out this article LMK if I can further assist in any way, We're always here to help Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news!Re: QBeeQ Asset Auditor: A smarter way to manage your Sisense data assets
Super insightful thanks for sharing mia_qbeeq The QBeeQ Asset Auditor is a crystal ball into your internal Sisense metadata and operations, it is really like usage analytics on steroids which allows admins to see beyond what is natively available. We invite anyone from the Sisense ecosystem to reach out and gains hands on access to trial this powerful tool on your own Sisense deployment, many 'AHA' moments guaranteed!Re: Scatter Map Color Break By
Hey MikeGre You will be able to achieve this by assigning an integer per each store brand, use that int in the color panel and like TriAnthony writes above, use MIN, MAX, or AVG functions on that field in the widget. You can then use a script to modify the legend's and map the INTs to text values of each store. Another option would be to test out our powerful QBeeQ Super Map plugin which allows to break by points color by text just like in your requirement and much more. We're also working on breaking down the points types by shape so you will be able to plot different layers of points, all in one view. This plugin is the ultimate map for any Geospatial analytics needs in Sisense. It incldues a territorial layer as well as points , and one can plot both on top of each other. It comes with a wide range of additional features like a robust tooltip, measure switchers, powerful exporting and more as below: Prebuilt Territorial Polygons: Quickly apply visualizations to pre-configured geographic areas like US states, counties, census tracts, EU countries, and UK regions, saving setup time. Custom Territories/Data Sets: Use custom geographic regions or datasets to tailor the map to your specific data and analytical needs. Map Bases: Choose from various map styles (street, bright, dark, satellite) to match your data and presentation preferences. Customizable Design: Customize polygons and points for clearer data representation and improved map effectiveness. Multi-Layer Presentation: Overlay multiple data layers to compare and analyze datasets simultaneously, revealing trends without switching between maps. Interactive Tooltips: Leverage jump-to-dashboard and click-to-filter functionality within tooltips to seamlessly explore data from the map. Customizable Tooltips: Incorporate relevant and contextual information for each polygon or point at a glance for deeper analysis Measure Switcher: Toggle between measures for both polygons and points, creating a wide range of mapping combinations Multi-select Lasso: Select irregular or non-contiguous areas, rather than being limited to predefined regions or boundaries Export Options: Export maps in multiple formats (PNG, PDF, SVG, JPEG) with customizable layout and resolution for easy sharing and presentation. Feel free to reach out if you'd like any assistance with that legend script, If you have any other questions don't hesitate to reach out, We're always here to help :) Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ newsRe: Table Usage Analytics
Hey sspringstead You’ve brought up a really important challenge, understanding which tables (especially custom ones) are actually in use across your Sisense instance is critical for keeping things lean, performant, and maintainable. This becomes even more urgent as data models grow and evolve over time. We ran into this exact issue with several customers, which is why we built an internal tool that’s now available as a plugin: Asset Auditor. Before I get into the details of what we have available, I will say that you can achieve this with some custom code and scripts, but this will need to be developed and then maintained. If you're interested in achieving this please see below While your request focuses on table usage, Asset Auditor actually covers that and much more: Table and Column Utilization – Easily see which tables and columns are actively used in widgets and dashboards, and which ones are not. Unused Data Models – Identify full ElastiCubes or data models that haven’t been queried in weeks/months. Custom Table Tracking – Get visibility into which custom SQL tables are in use and which are just slowing down your builds. Widget and Dashboard Errors – Surface broken or deprecated content before it impacts users. Plugin and Feature Usage – Understand which plugins or features are widely adopted and which are going unused. We’ve heard from admins that one of the biggest pain points is not having centralized visibility into what’s used and what’s just sitting idle, especially when preparing for server upgrades, debugging slow builds, or doing content cleanup. We're actually hosting a webinar on September 16th where we'll be showing Asset Auditor live and discussing how it helps BI teams reclaim control over their Sisense environments. Learn more about our webinar here Happy to share more details or answer questions here in the thread! We're always here to help Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ newsRe: Need Area chart for different locations
Hey Mitch_Rebelo You're right, the native Sisense Area Map widget currently only supports USA and World maps, and unfortunately doesn't include granular options for other countries out of the box. That said, there are a couple of good workarounds you might want to explore: 1. Community Custom Map Widget There’s a community-developed version of a custom map widget that allows you to use your own shape or GeoJSON files. With a bit of setup, you can load the regions you need (like states or counties from any country). 💡 Just note that these are community-supported and not officially maintained by Sisense, and some of them look quite outdated. https://community.sisense.com/kb/add-ons_and_plug-ins/geo-map---mapbox-gl/9078 Custom Map | Sisense Community https://community.sisense.com/kb/add-ons_and_plug-ins/custom-map-widget/9195 https://community.sisense.com/kb/add-ons_and_plug-ins/geo-map---mapbox-gl/9078 📍 2. Premium Marketplace Plugins If you’re looking for something more robust and fully supported, the Sisense Marketplace has some powerful 3rd party mapping plugins. One of them is QBeeQ Super Map, which we built specifically for Sisense users who need more advanced geographic visualizations. Without going into sales mode 😉, I’ll just say it’s packed with features like: Prebuilt polygons (US counties, EU countries, UK regions, etc.) Custom territories and multi-layered maps Measure switching, lasso selection, advanced tooltip actions, and more Export options for presentations Check out a full demo in this video You can find it on the Sisense Plugin Marketplace or reach out if you want help getting started. Hope this helps move your project forward! If you have any other questions don't hesitate to reach out, We're always here to help Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news Best, IdoRe: Trying to build headcount over time chart
Hey brocksowa Firstly, welcome to the Sisense Community and to working with Sisense :) To achieve this I would recommend creating a custom column in the Employee table that holds these various date fields, not in the date dim. The custom column should use a CSE/WHEN statement that creates a flag per your required condition and should look something like this: CASE WHEN Datediff([hire date] , [min date])<0 and (([termination date] IS NULL) or Datediff([termination date],[max date])>0) THEN 1 ELSE 0 END Note: you may need to change the conditions to be <> 0 depending on the required logic. Then in the front end dashboard formula editor you can use a measured value which basically allows one to filter a value in the formula level instead of the widget or dashboard level. The value of this measured value should count the Employee IDs while the filter should be the flag=1 of the custom column you created in the previous step. That way you will be counting only the employees which fall into your criteria. The formula should look something like this (Count(Employee_id),[filter to flag=1]) For more on Measured values, please see this article If the date fields are in different tables you may need a more complex custom column code or even a custom table expression. LMK if you'd any further clarification on that. If you have any other questions don't hesitate to reach out, We're always here to help Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ newsRe: How can I get the newer style of filters to behave like legacy filters?
Hey lring and Astroraf I believe this doesn't necessarily have to do with the new or legacy filters, rather the way the filters effect the widget. In each widget's design panel one can configure how the dashboard filters are to effect the values, either by 'Highlight' or 'Slice/Filter' Highlight will keep all values in the widget and only highlight the selected filter value, while 'Slice/Filter' will keep only the selected filter value and completely remove the others. See screenshot below. Give this a go and see if that does the trick, this may have been switched when you're version was upgraded and configured to use the new filter version. In any case, you can also revert back to the legacy filters.To revert to legacy filters in Sisense, you need to disable the newer default filter options within the Feature Management section of the Filter settings. Specifically, you need to turn off "Date / Time Filters", "Numeric Filters", and "Textual Filters". Here's how to revert to legacy filters as admin: Access Feature Management: Navigate to the Feature Management section within Sisense. Locate Filter Settings: Find the filter settings or section within Feature Management. Disable Default Filters: Turn off the following options: Date / Time Filters Numeric Filters Textual Filters Save Changes: Make sure to save the changes to apply the filter setting changes. By disabling these default filter options, you will effectively revert to the legacy filter behavior for those filter types. If you have any other questions don't hesitate to reach out, We're always here to help Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ newsRe: PDF Download Options
Hey c-arslanilyas I couldn't agree more and can confirm that as a Gold Sisense partner, we've heard this many times in the past. Sisense does have a few plugins and solutions for some of the items you mention, such as the Expand Pivot on PDFwhich improves picot PDF visibilty, or the Hide widget Row on PDF to remove complete widget rows from the exports. You can then distribute the PDF reports via the official Sisense Report Manager As Sisense are working on improving these features, we went ahead and created a full comprehensive solution for everything reporting and PDF related. Our QBeeQ PDF Report Design Studio allows viewers to completely design their own PDF exports, define which individual widgets are to be included in the report, move and resize widgets on the PDF page layout using a highly dynamic grid that includes page breaks, storing PDF templates for future use and much more. We also offer our PDF Break by Export plugin which allows to export a given report for multiple needs such as clients, by looping through a given dimension or filter and exporting these multiple reports in bulk instead of one by one. Feel free to reach out to learn more, you can test out a free trial to see how it works for your users, Ido from QBeeQ QBeeQ - Gold Sisense Partner info@qbeeq.io Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news
