This site has moved.
*** This page is deprecated. Please click here for the new version ***
Parameters are set in the second row of your data sheet. You can combine them together and with filters by separating them with a ' - ' :
Use the Hidden parameter to avoid displaying data from a column in your gadget.
Note : It can be also used as an additional attribute : i.e. CategoryFilter - Hidden. This way, data won't by displayed in the table. However, it will be possible to filter results with the CategoryFilter.
Use the Sidebar parameter to display a detailed view of selected row in a sidebar.
Note: Sidebar combined with templates will enable rich a HTML display.
Use the CardsColor parameter to color the background of each cards differently. Either hexadecimal (ie. #F44336) or CDD colors (Light Green, Amber...) can be used. Here are all material design colors from Google recommendations (Hexadecimal equivalent and CSS colors).
Note: To set all the cards background-color uniformly, prefer using a CSS rule (see the Cards view for more details)
Use the CardsContent parameter to select the column displayed by the Cards.
Note: This columns is often built using Template, (which is why the column is empty on the example).
Data values can be coordinates (latitude - longitude pairs) or addresses.
Use the MapsLong filter to designate the column containing the longitude coordinates.
Use the MapsLat filter to designate the column containing the latitude coordinates.
Use the MapsAddress parameter to designate the column containing the addresses.
Use the MapsTooltip parameter to add a tool-tip displaying useful information above the markers.
Note: MapsTooltip combined with templates will enable rich HTML display.
By default the Business intelligence view (BI) will try to use the best display for each chart, but you can force the display on some charts depending on their data type: String, Number, Date.
Column type: Number
Use the BIAggregate parameter to display the Sum of the column.
Column type: Number
Use the BIColumnChart parameter to display data in a column chart.
Column type: String
Use the BIPie parameter to display data within a pie chart.
Column type: StringUse the BIWorldCloud parameter to display responses as a cloud of words.
Column type: StringUse BITopResults to display as a table the top 15 form responses ranked by number of occurrence.