search

GSA / sdg-indicators-usa

U.S. National Reporting Platform for the Sustainable Development Goals
https://sdg.data.gov
Other
31 stars 92 forks source link

Graph for yes/no indicators #722

Closed JenPark9 closed 6 years ago

JenPark9 commented 6 years ago

We will need a way to make indicators completed with yes/no values into "green, reported on line" and let the table be shown or something. Examples are listed below for ease of reference. 13-1-1 17.18.3 17.19.2

philipashlock commented 6 years ago

Should we just show the data table or is there some way we'd want to visualization the yes/no values over time? I don't know if there's any well established convention for displaying binary values like that in a time series, but we could attempt to do something like this using the existing graphing library:

screen shot 2017-10-30 at 6 31 33 pm

henningsh commented 6 years ago

It's certainly not an established convention, but Edward Tufte has a design he uses to illustrate win/loss records for sports. Could be another option -- up lines represent wins, down lines represent losses.

capture

JenPark9 commented 6 years ago

I think both of these are good. In general, for the SDGs, we can expect that once a no turns to a yes, it will remain a yes. (Typically, it is when a statute is issued.) Any ideas for a graphing situation where the image is a sideways h like this? ____|-----

Kali2017SDG commented 6 years ago

I can't seem to upload neither an excel file or .png

[Uploading YesNoGraph.xlsx…]()

Kali2017SDG commented 6 years ago

