Skip to main content

View Diary: ACASignups.net: 212K enrolled + New Features Added!! (21 comments)

Comment Preferences

  •  I'm looking at the first graph (1+ / 0-)
    Recommended by:
    Victor Ward

    and finding it hard to understand. The graph should stand on its own, without my having to wade through reams of text to decipher it. That's why we have graphs in the first place-- so we can get a quick understanding of the data without having to read all the tables.

    My beef is not your information-gathering, which is fantastic. I just don't think you are currently displaying your information in the most informative way.

    I want to look at that graph, and see at a glance what the trend of the signups is and where the goal is. The graph has data up to December 3. It's November 25. Why is there anything past November 25?

    On further looking at that confusing first graph, perhaps my beef is really the descent to zero mid December. Why is it there? Shouldn't you have a dashed line going up, instead of a solid line going to zero? It makes me believe that the data for a date is the daily data for that date only, but isn't the data you're presenting cumulative? So why does it go to zero? In any case, you should label the graph either "Cumulative Data" or "Daily (Weekly?) Data", so I don't have to guess.

    •  OK, I see your point (0+ / 0-)

      By default, Excel's chartmaker just drops everything off if there's no further data. There's no data in the following week's dataset, so it just drops off to 0.

      The best I could do would be to have them all flat-line across, but I figured that would be even more confusing.

      I'll try and add a few more labels/captions to explain, however (including the actual website link in case people start reposting the graph without citation).

      •  What if you stopped the chart at today? (1+ / 0-)
        Recommended by:
        Victor Ward

        That is, what if you made the right side of the chart be today? Then you wouldn't have the problem of Excel giving you a bogus chart for the future, because you'd just be showing accurate data from the past.

        Excel should do that for you with ease.

        •  For one thing, that would negate the (0+ / 0-)

          ...whole "goal by 6 months" part, which is the main point of the chart in the first place.

          Plus, I need the extra space for notes/captions.

          Will tweak it a bit but am leaving it mostly as is.

          •  But the chart doesn't show the goal by six months (1+ / 0-)
            Recommended by:
            Victor Ward

            The top of the chart is 1 million. The goal by six months is seven million.

            You may want a chart that shows the goal by six months, but IMO a chart that shows what has been done so far is also valuable. The first chart is a bastard child of those two goals, which does neither well. Let the second chart be the goal by six months, with projections, goals, and the comparison to Massachusetts.

            Give us the actuals in the first chart. We want to see the actuals. At a glance. Without a confusing drop to zero, or a misleading flatline. You have the data to make that useful, easy-to-understand graph, and you should do it.

            •  With all due respect, you're the only one (1+ / 0-)
              Recommended by:
              Cartoon Man

              ...complaining about this. If numerous people gripe about it, I'll consider it, but for now I'm leaving it as is.

              I'm not being paid to do this, and I do have a job to do.

              If you want to set up your own site/chart/graph with my data, be my guest.

              •  OK, good idea. (1+ / 0-)
                Recommended by:
                Victor Ward

                Where'd you find the week-by-week data for Massachusetts? Once I get a trend line for Massachusetts and shrink it it to six months I can superimpose the ACA data so far on it, and see what's going on. And then I can play around with just California, and just Kentucky, to see how the states that made competent websites are doing.

                And I can also make the actual cumulative graph that I want.

                I hope I can do this in Google Docs, but I may have to go to R, with its super graphing capabilities.

              •  Cardinal Fang is correct about (0+ / 0-)

                the dropoff to zero being a problem. I believe that there is a way to tell Excel to end the line at a particular month while showing other data for later periods, but I have not used Excel in years, since I switched to Open Office, and can't tell you how to go about it. I certainly have no difficulty doing it in Libre Office Calc, the successor to Open Office Calc.

                Ceterem censeo, gerrymandra delenda est

                by Mokurai on Mon Nov 25, 2013 at 10:33:38 PM PST

                [ Parent ]

Subscribe or Donate to support Daily Kos.

Click here for the mobile view of the site