Changelog

We’re finally a modern web app and have added the ability for admins to invite users to their Resplendent Portal.

There’s a new print button at the top right of the dashboard that lets users turn their dashboard into a PDF… or if they’re in the stone age, print the dashboard onto a piece of paper.

• We’ve greatly improved our authentication flow and security across the board.
• Quick enable in the modified dataset editor is disabled by default to prevent confusion.
• Modified Dataset previews show datetimes in the local timezone instead of UTC since mental conversion is hard.

• Improved error handling during the initial sync of a dataset.
• We’re now way more efficient when processing large datasets and can handle so much more data.
• Virtual column grouping is greatly improved performance-wise.
• Joined Datasets are more efficient on our backend, so you can get crazier with your joins.

• The products ConnectWise dataset now supports custom fields.
• The agreements ConnectWise dataset has access to the application units field.
• Applying a template turns on callbacks for ConnectWise datasets now, which means the data is more reliable.

• Table and matrix widgets have consistent column width.
• Various timezone-related bug fixes.

• Fixed some errors when deleting datasets tied to a ConnectWise callback.
• Creating a virtual column with the same name as another virtual column would wreak havoc. Now that’s fixed.

• Funnel chart! Useful for visualizing sales pipelines.
• You’ve heard of bar charts? Well, we’ve got the same thing but horizontal… Horizontal bar charts.

Added option on widgets to compare the current value to the value this time last period (aka compare to previous mode).

Here’s an example: If you have a widget that shows the tickets closed this month, you can enable Compare Mode and show on the same widget what last month was like and the percent difference between the two.

• New filter variable type that lets users add a search field to any widget. Useful for situations where you want to filter a widget or group of widgets by a column that contains many unique values like the summary on a ticket or the name of an invoice.
• There’s a new bulk filter editor in dashboard edit mode. The bulk filter lets users quickly edit the filters of widgets in bulk and change filters in one UI instead of switching between widgets.
• The between dates filter now has an option to set the start day of the week. If you start your weeks on Tuesday (Idk why you’d do that), now you can.
• There’s now a global date filter on the dashboards. It’s a convenient way to quickly filter a dashboard to a specific date or date range.

• Users can now pivot table widgets which is useful for getting more concise information from a massive dataset.
• Widget drilldowns can be ordered and limited

We’ve added a copy and paste feature to modified dataset functions so it’s easy to copy functionality from one modified dataset to another.

Excel integration upgrade to handle date columns automatically.

That is… to automatically handle Excel’s automatic handling of creating a date from every possible cell value.

• Fixed several issues with the ConnectWise callbacks that were causing bottlenecks in our data pipeline.
• When a ConnectWise schedule is updated, we now update the resources on the corresponding ticket. We have to go the extra mile because when you remove a resource on a ticket, it doesn’t count as an update to the ticket. We have no idea why this is the case, but you don’t have to worry about it now.

• Data pipeline optimizations.
• Improved the filtering efficiency of joined dataset filters.

• Copying a widget from one dashboard to another doesn’t add a “2” to the end of the widget name.
• Table and matrix widgets no longer scroll to the top when the data updates.
• Member users are not allowed to edit share links.
• Modified dataset editor got some UI love.

P.S. Yes, we know UX and UI are different and can’t always be lumped together as the same thing.

• Dataset Columns
  • Excel didn’t respect the columns selected in the dataset editor. Now it does.
• Virtual Columns
  • Virtual column row offsets are stay applied after editing.
  • Fixed the virtual column grouping mode. It was previously completely broken.
• Widget Columns
  • Copying a matrix widget no longer randomly orders the columns in the copied version.
  • Fixed an issue were users couldn’t pin the first column in a transposed table widget.
  • Opening the widget editor on a widget that’s using exclude mode on the column no longer resets the columns.

• The dynamic date range filter variable would show [Object object] at the top of the dashboard when applied. Now it shows the date range.
• Fixed an issue where the dashboard would scroll to the bottom when opening it.
• Removed some UI elements that shouldn’t show up when a user’s role is “Member”
• More bug fixes to audio playback on thresholds.

• Fixed a bug where joined datasets would error if one of the datasets being joined was empty.
• Fixes for the backup radar integration.
• Resolved Start and End calendar times on the ConnectWise Time Entries dataset not being correct.

• Widgets now have the option to add dollar signs and percent signs to the drilldown data. When a column is specified to include a sign on it, all values will have a percent or suffix sign.
• We’ve added a transpose tool to the modified dataset arsenal. Transposing a dataset can help see data horizontally on table widgets. We also added the transpose feature as an option in the widget so you don’t need to make a modified dataset to transpose data on a table widget.

• Filter Variables have a new date range mode. The date range mode lets users choose two columns from a dataset, start date and end date. Once the two columns are selected, each pair of dates in the dataset will become a date range to filter. This feature helps create filters for custom calendars.
• A new Truncate Date Time tool was added to the modified dataset tools. This tool lets users convert a column that contains a date and time and zero out seconds, minutes, hours, and days. Truncating time is helpful when trying to group data by time. For example, if I wanted to group all tickets entered by the hour, I could truncate the date entered column to zero out the minutes, then group by the date entered column.

• A beta of the backup radar integration was added.
• There is a new option on widgets to remove filler days on widgets using date and date time columns for the x-axis. For example, if the dataset doesn’t have any records on Sunday, we normally fill the point with 0 to keep all the days on the chart. Sometimes, you don’t want to see all of the days; you just want to see the trend. This option turns off the filling functionality.
• Horizontal Bar chart. Nuff said.

• Added the “source” and “campaign” columns to the opportunities dataset in the ConnectWise integration. It helps see where leads are generated and from which campaign they came.

• Improved the sharelink creation UI to be easy to use.
• Increased load time performance for dashboards.
• Filter variable application is much faster now.

