Skip to content

Instantly share code, notes, and snippets.

@lizer

lizer/README.md

Last active July 2, 2018 12:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lizer/bfb71771537e437618c8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lizer/bfb71771537e437618c8 to your computer and use it in GitHub Desktop.
Download ZIP
Google Line Chart for Dashing
Raw
README.md

Thanks for Mike Machado@machadolab!! This plugin is developed based on Google Column Chart the gentleman developed.

Description

A Dashing widget to show a Google Line Chart on a dashboard.

Installation

Copy the google_line.coffee, google_line.html and google_line.scss file to into /widgets/google_line directory.

Add the following to the dashboard layout file:

    <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <script type="text/javascript">
        google.load("visualization", "1", {packages:["corechart"]});
    </script>

Then to include the widget on the dashboard, add the following item to your dashboard file:

    <li data-row="1" data-col="1" data-sizex="2" data-sizey="1">
      <div data-id="mychart" data-view="GoogleLine"  data-title="My Chart"></div>
    </li>

Options

The following options can be added to the <div> of the chart object (defaults in parenthesis):

  • data-title - (no title) Title of the chart
  • data-colors - (Googles default colors) A comma separated list of colors to use for the chart bars
  • data-legend_position - (right) Position of the legend. One of 'bottom', 'left', 'in', 'none', 'right' or 'top'
  • data-vaxis_format - (auto) A format string for numeric axis labels. One of 'none', 'decimal', 'scientific', 'currency', 'percent', 'short', 'long'
  • data-curve_type - (none) Controls the curve of the lines when the line width is not zero. One of 'none', 'function'

Complex Example

The following would show vertical axis values in percent. e.g. 0.4 -> 40% , remove the legend and smooth the angles of the line:

    <li data-row="1" data-col="1" data-sizex="2" data-sizey="1">
      <div data-id="mychart" data-view="GoogleLine" data-legend_position="none" data-vaxis_format="percent" data-curve_type="function" data-title="My Chart"></div>
    </li>

Populating the Chart

To send data to the chart, use send_event to send an item called points with a two dimensional array. Make sure the first "row" in the array is an array of headers for the data.

For example:

send_event('mychart', points: [
      ['Year', 'Sales', 'Expenses'],
      ['2004',  1000,      400],
      ['2005',  1170,      460],
      ['2006',  660,       1120],
      ['2007',  1030,      540]
  ])
Raw
google_line.coffee
class Dashing.GoogleLine extends Dashing.Widget
@accessor 'current', ->
return @get('displayedValue') if @get('displayedValue')
points = @get('points')
if points
points[points.length - 1].y
ready: ->
container = $(@node).parent()
# Gross hacks. Let's fix this.
width = (Dashing.widget_base_dimensions[0] * container.data("sizex")) + Dashing.widget_margins[0] * 2 * (container.data("sizex") - 1)
height = (Dashing.widget_base_dimensions[1] * container.data("sizey"))
colors = null
if @get('colors')
colors = @get('colors').split(/\s*,\s*/)
@chart = new google.visualization.LineChart($(@node).find(".chart")[0])
@options =
height: height
width: width
colors: colors
backgroundColor:
fill:'transparent'
legend:
position: @get('legend_position')
animation:
duration: 500,
easing: 'out'
vAxis:
format: @get('vaxis_format')
curveType: @get('curve_type')
if @get('points')
@data = google.visualization.arrayToDataTable @get('points')
else
@data = google.visualization.arrayToDataTable []
@chart.draw @data, @options
onData: (data) ->
if @chart
@data = google.visualization.arrayToDataTable data.points
@chart.draw @data, @options
Raw
google_line.html
<h1 class="title" data-bind="title"></h1>
<div class="chart"></div>
Raw
google_line.scss
// ----------------------------------------------------------------------------
// Sass declarations
// ----------------------------------------------------------------------------
$background-color: #fb9618;
// ----------------------------------------------------------------------------
// Widget-GoogleGauge styles
// ----------------------------------------------------------------------------
.widget-google-line {
background-color: $background-color;
position: relative;
.title {
position: absolute;
top: 5px;
left: 0px;
right: 0px;
}
.chart {
position: absolute;
left: 0px;
top: 0px;
}
}
@saileanplum
Copy link

saileanplum commented May 23, 2016

How do I change the background color on the widget?

@lizer
Copy link
Author

lizer commented Jun 14, 2016 •
edited
Loading

@saileanplum

Chart background colour can be change by adding style="background-color:#47BBB3" in your chart div. E.g.

@Atishdharvesh
Copy link

Atishdharvesh commented Aug 5, 2016

hi there,
its indeed very nice widget.
perhaps you might help me to get data in the widget while quering directly in a mysql db (already setup).
I've this particular job setup and maybe it can be reused to get this done :
https://github.com/Shopify/dashing/wiki/How-to:-send-mysql-data-to-your-widgets

Thnks for your help and precious time.
BR,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment