Ido_QBeeQ
ETL
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ newsRe: Input Parameters using BloX for What-If Analysis
Thank you TriAnthony this is a super powerful implementation of blox! Great workaround using Blox for input parameters — it’s always impressive to see how far you can push blox capabilities with some clever scripting. For those looking for a no-code alternative, we’ve been maintaining a fully supported Input Parameters plugin for the past 4 years. It’s part of our broader effort to simplify self-service analytics and comes with a UI for design, built-in logic for advanced filtering, dynamic thresholds, and even support for string comparisons and parameter queries directly from the model (useful for left joins and similar cases). From reading through this thread above I am confident the plugin can answer all the requirements here. It's designed to reduce the amount of custom code and ongoing maintenance, and many Sisense users have adopted it as a scalable option. You can read more about it and how it fits into our self-service PowerUps here: 🔗 https://www.qbeeq.io/post/predictive-analysis-for-self-service-analytics 🔗 https://www.qbeeq.io/post/how-to-extend-self-service-analytics-in-sisense Happy to chat or share more if helpful. We're always here to help Ido from QBeeQ QBeeQ - Gold Sisense Partner [email protected] Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news!Re: Filtering causes rows where another value is blank to be filtered out
Hey Jake_Raz I am confident this has to do with the query at hand, as in your test when removing the dates it shows as expected. A few things I would try, Switch the widget type to a table widget instead of a pivot, the table widget doesn't group the values and may yield the expected results. By using the QBeeQ Input Parameters plugin, you would be effectively creating a LEFT JOIN when creating this formula, as the values will be dynamic and can be adjusted by the viewer or from a data table within the EC which does not need to be connected to the main schema (instead of the static 250k). We have many clients using this powerful plugin for this use case exactly. LMK if you'd like to try it out. This plugin allows for highly advanced filtering use cases on top of the powerful what-if analysis capabilities. LMK if this helps f you have any other questions don't hesitate to reach out, or if you'd like to meet and review together, let us know! We're always here to help Ido from QBeeQ QBeeQ - Gold Sisense Partner [email protected] Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ newsRe: How to Dynamically Switch Between Multiple Data Models in a Single Dashboard?
Hey gabrielladawn I believe what you're looking for is the Dynamic Elasticubes plugin, free and pre installed on Linux, Have look at the link below https://www.sisense.com/marketplace/add-on/dynamic-elasticubes/ If you need any assistance in setting it up or if we can further help in any way, please don't hesitate to reach out, we're always here to help. 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 [email protected] Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news
