FAQ and Troubleshooting - Widgets

A column from the dataset is not available for selection in the drop-down!

The columns which are available in a drop-down depend on the data type of the column. E.g. a column of type string will not be available in the drop-down for the y-values of a multi-chart.

What exactly is the data source limit applied to?

The data source limit is limiting the entries which are loaded into the widget. Not the entries which are used in your script for your dataset. So if the limit is 1000 and a data source has more than 1000 rows then the widget will only display the first 1000 rows. Note that if there are NULL values within these rows even less than 1000 values will be displayed.

Given Tick Interval (vertical axis, custom option in multi-chart) is not used?

If the tick interval is not exactly as you set it this might be due to the minimum setting which depends on the minimum and maximum value displayed in the chart.

Can I use emojis in a widget?

In headers and status text of table widgets

Just copy the emoji (e.g. from here) into the text field for the header or status text.

Single text or table widget

Yes, you can, but only with an R script and not via a function column or a python script. You can simply use the unicode in a string variable of your script.

# to display the winking face emoji (unicode: U+1F609) use

output <- "\U1F609"

You can also combine emojis with text.