[cid:image001.jpg@01D35235.8F0CA030] From: JenPark9 [mailto:notifications@github.com] Sent: Tuesday, October 31, 2017 10:45 AM To: GSA/sdg-indicators sdg-indicators@noreply.github.com Cc: Kong, Kali K. EOP/OMB Kali.K.Kong@omb.eop.gov; Comment comment@noreply.github.com Subject: [EXTERNAL] Re: [GSA/sdg-indicators] Graph for yes/no indicators (#722)

No, we can’t do that from our omb system. We can do that from a public system. You can try inserting it in an email here, and perhaps Stephanie or Phil can load it.

From: Kali2017SDG [mailto:notifications@github.com] Sent: Tuesday, October 31, 2017 10:43 AM To: GSA/sdg-indicators sdg-indicators@noreply.github.com Cc: Park, Jennifer E. EOP/OMB Jennifer_E_Park@omb.eop.gov; Author author@noreply.github.com Subject: [EXTERNAL] Re: [GSA/sdg-indicators] Graph for yes/no indicators (#722)

I can't seem to upload neither an excel file or .png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<%3ehttps:/github.com/GSA/sdg-indicators/issues/722%3c#issuecomment-340784270>, or mute the thread<%3ehttps:/github.com/notifications/unsubscribe-auth/ATtsqlHFS6ImkaRsF6Pm6xr4joBiHauRks5sxzILgaJpZM4QBNBP%3c>.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub<%3ehttps:/github.com/GSA/sdg-indicators/issues/722%3c#issuecomment-340784892>, or mute the thread<%3ehttps:/github.com/notifications/unsubscribe-auth/Ac3MKEONC0eRW7FrGAwH2e8up70bcK1Hks5sxzKFgaJpZM4QBNBP%3c>.

angela-smithers commented 6 years ago

... a diverging bar chart on it's side ... with only two statuses ... http://blog.askia.com/wp-content/uploads/2016/03/Screenshot-2016-03-30-10.29.01.png

JenPark9 commented 6 years ago

This is a sort of population pyramid type. There are four ordered response categories. So, this is not a great fit for the yes/no graph. But thank you for looking!

From: Angela [mailto:notifications@github.com] Sent: Tuesday, October 31, 2017 12:20 PM To: GSA/sdg-indicators sdg-indicators@noreply.github.com Cc: Park, Jennifer E. EOP/OMB Jennifer_E_Park@omb.eop.gov; Author author@noreply.github.com Subject: [EXTERNAL] Re: [GSA/sdg-indicators] Graph for yes/no indicators (#722)

... a diverging bar chart on it's side ... with only two statuses ... >http://blog.askia.com/wp-content/uploads/2016/03/Screenshot-2016-03-30-10.29.01.png<<%3ehttp:/blog.askia.com/wp-content/uploads/2016/03/Screenshot-2016-03-30-10.29.01.png%3c>

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<%3ehttps:/github.com/GSA/sdg-indicators/issues/722%3c#issuecomment-340816838>, or mute the thread<%3ehttps:/github.com/notifications/unsubscribe-auth/ATtsqplJ-6dXnaujI0iebcF67SqJXvx6ks5sx0irgaJpZM4QBNBP%3c>.

angela-smithers commented 6 years ago

There is probably a D3 for it, but I am still looking Here's a graphed DNA strand that may inspire because chromosomes are either on or off

angela-smithers commented 6 years ago

Here is the js fiddle code: http://jsfiddle.net/chrisJamesC/tNdJj/4/ image

philipashlock commented 6 years ago

Great, I should be able to update the template with this approach later this afternoon.

JenPark9 commented 6 years ago

Yes, that looks a bit like Stephanie's suggestion. Let's try--but with one color, right?

philipashlock commented 6 years ago

Yep. Here's roughly what I'll be implementing (live example on jsfiddle)

screen shot 2017-10-31 at 4 55 34 pm

philipashlock commented 6 years ago

There's an initial version of this live now, but it does not yet support multivariate graphing. The indicators that have been updated so for (by adding a value to the indicator_variable field in the metadata) are:

JenPark9 commented 6 years ago

Phil, Thanks! I am good w this solution. Ladies? Note Angela we would need stars inserted here. Kali, we will need to comb through red and some green indicators potentially to make sure that in cases where we have y:n responses we have signaled that the indicator is green, that a binary graph and indicator for graphing is identified, and the data table is shown. If you put a list of any such troublesome indicators in the issue thread, I think I can fix it on my end.

Sent from my iPhone

On Oct 31, 2017, at 6:37 PM, Philip Ashlock notifications@github.com<mailto:notifications@github.com> wrote:

There's an initial version of this live now, but it does not yet support multivariate graphing. The indicators that have been updated so for (by adding a value to the indicator_variable field in the metadata) are:

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<>https://github.com/GSA/sdg-indicators/issues/722<#issuecomment-340928165>, or mute the thread<>https://github.com/notifications/unsubscribe-auth/ATtsqjsREpfsPB6cJbzj2yZ9I52jZ3pmks5sx6FDgaJpZM4QBNBP<>.

Kali2017SDG commented 6 years ago

I will do complete sweep through all indicators and prepare a list -- first thing in the morning.

Philip-- If you get a chance, please help with graph for indicator 17.4.1... blank graph ( because they completely changed indicators w/o notifying anyone in advance) Jen- I sent that email out yesterday because I was not able to reach Andrew via phone (to ask if Dennis reviewed/approved). I do not believe Andrew would be so bold as to do it himself. I will try to call him again tomorrow and will call Scott if I can't reach him. Lucky for him this fell in SDG17 (w/ no co-chair to annoy).

Kali2017SDG commented 6 years ago

Yes, the yes/no graphs look good. The only thing is that it should be blue (Angela submitted a pull/push request earlier today) Thanks, Philip.

JenPark9 commented 6 years ago

☺

From: Kali2017SDG [mailto:notifications@github.com] Sent: Tuesday, October 31, 2017 9:35 PM To: GSA/sdg-indicators sdg-indicators@noreply.github.com Cc: Park, Jennifer E. EOP/OMB Jennifer_E_Park@omb.eop.gov; Author author@noreply.github.com Subject: [EXTERNAL] Re: [GSA/sdg-indicators] Graph for yes/no indicators (#722)

I will do complete sweep through all indicators and prepare a list -- first thing in the morning.

Philip-- If you get a chance, please help with graph for indicator 17.4.1... blank graph ( because they completely changed indicators w/o notifying anyone in advance) Jen- I sent that email out yesterday because I was not able to reach Andrew via phone (to ask if Dennis reviewed/approved). I do not believe Andrew would be so bold as to do it himself. I will try to call him again tomorrow and will call Scott if I can't reach him. Lucky for him this fell in SDG17 (w/ no co-chair to annoy).

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<%3ehttps:/github.com/GSA/sdg-indicators/issues/722%3c#issuecomment-340953513>, or mute the thread<%3ehttps:/github.com/notifications/unsubscribe-auth/ATtsqsewwUP6ox39oYFlBzt5O7io55q3ks5sx8qvgaJpZM4QBNBP%3c>.