SPJS Charts for SharePoint v7: Change log

SPJS Charts v7.0.1.19 (November 10, 2023)

  • Fixed a bug where if you filtered a stacked chart and had formatters configured for multiple columns you could get an error in yellow above the chart like this:
    The format column index [index] exceeds the number of numeric columns ([number or columns])
  • Updated the included jQuery version to v3.7.1.

SPJS Charts v7.0.1.18 (November 14, 2021)

  • Fixed a bug with custom date format (set in the Options tab) when using drilldown on a DateTime column.

SPJS Charts v7.0.1.17 (October 07, 2021)

  • Fixed a bug related to using a number (Currency, Number or Counter) as filter on a chart.

SPJS Charts v7.0.1.16 (September 28, 2021)

  • Included Note field as selectable.
  • Fixed an issue with boolean fields in a table chart where both true and false values were shown with the tick for “true”. If they were displayed as string the true and false value were shown correctly. This did not affect the table chart if you used a CAML query in the filters tab.

SPJS Charts v7.0.1.10 (April 29, 2021)

  • Fixed a bug throwing an error “b.getTimezoneOffset is not a function” when trying to show a table chart with a date field formatted as date and where some items in the list don’t have a value in this date field.

SPJS Charts v7.0.1.9 (January 07, 2021)

  • Fixed a problem where using single quote in a chart filter option will result in no items being shown in the chart.

SPJS Charts v7.0.1.8 (November 25, 2020)

  • Fixed a few typos in various help texts.
  • Added some new features in the DashboardSelectorAndBuilder.html to support using the Modern CEWP and also let you link directly to one specific dash. Click the Edit button to copy the link. You can also add a a code snippet to the page (in a Content Editor Web Part, script editor web part or using the Modern CEWP) like this to control the loading of one specific dashboard like this:
    <script>
    var defaultSPJSChartsDashID = 25;
    var hideSPJSChartsDashSelector = true;
    var hideSPJSChartsDashEditBtn = true;
    </script>
    In this example the number 25 refers to the item ID in the list “SPJSChartDashboards”.

SPJS Charts v7.0.1.5 (September 29, 2020)

  • Added more options to control the format of the totals row in a table chart by adding percentage and decimals as possible parameters.
  • Added a new namespace jQspjs for jQuery by using jQspjs = jQuery.noConflict() to avoid problems when another third party solution loads jQuery after the charts have been initiated.
  • Added support for using an array of strings in the “selectedValue” parameter in the “Filter above the chart” setup.

SPJS Charts v7.0.1.4 (September 15, 2020)

  • Added support for drilldown on single choice user and lookup fields.
  • Added support for substitute when using drilldown.
  • Added support for substitute on multichoice values using advancedsubstitute.
  • Added support for using multichoice fields as filter.
  • Fixed a problem with refreshing the FormDigest (login token) on office 365 when you had the edit chart open for a long time and the login token had expired before you tried to save the chart.
  • Added more control over the totals row for table charts by adding custom styling and possibility to change from the default sum to average or count. You find these new settings in the Options tab under Show totals.

SPJS Charts v7.0.1.2 (April 13, 2020)

  • Fixed a problem with getting the list view CAML query for some list views with “get CAML from list view” in the Filter tab.
  • Fixed a problem with using drilldown on a custom datasource (Basic setup > Datasource > Custom datasource).

SPJS Charts v7.0.1.0 (September 08, 2019)

  • Fixed an error with the language translation detection in the SPJSCharts_loader.html that caused the solution trying to load the translation for the selected locale even if it was not actually added to the /i18n folder.
  • Added support for loading the charts in a modern page using the Modern CEWP: https://spjsblog.com/modern-cewp
  • Sankey charts are unfortunately not available in modern pages because the Google Charts Loader fails to load the Sankey script (requre.js built into SharePoint Online triggers an error).

SPJS Charts v7.0.0.16 (July 27, 2019)

  • Fixed a bug where you could not use Transpose chart initially in combination with filter.
  • Fixed an issue where the transposing of the chart would be reset to the default orientation when changing filter.
  • Split the translations into separate files and added them to a folder named /Charts_v7/i18n.
  • Changed the colorByLabel option to first search for exact matching labels, and if no match were found it will then try searching for beginswith.

v7.0.0.14 (December 28, 2018)

  • Fixed an issue where if you entered edit mode and immediately clicked “Cancel” would get an error message.
  • Added support for using {url:key} in the Optional filter textarea in the Filters tab. You can use it to pull down a URL parameter to use as initial filter. Look at the help icon in the chart configuration to see an example.
  • Added support for using {url:key} to set the selectedValue in the Filters above the chart setting in the Filters tab. Look at the help icon in the chart configuration to see an example.

v7.0.0.11 (December 10, 2018)

  • Fixed a bug with calculating the baseUrl of the chart that sometimes occurs when using a manged path.
  • Fixed a bug related to using lookup columns or “additional fields” selected on a lookup column as filter of a chart.

v7.0.0.9 (September 30, 2018)

  • Fixed a bug related to using lookup columns in a chart.

v7.0.0.8 (September 20, 2018)

  • Fixed so using the substitute function will also substitute the values when using the field as filter for the chart.
  • Fixed a bug related to fields starting with _ when using REST query (REST is used when you don’t use a CAML query as filter.
  • Added basic support for using variables instead of the JSON translation format. Use this format to use variables in all the places where you can use JSON:
    {var:name_of_variable}

v7.0.0.7 (September 16, 2018)

  • Fixed a bug related to the use of  Substitute string values in datatable in the Group, sort and substitute tab.

v7.0.0.6 (August 22, 2018)

  • Fixed a bug related to validating the password set on the chart in the Restrict access section in the Options tab.

v7.0.0.5 (August 06, 2018)

  • Added a Year modifier to the Group, sort and substitute section to group a date column by the year.
  • Added support for using a Count related lookup column in a chart.
  • Fixed an error with the Restrict edit chart access to select in the Options tab. The selected value would save with the chart and work as intended, but when editing the chart, the selected value would be removed.
  • Fixed an issue where the menu items for Convert to image, Convert to table and Copy to clipboard would not show for users not having edit access to the chart.

v7.0.0.2 (July 06, 2018)

  • Fixed a bug that caused the solution to fail to load when used on the root site of a SiteCollection.
  • Fixed a bug that caused the root site of a site collection to not show as a selectable web when configuring a chart.
  • Fixed a bug resulting in an error when using a calculated column in the chart.

v7.0.0.0 (July 02, 2018)

Initial release of SPJS Charts for SharePoint v7.

The solution has been rewritten to use asynchronous REST calls instead of the old webservice calls. This means the page responsiveness is better if you have multiple charts in one page.

You can still use a CAML query to filter the datasource, and in that case it will still use webservice calls, but asynchronous so the page don’t freeze up when waiting for the results. This does in fact make the query faster that with REST.