• When importing data from databases, we now can convert number columns in the format of “yymmdd” to date columns.
• Improved color contrast for the drilldown data column titles.
• Setting global colors on a dashboard allows partial matches to labels to be made.

• Enhanced the template gallery cards to make it easier to find widget templates
• Added support for Safari 16.
• Organized the tools on the modified dataset editor into categories.
• The Excel integration can pull Excel files from SharePoint.

• Fixed a bug where Text widgets wouldn’t let you edit them after they were created.
• Fixed an issue where decimals would appear on number widgets even when decimal places were set to 0.
• Fixed a bug that caused widgets to load indefinitely after creating them.
• Data updates no longer overwrite the widget preview opened in the widget editor.

• Fixed several issues with the virtual primary key on the AS400 integration
• Solved bugs with the pivot modified dataset function.
• Many bug fixes and optimizations to our data processing pipeline.
• Some datasets weren’t continuing to sync after failing to sync several times. Now, if a dataset fails to sync, we’ll keep trying to sync it but progressively increase the time between syncs.

• Fixed the total value on stacked bar charts not honoring the theme color.
• Various fixes to the threshold UI for Matrix widgets.
• Sorting in the matrix widget is no longer broken.
• Date columns appear as dates instead of dates with time on table widgets.
• If a widget used a date column as the x-axis, the drilldown wasn’t splitting the data by day. Now it does.

• Fixed an error that was thrown when a filter view was copied.
• Various filter variable bugs taken care of.
• Fixed a bug that prevented users from being able to select the column order of widget drilldowns.
• Adjusting columns in the widget no longer requires the user to refresh the browser for the changes to take effect.

• Fixed issue where loading an existing integration connection would fail sometimes.
• The Google Sheets integration can now handle columns of data with JSON in them.

• Various template bugs were squashed
• Fixed audio not playing when a threshold was met.
• Fixed a bug where saving your profile picture would remove any dashboard groups assigned to you. Now you can get your glam on without consequence (in Resplendent Data).

Users can add thresholds to matrix widgets, allowing them to visualize when their numbers are missing goals.

• We’ve added an option to let users choose the first column’s name in the matrix widget. Instead of only being called “name,” the user can put any descriptive column name they’d like.
• We’ve added support for changing the date format in table and matrix widgets so that date columns can be more customized.

Users can add descriptions to a dashboard by going into edit mode on any dashboard and clicking the (i) info icon next to the dashboard’s title. The description supports markdown.

Added the charge codes dataset for the ConnectWise integration.

Applying templates is waaaaay faster. Went from 20+ seconds to under 5.

We can handle more date formats when importing data from other systems.

Added the project ID and name to the Time Entries dataset for the ConnectWise integration.

• Tons of performance improvements and optimizations
• Added various minor visual improvements to the modified datasets editor.

• Fixed a bug that prevented the “exclude mode” in the Fill NULL tool from being unchecked.
• Fixed a bug where some LionGard metrics had unsupported formats.
• Fixed a memory leak on the backend.
• Various Filter Variable fixes and improvements.
• More fixes for the widget threshold sounds.

• We’ve made the template gallery show all widgets on a dashboard so you can apply the template’s widgets individually instead of the whole dashboard.
• Added a tool to help you analyze data day-by-day. If you have data that shows when something starts and ends, this tool creates a row for each day in between.
• Users can add passwords to sharelinks to keep them private.
• Added Puerto Rico as a supported timezone (ya know, seeing as our HQ is there).

• Matrix widget has an option to show cells as blank instead of 0.
• Option to add threshold colors to the Matrix widget.
• We’ve added “mode” and “range” as computation methods for widgets.

• Added the ConnectWise Ticket Audit Log dataset so users can get more details on ticket history.
• Modified datasets can be used as a dataset in a joined dataset.
• We’ve finished the groundwork to support integrations with callbacks and are working on getting the “go ahead” from ConnectWise to enable it.
• We now support one of the most archaic databases, IBM DB2.
• Support to use multiple columns to create a primary key. This is useful when trying to pull in data from a database that doesn’t have a column with a unique key.
• Added support for multiple columns to be used as the join key in a joined dataset.

• Increased status dot performance.
• Performance upgrades to our backend.
• Can handle additional Liongard metrics.

• Logging out now navigates users to a dedicated logout page.
• We’ve added support for more data types that come from databases and integrations to make sure we can pull in more data from more integrations.
• The “Use Templates” button won’t show on integrations with no templates.
• Dynamic columns created from a pivoted modified dataset now appear in modifier tools after the pivot tool.

• Switching from a date column to a text column in the widget editor kept the text delimiter input as disabled. Now… it doesn’t.
• Fixed various bugs with sound thresholds playing at the wrong time.
• Fixed minor bugs with the matrix widget’s auto-column sizing.
• Fixed an issue where the drilldown colors were always gray regardless of the chart’s colors.
• Styling improvements for the widget editor.
• Improved styling of the widget documentation popover.
• The date x-axis only showed every other day. Now it shows every day if there’s enough space.
• Large tooltips would be hidden behind widgets in some cases.
• Custom calculations on widgets sometimes show errors when they shouldn’t have.

• Fixed various bugs with template application.
• Fixed minor issues with some Liongard metrics.
• Fixed a bug with ConnectWise time entries sometimes when returning information in some columns.
• Bug fix for an error that would show up when trying to add a new integration.

Widget Documentation: Added a documentation field in the widget editor that lets users describe what a widget is used for. It supports markdown, so the formatting sky is the limit.

• Added the Schedule Report dataset to the ConnectWise integration. It has more details that the base schedules dataset doesn’t have.
• We’ve released the beta version of the Liongard integration for users to start testing out.
• Added the Activities dataset to the ConnectWise integration.

When adding a filter variable to a widget, the dialog shows the active filter variables used by other widgets on the dashboard.

