4 ms·

I created this with a new service I released (Machete). Machete is built on top of dc.js (which in turn is built on d3.js and crossfilter). dc and d3 both have

by viggity 12y ago

I created this with a new service I released (Machete). Machete is built on top of dc.js (which in turn is built on d3.js and crossfilter). dc and d3 both have decent learning curves, Machete is aimed at non-programmers or as a prototyping tool for developers. The visualization works best in chrome or any edge browser. In the off chance you're a huge Luddite and surfing HN with IE8, here are a couple extracted stats across the 2,040 rounds: YC dwarfs other accelerators with $2.8B in funding, next largest is AngelPad with $185M. Average A Round - $4.3M, B - $17M, C - $58M, D - $98M Airbnb and Dropbox so skewed stats, that I created a filterable attribute for them called "Freakish_Outlier". I should be on for a couple hours, please feel free to comment or ask questions.

stock_toaster 12y ago
Under "Region" (with raised_total), what is the region between Atlanta and Seattle with no label?
- viggity 12y ago
  its just data that wasn't provided :(
CGamesPlay 12y ago
Looks good. There are two things that will be really important: - How is data imported? It would be great to be able to set up custom SQL queries, CSV imports, and other service gateways to do analytics on. - How do I define graphs? I'll want to be able to do time-series, but easily switch between day/week/month/year resolution, and create trailing period averages without having to think about it. I signed up for the beta. I'd love to play around and do some deep diving on stats we have collected.
- viggity 12y ago
  Right now we only support CSVs they get served directly from blob storage to the browser (without going through our webserver). We obviously want to expand on those options, but CORs makes serving from internal company data sources a PITA. We could use our domain as a proxy to the relevant info, but that has its own issues (auth, perf). I'm sure we'll be able to work it out though. Automated CSV imports will probably be the best way to do things initially. When you import your CSV, we take educated guesses about the data in each column (number, category, date), but you can change it if necessary (sometimes numbers should be treated like categories). We give you the ability to group dates by day of week and month. Month-year isn't in there yet, but should be by launch. It works best one un-aggregated source data (since we do so all the fine level aggregation ourselves in the browser). Dealing with weighted averages is possible and we've done it a lot in custom work, but machete doesn't yet have support for it. Thanks for the kind words :)
zheshishei 12y ago
I changed the primary sort to the count, then filtered on just "Fan Go". Then, I wanted to compare the total amount Fan Go had raised in comparison to other companies, so I changed the primary sort back to the total, but then was unable to see "Fan Go" on the "Total Raised - Company" bar chart. I had to hover over the bubble in the graph instead to see the total amount Fan Go had raised.
- viggity 12y ago
  yeah, things can get a bit screwy when you filter and then change the active measure. It isn't a simple fix unforunately. I've added a bug to our backlog. Thanks!
pnachbaur 12y ago
You could use median instead of filtering out outliers explicitly so your averages don't get skewed.
- viggity 12y ago
  Median might solve some of that issue, unfortunately it is computationally heavy to do median on a rolling basis, unlike average. Part of the reason the filters work so quickly is because when I add or remove items from the active set, I can just add/subtract from the total and the count for that one item. With median, I'd have to keep the active list sorted which even with a binary tree under the covers is still more expensive than two math operations. The filtering library under the cover is crossfilter.
unwind 12y ago
Very nice! I missed the currency symbol ($) in the labels, I felt that I wasn't sure sometimes if I was seeing a "count" of something, or a measure of currency. Perhaps it's all currency so it's redundant, but I still think proper units are a good thing to have when presenting data. Better one too many than one too few, imo.

by viggity 12y ago

stock_toaster 12y ago

Under "Region" (with raised_total), what is the region between Atlanta and Seattle with no label?

viggity 12y ago
its just data that wasn't provided :(

CGamesPlay 12y ago

Looks good. There are two things that will be really important: - How is data imported? It would be great to be able to set up custom SQL queries, CSV imports, and other service gateways to do analytics on. - How do I define graphs? I'll want to be able to do time-series, but easily switch between day/week/month/year resolution, and create trailing period averages without having to think about it. I signed up for the beta. I'd love to play around and do some deep diving on stats we have collected.

viggity 12y ago
Right now we only support CSVs they get served directly from blob storage to the browser (without going through our webserver). We obviously want to expand on those options, but CORs makes serving from internal company data sources a PITA. We could use our domain as a proxy to the relevant info, but that has its own issues (auth, perf). I'm sure we'll be able to work it out though. Automated CSV imports will probably be the best way to do things initially. When you import your CSV, we take educated guesses about the data in each column (number, category, date), but you can change it if necessary (sometimes numbers should be treated like categories). We give you the ability to group dates by day of week and month. Month-year isn't in there yet, but should be by launch. It works best one un-aggregated source data (since we do so all the fine level aggregation ourselves in the browser). Dealing with weighted averages is possible and we've done it a lot in custom work, but machete doesn't yet have support for it. Thanks for the kind words :)

zheshishei 12y ago

I changed the primary sort to the count, then filtered on just "Fan Go". Then, I wanted to compare the total amount Fan Go had raised in comparison to other companies, so I changed the primary sort back to the total, but then was unable to see "Fan Go" on the "Total Raised - Company" bar chart. I had to hover over the bubble in the graph instead to see the total amount Fan Go had raised.

viggity 12y ago
yeah, things can get a bit screwy when you filter and then change the active measure. It isn't a simple fix unforunately. I've added a bug to our backlog. Thanks!

pnachbaur 12y ago

You could use median instead of filtering out outliers explicitly so your averages don't get skewed.

viggity 12y ago
Median might solve some of that issue, unfortunately it is computationally heavy to do median on a rolling basis, unlike average. Part of the reason the filters work so quickly is because when I add or remove items from the active set, I can just add/subtract from the total and the count for that one item. With median, I'd have to keep the active list sorted which even with a binary tree under the covers is still more expensive than two math operations. The filtering library under the cover is crossfilter.

unwind 12y ago

Very nice! I missed the currency symbol ($) in the labels, I felt that I wasn't sure sometimes if I was seeing a "count" of something, or a measure of currency. Perhaps it's all currency so it's redundant, but I still think proper units are a good thing to have when presenting data. Better one too many than one too few, imo.