Custom visualization with HTML and Javascript to create/style your own visualization. You can navigate to custom Text/HTML via Settings.
Customizable text/HTML based display. Can be simple text to more powerful rendering to include your data in a variety of forms.
| Custom Widget |
|
| Font size |
Default font size |
| Font color |
Font color |
| Background color |
Widget background color. |
| Text Code |
Enter Text or HTML code. You can use {{tag}} to field data for the widget. type in { to get a list of fields along with some options you can use to customize the display of data
Tag Options:
Simple field display:
-
{{field_name}} - getting the first value for field with name "field_name".
-
{{field_name:n}} - get the nth value of the field with name "field_name".
-
{{field_name:n-c}} - get a list comma-separated from "n" to "c" with "field_name".
Commands:
-
_data - JSON object with data for the current dataset. Typically used within JavaScript.
-
_ul - builds a bullet list using value field. Command form {{_ul|field_name:n-c}}, {{_ul|field_name:n}}, {{_ul|field_name}}.
-
_ol - builds a numbered list using value field. Command form {{_ol|field_name:n-c}}, {{_ol|field_name:n}}, {{_ol|field_name}} (field_name - field name in the sheet, n - from, ? - to)
-
_table - builds a table from the field. Command form {{_table|field_name1,field_name2:n-c}}, {{_table|field_name1,field_name2:n}}, {{_table|field_name1,field_name2}}
-
_count - total number of records {{_count}}
-
_sum - the amount of field values {{_sum|field_name:n-c}}, {{_sum|field_name}}
-
_max - maximum value of the field {{_max|field_name:n-c}}, {{_max|field_name}}
-
_min - minimum value of field {{_min|field_name:n-c}}, {{_min|field_name}}
-
_widget - add another widget (not HTML widget) {{_widget|widget_name}}
-
_class - returns field value without any html wrappers. Useful if you want to use field value as a class name {{_class|field_name:n}}, {{_class|field_name}}
|