• Gave the rename column tool a makeover because it was UGLY.
• Tons of architecture improvements that enhance security and performance.

• Fixed the widget soundboard because it wasn’t working.
• Improved the column widths on the table widget. They would sometimes have inappropriate widths.

• Fixed an issue that wouldn’t let users apply templates if they had two of the same integration.
• Fixed an issue where dynamic filter variables added from a template wouldn’t tie to the correct dataset.
• Templates were taking a long time to load. No longer!

• Removed the global scroll bar that would show up for no reason.
• Resolved an issue where Coda and Excel wouldn’t sync after an initial sync.
• Fixed reverse alphabetical sorting on bar charts.
• Fixed an issue causing links set by modified datasets not to work.
• Columns coming in as lists are now converted to comma-separated lists.
• We can handle text columns being converted to booleans now.
• Fixed an issue where dataset options were ignoring default sync intervals
• Fixed an issue where staff users couldn’t see dashboards that weren’t added to a dashboard group.

• Added an exclude mode to the find and replace modified dataset tool. This lets users do a blanket find and replace across the whole dataset.
• New column rename tool in the modified datasets that lets users easily rename columns or virtual columns.
• Added lock flag to modified dataset tools applied by a template. Locking the tool prevents future applications of the template from overwriting it.
• The option to disable tools in a modified dataset. This is useful for testing different tools without having to delete them completely.
• Added modified dataset tool to fill null rows with the user’s desired value.
• Added filtering to joined datasets so users can filter them before joining.

• Custom calculations in the widget editor can now be filtered. A common use case is to divide the total tickets opened today by the total tickets closed today.
• Option in the widget editor to exclude columns in a widget instead of including them.
• New option to show the total above a stacked bar widget.
• Added option to limit values on matrix widgets.
• Added feature to select floating columns on table and matrix widgets so the selected columns are always visible while scrolling.

• We can mark integrations as private so only specific customers can access an integration. This is useful for custom integrations we’ve built specifically for clients that shouldn’t be publicly accessible.
• Our Google Sheets integration supports shared drives now.

• Upgraded to Angular 16
• Improved our updating process to make updates more seamless and stable.
• Made our subscription page more usable.
• When subtracting numbers, we made null values act as 0.

• To prevent confusion, the modified dataset preview now shows date times in the user’s timezone.
• We disabled the resync button on joined datasets since it didn’t do anything.
• Added the name of the connection for a dataset in the datasets table on the datasets page

Added change detection to ConnectWise Invoices so that when updated, the corresponding ConnectWise time entry is updated in Resplendent.

• Fixed an issue where bars in a bar widget would disappear when a threshold was applied, and the value of the var is a decimal between the upper and lower threshold.
• Fixed an issue where copying a widget would take a while.

• Fixed the ConnectWise Time Entries dataset so the hourly cost column isn’t always set to 0.
• Fixed an issue where the modified dataset preview randomly sends the columns in different orders.

• Minor bug fixes with the SmileBack integration.
• Fixed a bug where negative timestamps would cause an error when pulling data from MySQL.
• Fixed a bug where the filter variable tag at the top of the dashboard would stay even if no active filters were using the variable.
• Fixed some issues with Stemmons Quests.
• Fixed a bug where Google Sheets date time columns weren’t being formatted correctly.
• Fixed a bug where using a date column for the x-axis would format weirdly.
• Tons and tons of other bug fixes.

– Added project phases to the ConnectWise integration to have more in-depth tracking of projects

– The company team and company role datasets were added to the ConnectWise integration to give more information on team members in ConnectWise

– Users can remove the threshold number marker on the graph if there’s already a lot going on to help the chart feel less cluttered

– User can specify an x and y label to give more information on how the chart works

– Grouped data is sortable now

The opportunities ConnectWise dataset now includes custom fields

Advanced copying widgets now default to putting the copied widget in a new group.

General backend improvements & updates

– Labels would sometimes get cut off the top of the widgets

– Fixed custom calculation method not updating the widget preview when it was changed

– Fixed a bug where copying the columns from one widget to the other didn’t keep the order of the columns

– Overlaying the current value of a line chart on top of the line chart works now

– Bar chart y axis min not automatically set to 0

– Average calculation method no longer shows the count and average as two separate lines/bars

– Joined datasets now use the labels from the dataset if any have been applied

– Fixed an issues where the label of a dataset would show on the x axis of a bar chart if the value was 0

Single mode filter variables now always show one value currently active

Fixed threshold UI

Users can now use our pivot table modified dataset tool to pivot an existing dataset, which will help them transform their data into something more useful.

The audit log lets Admins see what dashboards have been accessed and records what widgets, dashboards, modified datasets, and datasets are updated.

Added product type dataset to ConnectWise. It gives more details on products.

The widget editor was given a major overhaul to make it easier to use.

• User can now group by another column in line and bar charts. This makes it a lot easier to create multiple lines or stacked bar charts to visualize categories within the data.
• We can show the difference between points on a line or bar chart to make it easier to quickly visualize how drastic a change was between data points.

Improvements to applying templates.

• Unions in join datasets don’t duplicate columns with the same name. So if a user is doing a union of the tickets and agreements table, there will be one company name column instead of two.
• Increased the number of rows a user can pull into a dataset from 500,000 to 5,000,000.
• Removing a column from a dataset also removes it from any joined dataset using it.
• Added product type id column to the products ConnectWise dataset.

• Fixed bug that caused bar charts with date x-axises to show dates off the edge of the chart.
  
• Bar and line charts would sometimes have their labels fall off the top of charts.

• Deleting a widget would throw an error.
  
• Resolved an issue where users couldn’t create new Static Value widgets.
  
• Mobile dashboard no longer puts the widgets in random order

