ProTip!
<%= link_to 'more...', docs_queries_path, target: :_blank, style: "float: right; font-weight: 200" %>
-
Command + S to backup your SQL string.
-
Set column name to *_date to format DateTime to <%= Time.current.strftime('%Y/%m/%d') %>
-
Set column name to *_time to format DateTime to <%= Time.current.strftime('%H:%M') %>
<% if @data_source.smart_variables.any? %>
<% @data_source.smart_variables.keys.each do |key| %>
-
Use
{<%= key %>} to get a dropdown of values.
<% end %>
-
Use
{start_time} and {end_time} for a date range selector.
-
End a variable name with
_at for a date selector.
<% end %>
-
Chart:
2+ columns - timestamp, numeric(s)
-
Chart:
3 columns - timestamp, string, numeric
-
Chart:
2+ columns - string, numeric(s)
-
Chart:
3 columns - string, string, numeric
-
Scatter Chart:
2 columns - both numeric
-
Chart:
2 columns - string, numeric - and last column named
pie
-
Chart:
Named
latitude and longitude, or lat and lon, or lat and lng