A bar or column chart without a category having multiple values still group values over a category
Have a Bar or Column chart with multiple values, and without a field on Categories. Note the position of the bars as though there were a field on Categories while still listing the Value title on the axis. For example, in the Sample ECommerse widget, the United States value bar is above the axis label, the United Kingdom bar is centered with its axis label, and the Australia bar is positioned below its axis label. The bars are also positioned and narrowed to leave space for all values over each value. But never will more than one value render over any given axis label. Add Age Range or something on Categories and note the grouping of the values as expected. What I would expect in the first scenario without a field on Categories is what I experience in Sisense on Windows. Each value is aligned with its axis label. The bars are also thicker because they are not reserving space for two other bars over each label.27Views3likes0CommentsCreate New Sample Data Sets with more data and more concurrent date ranges
Create a new sample data sets that have a lot more data, date ranges that are current to our dates today, has more scenarios that we see in all customers cases. Like more complex formula creations, displaying a wide range of different KPI's, have a more complex data model to show how dimensions and fact tables can work. Having a sample data set with custom code, custom tables, and custom column. Having one of the tables connect to a DW to show how the connection works as well.10Views0likes0CommentsImproved Date Range Reporting
With the recent bug fix for the "continuous timeline" option in 25.2, date range reporting is now workable for many widgets. However, there are a number of limitations that should work based on the existing features and UI. I have a couple of suggestions that are based on feedback from many Sisense users: 1. Applying a date range filter to a widget with the “continuous timeline” and “display missing values as zeros” options enabled truncates data that should still be within the range of the widget filter. For example, if I want to see costs over time from 2025 to 2035 (date filter), dates that do not have values are missing from the chart. If I remove the filter those same dates will appear with "$0" set as the value. Presumably this should not be the case if “display missing values as zeros” is enabled. Note: in this example case the widget contains fields that are from the same table, including the date field. 2. It is not possible to select “continuous timeline” and “display missing values as zeros” in pivot tables. But many users want to see the same data there as they can in other widgets. I.e. they want a date range with data for every data in that range, even if it is 0 or null. Suggestion #1 ties directly into this one, as users would want to set a custom date range filter that shows data across that range.73Views2likes2Commentsdynamically sort pivot columns based on values
Right now if I have a pivot table showing revenue and the rows have the customer name and the columns show the product name the product names will only appear in alphabetical order regardless of the revenue value of that product. The columns should be able to be sorted dynamically based on the value of the revenue or whatever metric is included.10Views0likes0CommentsAllow text wrap for column / bar chart category titles
Since L2025.3, the algorithm for how ‘long’ category labels are handled in column / bar charts has been adjusted. These used to wrap as needed (and have a fairly long character string limit), but the wrapping feature has seemingly been removed completely in L2025.3. The result of this is text that would previously display fine is now overly-truncated. I thought this might have been a bug, but support are saying this is intentional. If the aggressiveness of this truncation algorithm is not going to be reviewed, please can we have the option to enable / disable text wrapping with the old character limit. I have attached an image showing the old vs. new behaviour.22Views2likes0CommentsTable Usage Analytics
I think table and custom table usage should be added to the scope of usage analytics. I have large data sources that have been around for many years. Often dashboards are unused (which I can currently track with usage analytics) and can be deleted or archived. But the data that drives them is much harder to keep track of. I have no way of knowing which tables are used in dashboards and which ones could be removed. This is especially true for custom tables that eat up build time and might not be used at all.535Views3likes2CommentsOR filter inside a formula
I'm trying to modify a formula in my dashboard that currently uses multiple fields as filters inside an RSUM() aggregation. My goal is to apply OR logic across these fields rather than the default AND logic imposed by comma separation. Here is the original formula: RSUM([# of unique INCIDENT_ID], [activity type], [activity type1], [activity type2], [activity comment], [activity comment1], [_NUMBER], [_NUMBER1], [activity type3], [time to resolve (mins)], [ASSIGNED_TO]) As I understand, the commas between the fields act as AND conditions. I attempted to change the commas to use OR, but received a syntax error. I want to apply OR conditions across these fields, so that if any one of them meets a specific value or condition, the row will be included in the aggregation.22Views0likes3Comments