• Join datasets would sometimes show an error notification.
• Links from modified datasets didn’t work.
• Resolved an issue where users couldn’t remove a dataset from a widget after the widget was saved.
• Changing dataset tabs in the widget editor would copy the filters of the first dataset to the next dataset, overwriting the original.
• Fixed some weird behavior in the dataset editor when filtering columns
• The Invoice Time Report ConnectWise dataset wasn’t working.

• Fixed an issue where numbers bigger than 1,000,000,000,000,000,000 would get cut off.
• Bug where the user couldn’t select an on-premise sync agent when using a database integration.
• Stemmons sometimes sends incorrect data when pulling data. We’ve implemented a fix to handle the data inconsistencies.
• Single filter variables would unselect after saving in a share link.

The widget editor has a new column selector dialog that makes adding and arranging the widget’s drill-down columns more intuitive.

The global search now lets users search by widgets, making it easier to find the data users are looking for faster.

Added a feature to pie and bar widgets that let users limit the number of pie slices or bars. This is useful for viewing the top 10 of a dataset.

• The single value filter variable now has an autocomplete input field.
• Users can select more than one single mode filter variable on share links.

Added a loading indicator when applying a template.

Hid some UI items that shouldn’t be viable to Member users.

Refreshing your browser while in the widget editor doesn’t take you out of the editor dialog.

Improvements for the Stemmons integration.

Increased the connection timeout for MySQL.

• Fixed a bug where the data stream label would get reset when opening the widget editor.
• Matrix widget index now respects selected filter variable values.
• Fixed autocomplete for the y-axis selector in the widget editor.
• Random widget editor fixes.

• Fixed some issues with the resolved date not getting set on the ConnectWise tickets dataset.
• Fixed some issues with data syncing when there were fewer rows in the source dataset than the batch pull size.
• Fixed some issues with Joined datasets getting custom labels mixed up.

Fixed various template issues.

When creating a share link, users can choose which variables show up in the link and then while using the share link, users can change which filter variables are active. Previously, users couldn’t change any filtering on a share link.

The dashboard group settings screen now shows all of the dashboards apart of the dashboard group and in the dashboard list, it shows which groups the dashboard is apart of.

Users can choose integration connection values as variables in drill down data links. This is useful if the user wants to add a link to a column in their data and wants to use the base URL of their integration connection.

Users can change the order of the datasets on a widget. This is useful for ordering the columns in a matrix widget or the way bars are stacked on bar widgets with more than one dataset.

The column links for ConnectWise datasets have been improved and have more columns with links automatically created.

The pricing page went through an overhaul.

Made our data processing more efficient and faster so we can handle more data.

Matrix widgets now have an export button.

Fixed an issue where the forgot password link wouldn’t work.

Solved a bug where loading a dashboard with filter variables wouldn’t show the current variables until hitting reply again.

Fixed a bug that prevented matrix widgets from loading on the initial load of a dashboard.

Resolved a bug in which the ConnectWise integration always pulled data in batches of 1000 during initial data ingest, regardless of the specified batch size.

Fixed a bug that didn’t update joined datasets when re-applying a template.

Our QuickBooks Online integration now supports the invoices dataset so users can track how much money they’re making (or losing).

Users can now change the source dataset for a modified dataset. This is useful if you’ve created a joined dataset that would better serve as the base for an existing modified dataset.

When deleting a Filter Variable, a dialog will show users which dashboards the variable is being used on so the variable isn’t accidentally deleted.

The Filter Variable chips on the dashboard now show more than one variable if multiple are selected, making it easier to see at a glance what filter variables are applied to the dashboard.

The user management list now shows the dashboard groups a user is a part of.

Email address on sign-up is no longer case sensitive.

Fixed an issue where stacked bars would get out of order if two datasets were applied to a widget with different date ranges filtered.

• Switching to full screen on a dashboard no longer removes the name of the dashboard from the browser tab.

• Fixed a bug where no dashboards would show if the user was on the second page of their dashboard list and then opened a folder.

Fixed a bug where user with the staff role couldn’t navigate to the data management page.

Dashboards show what filter variables are enabled at the top of the dashboard. This makes it easier for users to tell what filters are active without having to open the filter variable menu.

Log scaling is now on the y-axis. Log scaling makes showing two datasets on a single line chart easier when the data is largely different.

When deleting a dataset, we show which dynamic filter variables use the dataset before the dataset is deleted.

Fixed a bug that would duplicate the primary key of a joined dataset that was joined to another joined dataset.

• Fixed the reload button in the widget drilldown. There was an issue where clicking the reload button wouldn’t do anything.

• Fixed a bug where drilldowns wouldn’t work on widgets that a Filter View was filtering with a Filter Variable.

Improved behavior of stacked bar charts when there are null values.

When connecting an integration like Google Sheets or Excel Online, the user would get a 404 page.

Now users can organize their dashboards into folders. Folders can be nested into other folders. The biggest use case for the folders is helping sections of companies have folders of dashboards. For example, the sales team would have a sales dashboard with all of the sales related dashboards and then the operations team would have their folder with the operations dashboards.

We now have the ConnectWise Conversion History Dataset, which can be used to track opportunity history in ConnectWise.

We’ve made it so users can’t accidentally sync the same dataset more than once. This prevents extra load on our customers’ data sources and removes clutter from the datasets page.

Datasets and Modified Datasets have been broken out into separate pages. This helps with organization of where data is coming from and makes it easier for new users to understand the difference. It also makes it so functionality that is unique to Modified Datasets doesn’t show up as warnings on the Datasets page.

Now, drilldowns always load all data when users click on widgets.

Continued speed improvements to keep data updates fast.

Fixed an issue that would show double joined datasets as having a slow sync time on the dashboard.

We’ve introduced a new dashboard management feature called Dashboard Groups. Users can dashboards can be assigned to Dashboard Groups. Users can see any dashboards that are a part of their dashboard groups. If a dashboard isn’t assigned to a dashboard group, then the dashboard is considered public, and all users can see the dashboard. Admin can see all dashboards regardless of their group.

