...
Switching to the ‘SQL’ tab will show the SQL executed to retrieve this sample:
...
If you’ve added formatting options, such as a thousand separator, prefix or suffix, to a data object the relevant formatting will be displayed when you test the object using the ‘Display Sample data’ icon.
...
Order By: Optional. This field is particularly useful when dealing with Month names, by default they will be sorted alphabetically so April will always appear first. The Order By field allows you to specify that they should be sorted chronologically.
...
Can Use In Temp Filters: If you don’t wish this object to be used in Chart Filters then unlick this option. You might do this if the field wasn’t indexed and the table was particularly large for example. If this box is unticked, the related object will not appear in the Temp Filters section of the dashboard and can therefore not be selected as a chart filter. Please refer to the section ‘Temporary filters’ in Chart Filters for more information.
Can Use in Temp Filter List of Values: This will enable users to specify whether the list of values is displayed as a drop down list in Filter areas of the dashboard. If this option is unticked, the list of values for the selected object will not be available as a drop down list – users will instead be able to type free text into the filter field to find a value. This can be used to prevent large lists appearing in drop-downs on the Filter screens.
| Elementor macro | ||||||
|---|---|---|---|---|---|---|
| ||||||