Previously, we had the Funnel widget as a separate solution, which became a part of the product and is no longer supported as a plugin. (https://www.sisense.com/marketplace/funnel-widget/)
After updating to a version higher than 2023.5, you can observe the issue with the Funnel plugin.
You can run the following scripts in the application database to automatically change the widgets from the plugin to the widget.
<font face="courier new,courier"><span>var cursor = db.widgets.find({ "subtype": "funnel" });</span></font><br/><br/><font face="courier new,courier"><span>cursor.forEach(function(doc) {</span></font><br/><br/><font face="courier new,courier"><span> db.widgets.update(</span></font><br/><br/><font face="courier new,courier"><span> { "_id": doc._id },</span></font><br/><br/><font face="courier new,courier"><span> {</span></font><br/><br/><font face="courier new,courier"><span> $set: {</span></font><br/><br/><font face="courier new,courier"><span> "subtype": "chart/funnel"</span></font><br/><br/><font face="courier new,courier"><span> }</span></font><br/><br/><font face="courier new,courier"><span> }</span></font><br/><br/><font face="courier new,courier"><span> );</span></font><br/><br/><font face="courier new,courier"><span>});</span></font><br/><br/><br/><br/><br/><font face="courier new,courier"><span>var cursor = db.widgets.find({ "type": "funnel" });</span></font><br/><br/><font face="courier new,courier"><span>cursor.forEach(function(doc) {</span></font><br/><br/><font face="courier new,courier"><span> db.widgets.update(</span></font><br/><br/><font face="courier new,courier"><span> { "_id": doc._id },</span></font><br/><br/><font face="courier new,courier"><span> {</span></font><br/><br/><font face="courier new,courier"><span> $set: {</span></font><br/><br/><font face="courier new,courier"><span> "type": "chart/funnel"</span></font><br/><br/><font face="courier new,courier"><span> }</span></font><br/><br/><font face="courier new,courier"><span> }</span></font><br/><br/><font face="courier new,courier"><span> );</span></font><br/><br/><font face="courier new,courier"><span>});</span></font><br/><br/><br/><br/><br/><br/><font face="courier new,courier"><span>db.widgets.find({ "metadata.panels.name": "Category" }).forEach(function(doc) {</span></font><br/><br/><font face="courier new,courier"><span> var updatedPanels = doc.metadata.panels.map(function(panel) {</span></font><br/><br/><font face="courier new,courier"><span> if (panel.name === "Category") {</span></font><br/><br/><font face="courier new,courier"><span> return { "name": "categories", "items": panel.items };</span></font><br/><br/><font face="courier new,courier"><span> } else {</span></font><br/><br/><font face="courier new,courier"><span> return panel;</span></font><br/><br/><font face="courier new,courier"><span> }</span></font><br/><br/><font face="courier new,courier"><span> });</span></font><br/><br/><br/><br/><br/><font face="courier new,courier"><span> db.widgets.update(</span></font><br/><br/><font face="courier new,courier"><span> { "_id": doc._id },</span></font><br/><br/><font face="courier new,courier"><span> { $set: { "metadata.panels": updatedPanels } }</span></font><br/><br/><font face="courier new,courier"><span> );</span></font><br/><br/><font face="courier new,courier"><span>});</span></font><br/><br/>
After running these scripts in the application database all your Funnel charts will be changed from the plugin to the widget.