In the dashboard settings, users can set the font size of the widget titles. This lets users have more control over how they want to style the dashboard based on its use. For example, If a dashboard is meant to be on a TV screen to be easily read from far away, then increase the font size. If it’s a dashboard for use on a phone, then decrease the font size.

We’ve completely reworked our backend’s data warehouse and significantly increased our data processing speed. This will keep the app fast and data always up to date.

We can now detect when recent data has been deleted from ConnectWise and reflect the change on user dashboards

Made the x-axis on time series data more consistent

Fixed a bug where thresholds didn’t work on number widgets on the new dashboard look.

Users can now copy drill-down columns and their order from one widget to another. This makes it so users can set the desired columns they want to show up in the order they want when they click on a widget and then copy those selected columns to other widgets. A HUGE timesaver.

Our new chart look got a ton of feedback, and we’ve implemented the following changes and fixes:

• We dimmed the dotted lines behind bar charts
• Fixed an issue where dollar and percent signs weren’t showing up on charts
• Fixed the dynamic text widget
• Clicking on bars or pie slices opens the drill down in the correct tab
• Chart colors now honor the global colors

Clicking on number charts no longer shows the tab that takes up a ton of space on the left side of the drill-down. It makes it easier to see the data in the drill-down.

Made minor speed up improvements for putting the dashboard into and out of edit mode.

We’ve updated our charting library and it comes with huge improvements for visualizing data.

• We now have a gauge widget-type
• Bar charts can be grouped or stacked
• Bar charts have thresholds now
• Pie charts are actually useful
• The pie chart has a setting to convert the chart to a doughnut chart
• To start using the new charts, click the top left of the screen to change the dashboard to the new charts:

We’ve added the Survey and Service Item datasets to the ConnectWise integration. These datasets help users get more insight into ticket data. Surveys have information about how technicians did on a ticket and Service Items give more granular information about tickets.

The custom calculation mode on widgets now lets users get the count of distinct values in a column.

We added a new coat of paint to the app to give a cleaner look

In the widget editor, there is now a label on data stream tabs to make it easier to switch between them

There were several usability updates to the template gallery and applying templates

Threshold sounds work on shared dashboards now. Previously, there was a bug that prevented shared dashboards from playing a sound when a threshold was met.

Fixed a bug that had the filter variables randomly switching themselves on and off, which made the use of filter variables very confusing

Filter variables allow the users to set dynamic values on widget filters

When users save a widget, only that widget refreshes instead of all of the widgets on the dashboard. This makes it so saving widgets is faster.

Fixed an issue where setting the timezone for a column in the dataset editor would sometimes freeze the editor momentarily.

Fixed some bugs with data pulling in the MySQL and ConnectWise integrations

Resolved a bug that didn’t let users change their timezone after it was already set.

• Filter Variables can be assigned time spans so that users can dynamically filter by time intervals
• More than 50 values can now be assigned to Filter Variables
• “Between dates” filtering now lets the user specify the start and end of the day that the filter starts on

Custom field support was added to the Stemmons API

Added the QuickBooks Online API

The data processing engine was completely reworked to increase performance as we scale

Deleting data streams now shows what dashboard each affected widget is tied to

The Matrix Widget’s drilldown works now

Reduced load times for loading dashboards

Templates received a ton of bug fixes

Fixed autocomplete inputs sometimes not doing anything when pressing the enter key

This update introduces a new feature where enabled filter variables are now visibly displayed in the widget variable indicator. This enhancement provides users with a clearer understanding of the active filters applied to their data, making data analysis more transparent and efficient.

The data processing capabilities of Resplendent Data have been optimized for greater efficiency. This behind-the-scenes improvement means faster data handling and smoother user interactions, ensuring a more responsive and seamless experience when working with large datasets.

A significant improvement in this release is the implementation of user-specific active filter views on dashboards. Now, when a user makes changes to a dashboard, it does not reset or refresh other users’ active filter views, allowing for a more personalized and uninterrupted workflow.

This update addresses a critical bug where widget drill-downs would malfunction if the widget was a bar type and one of the bars lacked data. This fix ensures that all widget types function correctly, regardless of the data presence.

Previously, shared links occasionally failed to display filter variables. This bug has been fixed, ensuring that shared links now consistently display all relevant filter variables, enhancing the accuracy and reliability of shared data insights.

An issue where filter variables would not remain applied after refreshing the screen has been resolved. Users can now expect a more consistent experience, with filters staying in place even after a screen refresh.

The threshold sound notifications have been updated to respect the set repeat intervals. This fix enhances the functionality of auditory alerts, making them more reliable and in line with user settings.

Navigating through extensive data is simpler than ever. When you click on a chart with over 500 rows, you now have the option to load ALL the data in the drilldown, providing a comprehensive view without the typical restrictions.

Your workflow just got more efficient! You can now sync your Coda docs directly with Resplendent, allowing seamless data transfer and enabling you to showcase this data on your dashboards effortlessly.

We’ve added more depth to your custom widget functionalities. Now, you can perform a direct count of rows in your data stream, making data summarization and trend identification faster and more accessible.

Our ConnectWise integration is now richer, with added support for custom fields in multiple datasets including time, agreements, projects, companies, and contacts. Furthermore, we’re introducing the timesheet dataset, broadening the scope of data you can analyze.

Gain a clearer view of your data adjustments with our enhanced preview feature in the ‘find and replace’ modifier. It now specifies what column is being replaced with what value, removing guesswork and enhancing accuracy in data manipulation.

In our commitment to ensuring a smooth and intuitive experience, we’ve addressed several bugs, including:

• Fixing the erratic behavior when the primary key and ordering key were the same in database connections.

• Rectifying the issue that prevented the copying of joined datasets.

• Resolving an error caused by setting default filter variables to all variables.

• Enhancing the UI of the joined dataset editor for a better user experience.

