Report not found

There was a problem finding this report.
Meta Report for COGS 127
December 18, 2014 · Refreshed over 3 years ago
Description
For COGS 127 students: The following list of reports will help you decide on the basic data visualization you will generate from your data. Each report showcases some simple SQL that should help you.

Collaborators

Run History
select * from rdale.some_run_data
select * from rdale.some_run_data
<div style="margin:50px;"> <h1>Mode 'Meta Report' for COGS 127, UC Merced</h1> <div><font size="large">Hi COGS 127 students! Use the simple examples below, showing you a variety of queries that you can run on your data. Most are meant to illustrate a simple function that you can use, such as computing averages, taking counts, manipulating strings, etc. Note in some places I use /* comments */, showing how you can explain your steps for people who might check out your query. </font></div> <div style="margin-top:20px;"> An example with the simple <a href="https://modeanalytics.com/rdale/tables/some_run_data">running table</a> that I posted a while ago. <ul> <li> <a href="https://modeanalytics.com/rdale/reports/e0e88312a445" target="_blank">Using WHERE to narrow your data</a> </li> <li> <a href="https://modeanalytics.com/rdale/reports/2c54af7a2c70" target="_blank">Taking an AVG with GROUP BY</a> </li> <li> <a href="https://modeanalytics.com/rdale/reports/100c512b8190" target="_blank">Getting a COUNT with GROUP BY</a> </li> <li> <a href="https://modeanalytics.com/rdale/reports/f63b3442c3c2" target="_blank">Scatterplot with AVG and COUNT</a> </li> <li> <a href="https://modeanalytics.com/rdale/reports/9210f329b336" target="_blank">Calculating a SUM</a> </li> </ul> An example with GPS data that we've collected from class. Wanna scatterplot your GPS data? We need to do a bit of complicated "string" processing. Mode needs our latitude and longitude to be (i) separated from each other and then (ii) converted into numbers so that they can be plotted. <a href="https://modeanalytics.com/rdale/reports/043e13e2216e" target="_blank">Click here to see an example.</a> <br><br> Some recent questions include:<br><br> <u>I forgot to reset my data, and now two forms show up in my downloaded CSV</u> <blockquote> Here's a quick fix, simply using Excel.<br> <blockquote> 1) Open your CSV in Excel.<br> 2) Delete the columns you don't need (they will be the ones that are "n/a" ever since you updated your form)<br> 3) Delete the rows that you don't need (where the "n/a" starts for the old questions)<br> 4) Save the CSV (make sure that you just save it as a text file by clicking "Continue")<br> 5) You should be able to import into Mode normally. </blockquote> </blockquote> <u>I have strings not numbers, what should I do!</u> <blockquote> There are a few ways you can convert strings into numbers in some fashion, so that you can perform more interesting numeric plots. Check out these SQL examples showing you how to do it. <br><br> <b>Quick tip</b>: As a side note, one very simple trick is to use a text editor to search and replace some "offending string". For example, you may have used a coding scheme that had "1" and "2" and so on as radio button values (and these Mode recognizes as numbers), however a "5 or more" at the end of this range will cause Mode to see it as a string. You can open a text editor (e.g., Notepad or TextEdit) and just search and replace " or more" and replace it with "". This will result in a "5" and now you can treat these as numbers again. <blockquote> <a href="https://modeanalytics.com/editor/rdale/reports/a7237e786b28">Searching Strings and Casting into Numbers</a><br> <a href="https://modeanalytics.com/editor/rdale/reports/df0c994bcf77">Count the Number of Checkboxes Clicked</a><br> <a href="https://modeanalytics.com/editor/rdale/reports/e775749dc6ae">Search and Replace in a String Field</a> </blockquote> </blockquote> <u>I am getting errors in Mode import, is it because of HTML?</u> <blockquote> I would suggest opening your CSV file in a text editor and simply find and replace any HTML (e.g., "<font></font>") or text that you want to remove (e.g., " or more" in "5 or more") with empty strings (search and replace with ""). This will help. In addition, bear in mind that if your users entered a quote " anywhere in the text input, Mode will be confused because Mode recognizes that quote character as special. If youd o get an error, go to the line that Mode tells you about, and check for this kind of quote character in a response. Replace it with a single quote (') and it should work. </blockquote> <u>How can I map my GPS coordinates?</u> <blockquote> Consult <a href="https://modeanalytics.com/rdale/reports/043e13e2216e">this query</a> to show you how to extract the GPS coordinates (lat/long) as numbers. Then, download that data (click "Edit" then "Export") and you can use an online service like <a href="http://www.darrinward.com/lat-long/">this one</a> to plot your coordinates right on a map. You can use this as one of your figures in the paper, if you wish. </blockquote> I will post more of these as you ask more questions or issues arise. <br><br> <a href="http://cognaction.org/rick">Rick</a> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled