The coolest thing is that it's interactive (this is just a screenshot). I've used it for showing availability for mission data.
If you want to use it (it's really easy), see: https://developers.google.com/chart/interactive/docs/gallery/calendar
For planning my megabase i'm normally using the kirkmcdonald-calculator. But although you can highlight certain steps it's visual representation can become a bit cluttered.
So i tried an online sankey-diagram builder and got a better feeling of "where the stuff goes".
The above picture was created by SankeyMATIC and the following code:
>Refinery [402] Petrol
>Petrol [402] Plastic
>Refinery [15] HeavyOil
>Refinery [69] HeavyOil
>HeavyOil [15] Lube
>HeavyOil [69] HeavyCrack
>Refinery [214] LightOil
>LightOil [214] LightCrack
>Refinery [56] Petrol
>Petrol [56] Sulfur
>Refinery [160] LightOil
>LightOil [160] RoFuel
>HeavyCrack [29] RoFuel
>HeavyCrack [39] LightCrack
>LightCrack [192] Petrol
>Petrol [192] Plastic
>LightCrack [27] Petrol
>Petrol [27] Sulfur
I think this sankey builder is quite easy to use and very helpful.
The codes can even be created in excel if you use some "concatenate-magic".
The Google-charts-API has a similar approach and is also relatively easy to use.
As a consequence of this chart I am thinking about a divided refinery to reduce train traffic - one for plastic alone and one for all the rest. (my factorysetup is slightly too much focused on trains.)
Looks like Google Charts from a spreadsheet
The worst part about this to me is that the ring is composed of two distinct classes of things that are therefore mutually exclusive. In my experience, the entire point of this type of plot is to compare movement between things of one class, such as emigration/immigration. If it's two classes of things like this, where one class only ever "gives" to the other class (and vice versa), you're much better off just making it horizontal and using a Sankey-type diagram.
Edit: I threw together a Sankey Diagram of this data using the Google Charts API. The charts API doesn't seem to support different colors unfortunately, but it gives an idea of what this kind of thing should look like. You can hover over any country, nobel type, or connection to highlight it.
What did the old Google Finance charts look like?
They probably updated the charts to look almost the same but not require Flash.
https://developers.google.com/chart/interactive/docs/gallery/annotatedtimeline
I think the best way is to read the data that is used to create the chart in Excel, and return it as a JSON object. Then recreate the chart in the browser using something like Google chart tools. A less desirable hacky way might be saving the chart as a raster image, then displaying in the browser. Check out EPPlus for working with Excel files in .NET.
This Google API documentation page has a pretty complete and concise description of what QR codes are.
A QR code generator doesn't 'get' empty QR codes from anywhere. A QR code is just a standardized method for representing data. You can think of it as essentially another language; All the QR code generator does is translate whatever you enter into that language.
You need to use parenthesis like this:
WHERE EC = 'Cheifs' AND (CE = 'C' OR CE = 'RG OR ...)
Or you can use a different form of matching:
WHERE EC = 'Chiefs and CE matches 'C|RG|RT|LG|LT'
"matches" is an SQL like option in QUERY that lets you have multiple choices (OR using |). More here: https://developers.google.com/chart/interactive/docs/querylanguage#where
The format for dates is date '2019-06-25'
so you need to convert your values to that format as a string before passing it to a query.
You can't add operators inside the query itself. The query language is limited to what is documented here: https://developers.google.com/chart/interactive/docs/querylanguage
>i've tried using now()+30 but that doesn't work, either.
if you want a query that uses the current date, convert the current date to the format above with TEXT(NOW(),"YYYY-MM-DD")
and remember that concatenating strings is done with the symbol &
, so instead of this...
=QUERY(C:C,"select count(C) where C < ( today() + 30 ) label count(C) ''",1)
you would do this:
=QUERY(C:C,"select count(C) where C < date '"& TEXT(today() + 30,"YYYY-MM-DD") &"' label count(C) ''",1)
This way, the actual text that is passed as the 2nd parameter to the function query is:
select count(C) where C < date '2019-06-25' label count(C) ''
and that would be a valid query
I wrote some python code that turned "zfs get" into a treemap (https://developers.google.com/chart/interactive/docs/gallery/treemap)
https://i.imgur.com/ISsPxd7.png
It may take me a bit to clean it up.
Yes, simply add B to the "select" part and you get 2 columns:
=QUERY(A2:B39,"select A,B order by B desc limit 3")
If you are going to use queries rather than array formulas, I'd advise to check the documentation here. They are very powerful but not so intuitive sometimes.
That's Google Charts after I added the curveType argument; https://developers.google.com/chart/interactive/docs/gallery/linechart
I'll rip it out now.
merhaba, öncelikle veri kaynağını anlatacak olursam, ben 26. dönem TBMM milletvekillerine ait verileri uzun süredir topluyorum ve herkese açık bir şekilde https://milletvekilin.com adresinden sunuyorum, ama orada her güne ait verileri listelemiyorum, sadece en güncel olan değerleri sunuyorum. bu verileri çekmek için de her gün TBMM internet sitesine sorgu yolluyorum.
bu grafiği de Google'ın sunduğu LineChart grafiği ile oluşturdum. her güne ait değişim verilerine de sahip olduğum için, grafiği oluşturmam kolay oldu.
başka sorularınız varsa yine cevaplamaya çalışırım, ya da daha detaylı öğrenmek istediğiniz bir şey.
cheers, that would be a big help. I came across an instructions page that I haven't read through yet but looked promising. https://developers.google.com/chart/interactive/docs/animation
Only thing I didn't see is a way to export/share it. It would be strange if you couldn't...
Created using the newly released
British Election Study Wave 10 data and Google's Sankey plot library.
Writeup of the results is here.
TLDR: lots of party switching and no sign so far of the Lib Dems mopping up the remain vote.
Here is an idea for it. You'd only have to write a script to replace B1:F1 with the names of the 5 most recent worksheets.
Edit: The new "Format" for daily data is flexible. As long as you label each row with the exercise in column A, the total/snitt/max calculations should work.
https://docs.google.com/spreadsheets/d/1_0mMOoa2wZ9kj4bNIxlaUYIaQWILgPRO30PTYnpoCvA/edit?usp=sharing
I haven't worked much with charts so I don't know how to deal with line graphs missing data points. Also, I'm not sure if you have to trigger an update to the charts or not. The fields they are referencing will have the updated data in them from just updating the cells B1:F1, but it may not redraw the chart automatically.
Edit: If you absolutely never break from your routine, you might be able to use the 6 latest worksheets and reference only evens/odds for the exercises you are doing on even/odd days. That might resolve the line graph issue.
Ex. One set of graphs for even day exercises, one set of graphs for odd day exercises.
Also, there is interpolateNulls referenced here:
https://developers.google.com/chart/interactive/docs/gallery/linechart
Ha, that was actually pretty tricky. There is an add-on to the Google Maps JavaScript API called "GeoChart" that makes it very simple to color states/countries/etc. but alas, the Android Maps API doesn't have something similar. I ended up using this KML-like list of US states and create a polygon-overlay on the map at runtime. I can then retroactively access each polygon and assign it the correct color from the content-database. Detecting clicks (i.e. which state the user clicked on) required a few additional cups of coffee ;-). I'm happy to share that code if you're working on something similar?
Take a look at Google Charts API. I use it myself for a time tracking profile...
Basically, you define a WebView where you call the Charts API with your collected data and tell it how to be displayed, it's quite easy. Let me know if you want to see an example.
Notice that this approach definitely needs Internet access to work
I've used Google Charts in the past. Also if you don't want to code a solution, Amrein has some really helpful webparts for cheap. I think either of these solutions plus some CSS to make things pretty will get you want you need.
If by bucket and frequency you mean a histogram, you could use d3 or Google Charts. Alternatively, it's straight forward in Shiny if you're using R.
I'm a bit disappointed ... apparently Google doesn't plot ~~love~~ heart shapes...
x^2+(9/4)*y^2+z^2-1)^3-x^2*z^3-(9/80)*y^2*z^3=0
Also it would be cooler if they would add this feature to their actual charting api
I'm not sure whether the dogechain API supplies a method for creating QR codes, but you could always pass the public key to the Google Chart API.
I was wrestling with the problem of a 3rd axis as well. I found motion charts which are a tool that Google developed that can be inserted in a Google Spreadsheet. However, these take a lot of data to work correctly and I think it may be asking too much of the user to have them enter the data.
The easiest and freest one is probably Google Charts. The simplest way to present them would be import the data into a Google Sheet, generate the graphs there, then click the three dots on the graph and select 'Publish the chart'. Make sure you select interactive. Then you can link to the interactive chart just like your images.
It looks like you want a Sankey diagram.
Google Charts is a popular library for displaying charts on webpages using JavaScript, and has a Sankey diagram chart built-in. Each "row" in the input to Google Chart's Sankey diagram is in the form [fromClass, toClass, howManyStudentsWentFromFromClassToToClass]
, so you'd need to go over all of the students and count up the transitions. Though, this wouldn't let you see individual students, just the overall count.
I’ve incorporated a many Vue-chartjs into my Vuetify projects. Turns out nice.
There is also Google Charts
Reading this post reminded me that it also mentions these "back-quotes" or grave accents in the Query Language Reference. I think another common use of these back-quotes is when you are selecting columns with spaces in their header names.
I've never used Squarespace, but if you have access to the HTML file of your page, it would be as simple as adding the script tag with the library as src, and then adding another script to load the chart:
A SanKey diagram of the distribution by state, not surprising, but easier to understand than three tables of numbers.
Just build your data source into something that is "portable", i.e. parts that translate easily to JSON or XML, and use a JS lib on the front end. Something like google charts or d3.js for the fancy stuff. You might even be able to simplify entry with something like Google Forms submitting to a Google Sheet (to avoid having to maintain a DB) and pull directly from there but it will be more limiting. https://developers.google.com/chart/interactive/docs/gallery/table
What you're trying to do can be accomplished without the Array and without the CountA. You just need the Query function (e.g., =QUERY(<data>, SELECT COUNT(A) WHERE <arguments>). Read up on syntax here.
The reason your getting an unexpected count is that your query is returning a header row. Because you've wrapped it in CountA, that's returning a non-zero. Use a header argument in your query to eliminate this.
Depends on what you mean by professional looking tables and how much needs to change. If it’s a matter of interactivity and sorting and just a cleaner look, I’m a fan of Google Charts, very simple to use.
https://developers.google.com/chart/interactive/docs/gallery/table
This says the QR API is deprecated and replaced with the Google Charts API.
In order to be compatible with Sage, you'd need a replacement that implemented the same API. Not difficult, but if it's not already done, possibly specialty-labor intensive. Why don't you review which API you're using to see if you're using the deprecated one, then ask Sage what you should do, since they're the one that supports use of that API by their software.
> then in the middle of a 400 sticker print there will be gaps without QRs.
Logic would seem to dictate that someone's code needs better error handling, or at least different error behavior.
well, not really SQL but it supports some basic features, yes :)
see https://developers.google.com/chart/interactive/docs/querylanguage
If you do it like this and put the data in a Google spreadsheet, you can use a trendline to determine the exact formula.
https://developers.google.com/chart/interactive/docs/gallery/trendlines
Or you can do the same type of thing in Excel.
​
I did this on my Airdyne AD2 so I could build my own monitor that shows everything at once instead of cycling through 5 pieces of data on the screen.
Great way to get started is using some tools google provide: https://datastudio.google.com https://developers.google.com/chart/ (for websites)
You won't need to use design tools.
Good luck! :)
Hey, no problem at all. The background it fixed to stick with the colour scheme of the main dealferret site. It is just an image so there is no way of telling what style the user is using. I only set this bot off a couple weeks ago, so there is likely a ton of fixes to do once I spot issues. I have been developing dealferret in the UK for a couple years and it has been quite successful at finding good deals here. It has only been in trial for a US version for a couple months, but all the discount schemes, price reporting and store types seem very different.
I made the colour a bit darker. I am using the google charts library, but it looks like there are no options to give lines a shadow. I am always interested to understand what is difficult for others to see with respect to other people's monitor types, colour blindness etc. I have no problem with seeing this yellow, yet I am particularly sensitive to pure 0000FF blue and FF0000 red side by side on black background where the refractive index of my glasses moves them about.
Just as I am fixing this, my hosting provider seems to have gone down. Hopefully back soon.
In looking at the Google Charts Gallery - I think having the "Column Chart" and the "Bar Chart" would then have charts covered really well in Tasker. (With Pie Chart and Line/Curve already created).
Not sure if alot of the code or integration would be easy to adapt over to the Bar/Column ones, but hopefully some it anyhow.
A lot of folks use the "Tasker Sheets" plugin to send data back and forth to Google Sheets. I think with the chart bases covered it will be quick and easy in the future to map out datasets easily from any source!
this is called a sankey diagram.
they're really great for flow stuff and modeling the magnitude of many-to-many relationships.
Hey, I know of no way to do this in Google Sheets. The charting functionality is quite limited. I read through the chart api documentation and cannot find a simple workaround customization either. https://developers.google.com/chart/interactive/docs/gallery/linechart
I think your issue here is that you're calling the NumberFormat() method on column 2, which is comprised of strings ('1.25%', '15.87%', and '11.33%'). I believe you can use the pattern option from the docs to reformat that as a string after you've modified the number of decimal places needed. I'd try to convert the last column to floats or decimals before calling NumberFormat() on them. Hope that helps.
I've been using google charts here at work for all of our charts and graphs and it looks like you can save them to image to generate a PDF. I have yet to do it though.
https://developers.google.com/chart/interactive/docs/gallery
Take a look here to implement sorting the query: https://developers.google.com/chart/interactive/docs/querylanguage
Can you explain to me what the array formula is supposed to do, break it down for me?
=ArrayFormula(unique(query(if({1,0},countif(if('Form Responses'!G2:G<>"",'Form Responses'!G2:G), 'Form Responses'!G2:G),'Form Responses'!G2:G),"select Col2 where Col1="&max(countif(if('Form Responses'!G2:G<>"",'Form Responses'!G2:G),'Form Responses'!G2:G),'Form Responses'!G2:G)&" ")))
Edit: This seems to fix the problem, there was an issue with capitalisation:
=ArrayFormula(proper(unique(query(if({1,0},countif(if(lower('Form Responses'!G2:G)<>"",lower('Form Responses'!G2:G)), lower('Form Responses'!G2:G)),lower('Form Responses'!G2:G)),"select Col2 where Col1="&max(countif(if(lower('Form Responses'!G2:G)<>"",lower('Form Responses'!G2:G)),lower('Form Responses'!G2:G)),lower('Form Responses'!G2:G))&" "))))
That does make sense. Unfortunately, upon further research, it looks like Sheets only allows the major axis on stepped area charts to be discrete. https://developers.google.com/chart/interactive/docs/customizing_axes#Discrete_vs_Continuous
I may be interpreting that incorrectly and missing the option, maybe not.
I struggled with query()s at first but the Google documentation (https://developers.google.com/chart/interactive/docs/querylanguage) is great and querys tend to provide some relatively verbose solutions. One trick I found for standardising query functions is to do a simple filter and/or sort on the input data so that the function accepts it as an array instead of referencing columns (Col1 vs ColA).
I recently had to do something similar and originally tried d3js and nvd3js. It worked well enough, but encountered memory leaks if the browser tab was left open for a while (never found out if that was d3 or nvd3).
In the end, I went with Google Charts which I found much more user friendly for the relatively simple task I wanted to do (a rolling stacked area chart).
Holy relevance bat man!!
I'm currently in the middle of building an asset management system for my work! I've taken the decision to use QR codes (so they can be scanned by anyone with a smart phone without needing any extra hardware or software) containing the URL to that asset's "page" on my asset management system.
If you're comfortable using Python / Django give me a shout and I'll give you the URL to my git for you to clone!
I'm using a googlecharts API to generate the QR codes on the fly instead of creating and storing them myself using a library (e.g. PIL / PILLOW in my python projects, but there are many available), meaning my users will always need a live connection to the internet to generate / view them, but that's no barrier for us.
Example API call:
in HTML:
chs = QR dimension in px
cht = QR (chart type = QR)
chl= string to encode in QR
cho = encoding type
chld = x | y
x= error correction [I like to use Q "Allows recovery of up to 25% data loss"!]
y = boarder in QR units
Check out the API documentation here and give me a shout if you need any help!
https://developers.google.com/chart/infographics/docs/qr_codes
Query's docs suggest the Google Visualisation API Query Language Reference.
There it offers comparators of "contains", "starts with", "ends with", "matches", and "like" and corresponding examples; check the docs for what each of the examples would match to:
where name contains 'John'
where dept starts with 'engineering'
where 'cowboy' ends with suffix
where country matches '.*ia'
where name like fre%
I gathered this data from my server's access log; each entry contains an IP address so I simply gathered all of the IP addresses, removed duplicates, and searched through a geolocation data file taken from a IP2Location to gather location information.
For each data point I aggregated the common countries and formatted the results to use in the JavaScript mapping software, GeoChart.
Anyone looked through the Javascript in the page source? You could probably find whats changing the percentage exactly. I noticed this in the HTML
var gaugePercent = 64.61
It's such a garbled mess though.
Looks like they're using the Google chart Gauge API. Here's a link to it. We could maybe find out exactly where these numbers are coming from.
https://developers.google.com/chart/interactive/docs/gallery/gauge
https://developers.google.com/chart/interactive/docs/customizing_charts
to your options
var add a single line
colors: ['#e0440e', '#e6693e', '#ec8f6e', '#f3b49f', '#f6c7b6']
the problem is youve got two chart.draw()
calls and the second one overwrites the first, ignoring the options variable
fixed ver https://jsfiddle.net/7jedk7o2/
Ah I see, in which case, making some meaningful graphs from MTG data seems perfect.
Can I suggest a graph that maps archetype popularity with geolocation? It could be a cool way to see the difference in deck popularity.
Also, I'm not sure what you are using to create the graphs but I am a big fan of google charts (and google dashboards). They look great, are easy to set up, include a wide variety of charts and controls, and can be setup to support dynamic filtering and updating. For example, you could click something to restrict your dataset to just US data and the graph would automatically update.
Here's the link to the gallery: https://developers.google.com/chart/interactive/docs/gallery
Instead of complaining over one tweet or report, why don't the people here actually make their own chart & diagram similar to this based on popular and educated opinion from here?
This is a good start, even if it has got it wrong, we have the base work done... The first one is an organization chart, the second one is sankey diagram..
https://developers.google.com/chart/interactive/docs/gallery/sankey
https://developers.google.com/chart/interactive/docs/gallery/orgchart
Its called a Sankey Diagram. How one dimension breaks out into another and they have a type of many to many relationship.
I guess it could also be a Slope Graph but that is usually a one to one relationship.
gute idee, da gibt es aber leider keine Möglichkeit in der library die ich für die diagramme verwende, die sortierung pro Säule anzugeben.
I wrote a script to parse zfs metadata into a webpage with the Google Treemap API. I'm sure it would be trivial to make a version that uses the output you have.
https://developers.google.com/chart/interactive/docs/gallery/treemap
I made this using simple HTML/CSS/JS. It's hosted on a subdomain at the company I work for. I used Google's Charts API to make the charts. I collected the data in a Google Spreadsheet throughout the day before compiling the data.
Use cell objects and use the p
attribute of the object to define a style. Can't use HTML. Displayed text must be plain text.
So this is tangentially related to smash through my survey and not fnording at all but....
Does anyone know how to make a box-and-whiskers plot on Google Sheets? Or can at least explain how to do both the candlestick and horizontal marker thing both at once as shown here? It's driving me insane right now.
Based on the CDC's latest news about the benefits of circumcision, I was interested on the rate of circumcised men by state. Most data out there deals with regional rates.
The data source I found was done by research from Forward The tool used is Google Charts
All the information you need is on the getting-started page. https://developers.google.com/chart/interactive/docs/quick_start
You include a couple of scripts, call a couple of "load" functions, then the graphing library is ready for you to use with the rest of your web application.
Can't parse CSV afaik but as far as charting goes it just does an awesome job: Google Charts (notice: it's a pure JS lib and doesn't transfer your data back to their servers).
Recently wrote a Ruby Gem that makes its use for non-JS-devs in Rails/Sinatra/etc easier: Swagchart.
Tool: Google Visualization API, https://developers.google.com/chart/.
Data Source: Pew Research Religion & Public Life Project, http://www.pewforum.org/2011/01/27/table-muslim-population-by-country/.
The Google Visualization API is a good free alternative to highcharts.js. I'm using it for a new feature on a site I run, and it takes a bit of learning, but is quite powerful. The gviz_api python library also lets you export data directly from Python to a format that google charts can easily read.
I feel the need to comment here because of my current job. I work along side statisticians, who are very comfortable in R. I'm not a statistician, and I'm not comfortable with R at all. It's hard to maintain (as I'd claim is true with any dynamic typed language including python).
But the point I'd like to make about R is that it doesn't interface well with any other code. In the most generalized setting that means program A writes a CSV file, runs a system call to execute some R code with the R interpreter, then reads back in a CSV file. Not exactly fluid. Atleast with Python code it's trivial to write more python code, it's simple to call python code from inside C or Java code and vis-versa. In my eyes, although I dislike maintaining python, it's a much easier language to interface with other code to do more complicated things (eg, hosting interactive plots of the R code results using a web charts api.
It's google charts, graph style annotated timeline: https://developers.google.com/chart/interactive/docs/gallery/annotatedtimeline
I take readings every minute from 10 different sensors, so going more than a month or two at a time with all that data tends to crash chrome, heh, but you can definitely make what you want, the little links in the top left would do that if I presented more than a couple days of data to the chart.
Just checked and Chrome does indeed send an HTTP request. Google makes you load Charts in a rather odd fashion (you can't just embed a script link). For instance, on the Charts Gallery Page this is the charts JS file:
It was loaded via an HTTP GET 200 for me.
First of all, the map was with Kashmir, but without POK. It wasn't their fault. It definitely wasn't intentional. This was the map they used:
http://savedbythegoog.appspot.com/?id=8150d73c2e9218cac229c05043c24f1a4e3d6c16
It's a standard Google map.
https://developers.google.com/chart/interactive/docs/gallery/geochart
It's the most used map by developers and the map is meant to be used only for visualizing data relating to countries. Some developer might have picked it and put it as a donation map without paying much attention.
All Google owned websites, and many other website use this map. So, it's Google's fault for not showing POK in India. So by this logic, Google and all websites that use this map (there are many Indian websites too) are Pak agents.
And AAP removed this map from their website as soon as they realized that the map doesn't show POK in India.
I'm a developer with a casual interest in visualizing geo data. It probably wouldn't be too difficult to build something with Google Charts (probably using the Markers example). Maybe I'll give it a try for a rainy day. Regardless, this is an interesting data set so hopefully something can be done!
I have to admit that while charts popping in looks nice, I much prefer them to just be there as much as possible.
Though if anyone knows a modern alternative to Google Charts for geomap I'd love to hear it.
Hey @Mdawgkill I don't know if this is the best way of going about this but what I would do is probably try to organize your data into an excel table for each "category" you're measuring. I don't know what you mean by personal analytics but for example maybe "Spending" is one of your analytics. So you'd want to organize all your spending data into a table, you could save it as a CSV and then import it into a MySQL table.
Having your data organized will save you at least one headache. After that data was organized and imported into your MySQL DB, I'd probably use something like Google Charts.
You'll use PHP to connect to your DB (check out PDO for connecting to your database) and run queries. You'll use HTML forms for submitting variables that you want to plug into your queries, using $_GET. If you want to take it a step further you could create a live page using JavaScript and AJAX requests for running queries without having to reload the page. Anyway this should be enough to get you down a rough path, don't worry about CSS right this second, you can make it look pretty if you want after. =)
Edit - Oh if this is on a local domain and you don't want the data visible make sure you use a secure login system, for the time being this should work PHP-Login. Also if you plan on creating an interface for updating the data you'll want to use $_POST variables and ALWAYS make sure you sanitize your inputs. When that time comes read up on best security precautions for PHP and MySQL.
Good luck!
I use Data Tables as well, which I find awkward but workable (feel free to ask questions about them). I have been sniffing around Google tables; it looks like an option: https://developers.google.com/chart/interactive/docs/gallery/table
happy to help! To learn QUERY() I recommend you to watch this playlist. The official documentation also does a good job at explaining it.
The group by
clause of the QUERY does that. If you want to learn more about it I recommend you this playlist or Google's official documentation.
No problem. Here's the docs for the query language https://developers.google.com/chart/interactive/docs/querylanguage
Let me know if you have any trouble or want to share a copy of the sheet for help.
If that solves your problem for now reply "solution verified" to mark the thread solved.
> but is there a way around it without moving my other sheets around?
What do you mean "moving my other sheets around"?
> is there a way to prevent it from adding product() above the column
Yes, with a label clause:
=QUERY({'Sheet 3'!C5:C1000,'Sheet3'!CF5:CF1000,'Sheet 2'!B3:B998},"Select Col1, Col2*Col3 where Col2>0 label Col2*Col3 ''",0)
Before "where" add:
select *
So:
"select * where Col4 contains 'In progress'
You can replace * with Col1, Col2. That way you specifically get the columns you need. https://developers.google.com/chart/interactive/docs/querylanguage
graficas desde la terminal linux nada mas importando tu archivo con los parametros
o te puedes hacer una aplicacion web sencilla donde cargues tu archivo y grafiques con google chart
Maybe this one?
https://developers.google.com/chart/interactive/docs/gallery/steppedareachart
EDIT: Probably more like this one: https://developers.google.com/chart/interactive/docs/gallery/areachart
The GOOGLE Chart API allows you directly to create a QR code on the fly. This said all you need is someone to develop you a single page HTML and upload that to your server.
https://developers.google.com/chart/infographics/docs/qr_codes
If you want to make QR codes you’re going to want to use a library to generate them. Google has one here :
https://developers.google.com/chart/infographics/docs/qr_codes
You can’t make identical QR codes lead to a different place as the data is encoded in the QR code.
If you don’t want to use a library and want to make the QR code yourself you can find the spec, but they are pretty complicated as unlike standard barcodes QR data is encoded in 2 dimensions and not one. There is also extra data for error handling etc.
No the where clause belongs into your query
QUERY('All-Time Leaderboard'!B2:F, "Select B,C,F where D = '"&D4&"' limit 10")
Check also the documentation of the query language for more examples
https://developers.google.com/chart/interactive/docs/querylanguage
Do you have the frequency count in a column? Let's say something like:
Column A: text column B: frequency count?
Then I would use query:
Select A, B order by B des limit 1 offset 1
(For the second rank)
Select A, B order by B des limit 1 offset 2
(For the third rank)
Check out the docs for query:
https://developers.google.com/chart/interactive/docs/querylanguage
(I am on my mobile so couldn't check your sheet)
In this case it's best to use query. With that you can query your dataset like
Select A,B,C,D where B == Attributname etc.
That also works in combination with IMPORTRANGE to get the data into the other sheet.
Check out the docs here:
https://developers.google.com/chart/interactive/docs/querylanguage
And how do you determine the 100 you need? What I recommend you is to read the list with a query:
"Select C where C <> "" limit 100"
And now we need to know how you determine the most recents? Is it the last 100 days or the last 100 hours etc
This clause could then be added to the query above
Something like: Select C where D > 99 and D < 201
In this case the marker would be in column D and would be an incrementing number. As you see you have a lot of flexibility
Anyway this way you just add rows to your table, the list gets longer and you just select what you need. You don't need a script and don't have to delete anything.
You can make also an condition which checks the value of a cell so you can react to user input.
Check out the documentation for the query language:
https://developers.google.com/chart/interactive/docs/querylanguage
I found this:
https://developers.google.com/chart/interactive/docs/querylanguage#operators
Go to arithmetic operators
Query only recognizes +, -, / and * as operators.
Unfortunatly, I don't believe it's possible using QUERY function. Here's an exerpt from the documentation about QUERY:
Runs a Google Visualization API Query Language query across data.
QUERY(A2:E6,"select avg(A) pivot B")
QUERY(A2:E6,F2,FALSE)
QUERY(data, query, [headers])
Each column of data
can only hold boolean, numeric (including date/time types) or string values.
query
- The query to perform, written in the Google Visualization API Query Language.
The value for query
must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
​
As you can see, Query only takes strings, Booleans, or numbers. So it won't take hyperlink values.
I would suggest you try using something like "IMPORTRANGE", "FILTER" or similar functions to sort and filter the data you want to use if you want to keep the hyper link. Or simply remove the hyperlink and store the link as plain text.
BY need to be back-quoted because it's a reserved word.
https://developers.google.com/chart/interactive/docs/querylanguage#reserved-words
So you query should look like
=QUERY ('Master Master List' ! A2:BY, "SELECT A WHERE BY
= 'YES'"
Charts JS still works since it's just a JS library that renders the chart in the browser. Charts over http (e.g. an image tag, and google rendered the chart on their server, delivering you a raw image) was shut off in 2019 (https://developers.google.com/chart/image/docs/making_charts)
Heh, or maybe they said it was shut off but kept it on for some reason? I'd say treat it as "it could go away at any time"
It is indeed something missing. Personally, I would do them in powerpoint. This is what I used when I needed timelines. I don't think something really good exists yet. Looked into the other suggestions and they all seem a bit gimmicky. You could also code something in Google Charts if you are familiar with coding. It is free and gives great results: https://developers.google.com/chart/interactive/docs/gallery/timeline
its not identical, but its similar. This has most of what there is to use.
You could wrap it in a second QUERY to pull the average for the second column
=ARRAYFORMULA( QUERY( QUERY( {INT(C2:C), TEXT(C2:C,"hh")}, "select Col2, Count(Col2) where Col1 = "&TODAY()&" group by Col2 order by Col2 label Count(Col2) ''"), "select Avg(Col2) label Avg(Col2) ''"))
mess around with it -- you should get a good handle on it in no time.
You can then use Google Chart Tools on the client side to turn raw statistics into interactive charts and graphs. You could even use AJAX to update them in real time!
Easiest way I know is with Google's free service (docs)
e.g. https://chart.apis.google.com/chart?cht=qr&chs=256x256&chl=https://reddit.com is a QR that'll open reddit.com, for your promo codes you just need to generate IDs of some kind and put them in your url (it can handle passing along query params too).
Presuming that your input data table is at the top left of a sheet named "Input", with "Line Item Name" in column B and "Line Item Quantity" is column E,
Put the following formula is cell A1 of another sheet:
=QUERY(Input!$A:$E,"SELECT SUM(E), B WHERE B<>'' GROUP BY B LABEL SUM(E) 'Bags'",1)
The result is a table with total number of bags required for each unique Line Item Name, alphabetized by Line Item Name.
​
Explanation
The QUERY function performs a SQL-like database query on a range of spreadsheet cells.
Parameter 1: Input cell range
Parameter 2: Query text
Parameter 3: Number of header rows in Input cell range
See https://developers.google.com/chart/interactive/docs/querylanguage#Label for more specifics on the QUERY function.
you could also wrap an element of your select statement in lower(). =query(A:A, "select lower(A)")
is a valid query, for example.
The following link has a table of the functions you can use inside a query.
https://developers.google.com/chart/interactive/docs/querylanguage#scalar-functions
High Charts, Google Charts, *Charts ... just find a charting library that does the type of chart you want, and has the features/look you want, and go with that.
I wouldn't recommend building your own though (why re-invent the wheel?) and I definitely wouldn't recommend D3. D3 is a tool for building advanced visualizations, and learning it to build a basic chart is like learning to use Visual Studio Code just so you can change a single character in a text file.
But if you did want advanced visualizations on your site ... that happened to include some common charts ... you could check out the NVD3 library, which is a charting library built with D3. But again, unless you want advanced visualizations and want to learn how to use D3, you're probably best served with a regular/non-D3 *Charts library.
Hrm. Cool idea!
You'll want to think about where you'll want this chart to display... Are you going to want to deploy your chart as a web app? I don't think that Google Sheets has all of the chart types from Google Charts.
That's sick! I see what you're saying about the fuel level too, lol. I might just do 1/4 tank segments like you said. Also, I thought about mounting the sender in a bucket of water to slosh around and see how much the needle jumps, because it's definitely begging for a smoothing algorithm.
The gauge is from google's library which you can find here: https://developers.google.com/chart/interactive/docs/gallery/gauge#configuration-options
I am still looking at other options though... If I do an android app for the display, I'll probably use flutter instead of plain-ole-javascript.
This library seems pretty cool: https://help.syncfusion.com/flutter/radial-gauge/overview
It's a query in google query language. A:E defines all the relevant data, SELECT defines which columns you want, AVG(C) takes the average of column C, the WHERE clause filters down which rows you want to look at, and finally the LABEL clause at the end makes it so that the returned columns have no headers. The full range of clauses is shown in the link
Yeah I'm just writing queries in the actual cells. The functionality is a bit less robust than full SQL, but I'll try and implement your suggestions!