• Ensuring that updates on base dataset links are reflected on the joined dataset links.

• Addressing data type inconsistencies in joined datasets, particularly when all values were NULL.

• Making sure that default filter variables remain consistently applied.

In our quest to enhance your data manipulation capabilities, the Modified Dataset editor has evolved. Users can now select multiple columns for aggregation in their datasets. This advancement provides a more nuanced approach to grouping data, thereby allowing for more complex and rich data analysis.

Creating templates is now more robust than ever! We’ve fine-tuned the process, enhancing stability and reliability. This improvement means less time troubleshooting and more time producing impactful, creative data visualizations.

We understand that real-time data changes are crucial to your decision-making processes. Thus, we’ve bolstered the connection stability between widgets and data updates on dashboards. This enhancement means you’re always looking at the most current and reliable data.

Our dedication to creating a seamless user experience has led to several bug fixes, including:

• Correcting the issue causing the dataset rows-to-pull dropdown to reset post-options menu navigation.

• Resolving the glitch preventing the share link dialog from saving changes to filter variables.

• Addressing multiple bugs related to filter variables, enhancing their stability and functionality.

• Fixing the handling of null values in virtual columns to prevent errors when dividing by zero.

• Eliminating a bug that incorrectly flagged excessive rows in the drilldown view on widgets.

• Addressing the challenge with column labeling in Unions within the Join Dataset editor.

• Resolving the bug that incorrectly converted non-dates to dates in drilldown tabs.

• Correcting the issue preventing the drilldown tabs from categorizing correctly without the x-axis column.

• Rectifying the slight off-center alignment of the dashboard grid during editing.

Each of these fixes contributes to a smoother, more reliable user journey, from dataset manipulation to dashboard visualization.

Users can now export data from table widgets directly to a CSV file, making it easier to manage and analyze your data offline or in other platforms.

We have added an experimental UNION ALL option to the join dataset page for those looking to combine datasets seamlessly. This feature is in its experimental phase and we welcome your feedback on its functionality and utility.

Users now have the ability to pull more rows for their data streams, even when opting for smaller batch sizes. This enhancement is aimed at providing more flexibility and control over data retrieval and visualization.

We’ve refined the widget drill-down tabs—they are now in alphabetical order and format dates properly, making navigation and data reading more intuitive and user-friendly.

We’ve fixed a bug where clicking the share button on the all dashboard list would navigate users to a 404 page.

New users can now see the option to join datasets. This bug has been fixed to ensure everyone can fully leverage the platform’s capabilities.

The charts no longer alter colors randomly, providing a more coherent and reliable visual representation of your data.

If you’re using a filter variable on a widget, we now show the correctly filtered version of the data in the drill down.

We’ve resolved an issue where the Find and Replace modifier wasn’t filtering NULL values from its results.

Setting the theme for a dashboard share link now actually sets the theme, eliminating any mismatch and ensuring consistency.

The delete button is now visible in the join datasets page when a dataset hasn’t been chosen, smoothing out the user interface experience.

We’ve fixed a bug where share links would start sending invalid requests if the dashboard lost connection to the backend for a few seconds.

Our Advanced Filter Value UI has been rejuvenated, combining visual appeal with functional excellence, making your navigation experience smoother and more intuitive.

The Joined Datasets feature has been upgraded, opening the doors to upcoming sophisticated functionalities designed to boost your data manipulation prowess.

We’ve refined the dashboard copying process, ensuring every element is perfectly aligned and meets your expectations.

Any inconsistencies in our Dashboard Templating System have been ironed out, establishing a stable and reliable environment for creating your templates.

The process of renaming Sync Agents is now seamless and free of errors, with the resolution of the disrupting bug.

• Two Mode: Filter variables now sport both ‘Multi’ and ‘Single’ modes. ‘Multi’ lets users activate multiple values for a single variable on a dashboard. With the ‘Single’ mode, users will benefit from a streamlined dropdown menu, allowing the selection of just one value for a filter variable.

• Global Defaults for Admins and Staff: Now, admins and staff users can set a universal default for filter variables. This default will be automatically applied for all users on a particular dashboard. However, individual users retain the flexibility to modify their active variables and can always reset to the default if necessary.

Time zones can often complicate data interpretation. With the new global timezone setting for Modified Datasets, you can ensure that your time-related tasks and computations, like calculating the business hours between two dates, are precise and consistent.

We’ve refined the filtered timespan advanced value, offering a more reliable and efficient experience.

To make navigation smoother, single select variables are now prioritized at the top. Moreover, the values within filter variables are sorted alphabetically, streamlining the selection process.

• Resolved an issue where saving a dashboard redirected some sharelink users to a 404 page.

• Addressed a bug that displayed filter variables even after their removal from all associated widgets and filter views on a dashboard.

• Fixed a glitch which occasionally made filter variables vanish from the filter variable config after adding the variable to a filter on the dashboard.

Calculating time deltas between dates is now easier than ever with the addition of a new advanced value to virtual columns. This helps users to compute the time span (in weeks, days, hours, or minutes) over a filter on a widget. The application of this feature will be significant in understanding the time-related dynamics of your data.

To increase the clarity of the impact of filter variables, we’ve added an indicator that will show whenever a widget is being affected by the filter variables. This ensures better visibility and understanding of your filter variables at work.

As always, improving stability and fixing bugs are top priorities. In this update, we’ve managed to tackle several important issues:

• Resolved a bug that prevented filter views from showing up in the share link creator.

• Fixed the issue that made saving share links break.

• Corrected a bug that stopped filter variables from deactivating when a filter view was changed.

• Addressed some visual inconsistencies on the profile and search screen.

• Solved a problem that prevented SmileBack data from refreshing.

• Along with these, various other minor bugs were fixed to enhance your overall experience.

Our widgets now include a percentage calculation type, enabling users to quickly ascertain the percent of rows that match a specific filter. This new function enhances data visualization and empowers users to make informed decisions.

We’re making progress in our templates feature and are on the brink of releasing it. Stay tuned for this powerful addition that will further simplify dashboard creation and customization.

Filter Variables have been upgraded! They now support all comparison types, not just equals, adding flexibility to your dashboard interaction. Plus, Filter Variables can be assigned to share links, enabling you to share specific data sets with others based on selected filters.

Ever needed to break down a comma-separated column into individual rows? Our new explosion function lets you do just that. With this, computations on individual values become a breeze.

With user experience at the forefront, we’ve made vital enhancements to the dataset editor, simplifying data manipulation and boosting efficiency.

We’ve refined the storage methods of filter variables to ensure smooth operation and easier management.

We believe in a clean, bug-free environment, and in this update, we’ve addressed several issues:

• Fixed a bug causing the deletion of data streams to get stuck in a loading state.

• Resolved an issue that made charts not show when changing filter variables.

• Addressed a problem affecting the joined datasets upon deletion of the secondary dataset.

• Eliminated several minor but pesky bugs.

Taking dynamic customization to a new level, we’ve introduced Dynamic Filter Variables. This feature allows you to create a variable, assign values to it, and then attach this variable to filters in a widget or Filter View. This means you can dynamically change what values are active on your dashboard with ease using the new Filter Variable configuration menu. This feature is still in beta and may have some issues, but rest assured that we’ll have them worked out with the coming updates.

For those who display their dashboards on kiosks or other standalone displays, you can now add the query parameter “fullScreen=true” to make the dashboard appear in full-screen mode. This ensures your dashboards maintain their full-screen appearance even after a refresh.

We’ve added the ‘licenseClass’ column to our ConnectWise members dataset, offering further insights into your team’s capabilities.

We noticed that loading dashboards on sharelinks was causing timeouts for table widgets. We’ve optimized this process significantly to make the experience smoother and faster.

Our menu tables across the UI have undergone a facelift. We’ve made more space and optimized layouts, making the tables easier to navigate and work with.

We’ve fixed a bug that was preventing existing datasets from being saved under certain circumstances.

We fixed a bug that hid virtual columns on a widget if the modified dataset, from which the virtual column originates, had been saved multiple times without ever being assigned to a widget.

We fixed an issue where the grid would expand on the x-axis in edit mode, allowing widgets to be placed outside the dashboard.

We’ve addressed a bug where the password recovery screen would break when a user hit the enter key.

We’re launching a feature that allows users to compute columns together directly in the widget, thereby giving you even more control over how your data is presented. Keep an eye out for an upcoming tutorial on how to best utilize this powerful new feature!

If you change the name of a virtual column in a modified dataset, the column name is now automatically updated in all widgets that use the virtual column. This streamlines your workflow and ensures consistency across your datasets.v

We’re handing more power over to your team members! Users with member-level permission can now change filter views on a dashboard.

While the widget editor is open, we now unsubscribe to data changes. This prevents unexpected changes and ensures you have a smooth editing experience.

We’ve optimized the dashboard loading process, resulting in dashboards loading much faster. Quicker access to your dashboards means quicker insights!

We’ve fixed several UI bugs associated with the new virtual column UI for a seamless user experience.

A bug causing Smileback to reset data after several syncs has been fixed.

Fixed a bug that wasn’t unsubscribing data when leaving a dashboard, ensuring your dashboard data stays as expected.

Great news for users of our ConnectWise integration! We’ve added a new dataset called ‘purchase orders,’ which will allow you to pull purchase order data directly from ConnectWise. This new addition will provide more comprehensive data for your analysis.

We’ve worked on our data processing functions and made them more efficient. In some cases, they’re now more than twice as fast! This means you’ll get your insights even quicker.

For widgets that use a delimiter, such as a comma, the filtering process has been improved. It now works on the delimited data instead of the whole column that’s being delimited. This fine-tuning allows for more precise data selection.

We’re also excited to announce that we’ve made some under-the-hood upgrades to our templates. We are preparing them for common use, and an ETA will be announced soon. Stay tuned!

We’ve fixed a bug that caused layout disruption when copying widgets from one dashboard to another. Now, the widget placement will remain consistent.

We’ve addressed some issues related to the custom calculation column to ensure its reliable functionality.

We fixed a bug that made no columns selectable in a widget after copying a data stream setup. Now, columns will be available without needing to close and reopen the widget.

We fixed an issue with the ‘only business days’ calculation in virtual columns that caused values to go negative when the difference between two values was less than a day.

We addressed a bug that caused clicking on a bar in a chart to open the incorrect tab in the drilldown.

You now have the ability to create a custom column within your widgets! By choosing a calculation type such as Sum, Average, Median, Min, or Max, and then toggling the custom column feature, you can combine columns to create a single value. This functionality lets you, for instance, multiply a decimal column by 100 to get the percentage value.

We’ve expanded the available columns in the Resplendent Tickets View dataset to include Detail Notes, Internal Notes, Resolution Notes, and Has Resolution Note.

We’ve boosted the speed of our widget editor, making quick edits smoother and reducing the risk of freezing.

The “No X-Axis” button has been renamed to “Use Data Stream Label,” better clarifying its function.

We’ve carried out a significant overhaul of the virtual column UI to make it more compact and user-friendly.

We’ve corrected an issue that was preventing a modified dataset from being saved if it didn’t have a widget assigned to it.

A bug that turned the widget data status dot black if a widget was missing some configurations has been fixed.

We fixed a bug where creating a new widget prevented users from selecting columns.

We’ve addressed a bug where standard line charts without data labels enabled would show the leading dot on the back of the line instead of the front.

We’ve fixed an issue where copying a data stream in a widget would prevent users from selecting columns on the copied version of the data stream.

To enhance the user experience, we’ve introduced an icon on widgets that indicates when they’re displaying preview data. This icon appears after a widget or a modified dataset is saved, providing immediate clarity about the status of the data being viewed.

To boost platform stability, we’ve made minor yet essential improvements to our templating system, ensuring its efficiency and ease of use.

Addressing an important usability issue, we’ve fixed a bug that caused a delay in widget rendering until data was refreshed. Now, widgets will render immediately for smoother visualization.

We’ve tackled a bug that incorrectly prompted users to sign in when accessing shared links following a dashboard edit and save. This fix ensures uninterrupted data sharing and collaboration.

Line widgets now include an option to overlay the most recent value on top of the chart. This is particularly useful when you want to focus on the latest data point while still maintaining historical context.

We’ve added a full-screen mode that hides the header and sidebar, enabling you to view your dashboard without any distractions.

Drilldowns now support dates. When you click on a point in a line chart, the drilldown will filter the data to only show data within the time window of that point.

To better serve you, we’ve added a feedback button in the header. You can provide feedback on any screen, and we’ll receive logs of any issues leading up to the point of your feedback.

Now, after saving a widget or modified dataset, you won’t have to wait for another sync for the data to be available. The data will be reprocessed immediately with the new filters.

Collapsing the sidebar while viewing a dashboard now resizes the dashboard to fully utilize the available space.

We fixed an issue where number widgets with thresholds only triggered the threshold if the value exceeded it. Now, the threshold will be triggered when the value of the widget meets the threshold.

Fixed a bug in the action tables on the All Dashboards and Data Streams page. Previously, searching after switching to the second page of the table would cause the table to malfunction.

We’ve resolved some issues with our bug tracking to make the process more efficient.

We’ve introduced an option that allows you to prevent a widget from being muted.

For easier filter creation, column names are now sorted alphabetically, and users can search columns within advanced filters.

We’re proud to announce that we’re now officially registered and verified with Google for our Google Sheets integration.

Users can now opt to sort bar and pie charts alphabetically by their labels.

Advanced copying for widgets now defaults to copying to a new dashboard for better organization.

We’ve fixed a bug that caused table widget data to disappear randomly.

Fixed a bug that prevented the first x-axis label on time-based charts from displaying.

Addressed a data processing bug in our large data processing backend.

Fixed a bug that was preventing snapshot widgets from showing an x-axis in certain circumstances.

We’ve fixed the global search function and re-added it to the header menu.

We’ve resolved some bugs with the conditional links in the modified datasets.

We’ve added Opportunities and Sales Order reports to our available ConnectWise datasets.

When using a snapshot widget with daily time increments, choose which hour it takes the snapshot in the day.

We’ve updated the process for downgrading subscriptions for smoother transitions.

For smaller widgets, all action buttons in edit mode are now placed inside the menu to prevent cut-offs.

Filter views now maintain their positions during renaming for more consistent navigation.

The mute button now only appears on widgets that have a sound selected, and the snooze button only displays when a widget is playing sound.

We’ve clarified the radio buttons for selecting when a sound is played to say “Greater than or equal”/”Less than or equal.”

Added padding around link widgets in edit mode, making them easier to resize and move.

Now, when applying a template, the template will use existing datasets instead of duplicating them.

We’ve streamlined the process of creating templates for our template makers.

Fixed a bug that prevented widget sync dots from turning green if a widget was based on a Joined Dataset and was set to a 5-minute interval.

Initial saves of any dataset now properly save the selected data types for columns.

Fixed an issue where the notification wouldn’t dismiss if the initial sync pulled in less data than the selected batch pull size.

Users can now link and sync any online Excel worksheet to their dashboard.

Added a select all/deselect all feature to several multi-select dropdowns throughout the UI.

Users can now set another column’s link depending on the value in a column.

Line and bar widgets now support a time increment of a Quarter.

We’ve updated the backend process for virtual columns, enhancing their reliability.

Completely overhauled our OAuth2 handler for improved reliability with OAuth2-based integrations and faster development for new ones. Our current OAuth2 integrations include Microsoft Excel, Google Sheets, and SmileBack.

Fixed some issues with the templates, and we continue to test this feature for further improvements.

Fixed a bug in Joined Datasets that caused links to point to the wrong columns when more than one dataset in the Joined Dataset had links.

Fixed a bug that would break filters if the copy button was used.

Added the contact ID to enable joining the Resplendent Tickets Dataset with the ConnectWise Contacts dataset.

• min_to_respond_goal

• min_to_resplan_goal

• min_to_resolve_goal

• percent_of_respond_goal

• percent_of_resplan_goal

• percent_of_resolve_goal

These fields will help users monitor how close SLAs are to being breached on any given ticket.

Implemented small performance boosts in data processing.

Added a feature that checks for new data pulled from a given data source. If no new data is detected, re-processing will not occur for up to 5 minutes, after which a forced re-process will happen.

Resolved an issue with selecting time increments greater than a day, which caused improper data point display.

Fixed a bug that prevented users from comparing number-based columns to a NULL value.

Addressed a bug where only the first column with a duplicate name in a joined dataset would get a link. Now, all links in a joined dataset point to the correct columns.

Fixed an issue that prevented users from changing the value column after the widget was saved.

Resolved a bug where the syncing notification would get stuck if a dataset didn’t support pulling old batches of data.

• Users can now upload their own .wav sound files to their accounts.

• Sound files can be assigned to specific widget thresholds.

• Users can choose whether the sound plays once when the threshold is hit exactly, or when the data is above or below the threshold.

• Optionally, the sound can be set to play on repeat until the threshold is no longer met.

Enhanced stability and performance of Joined datasets, making it easier to combine and analyze data from various sources.

Fixed several bugs related to our Joined datasets feature, ensuring a smoother and more reliable experience for our users.

Implemented various minor bug fixes, further enhancing the overall performance and user experience of the platform.