search

ONEcampaign / topic_health_financing

A repository for the Health Financing topic page
MIT License
0 stars 0 forks source link

Ideal spending chart (abjua) #17

Closed jm-rivera closed 1 year ago

jm-rivera commented 1 year ago

Chart 1 Based on Abuja (so government spending) The main message would be:

We would show:

Chart 2 Maybe TBC @nupur-parikh

_Originally posted by @jm-rivera in https://github.com/ONEcampaign/topic_health_financing/issues/3#issuecomment-1433196370_

jm-rivera commented 1 year ago

@lpicci96

jm-rivera commented 1 year ago

https://public.flourish.studio/visualisation/12815617/

What do you think of something like this @nupur-parikh?

image
nupur-parikh commented 1 year ago

thanks @jm-rivera, I like this in theory, but can we limit this to only AU member states? I was looking through some of the bars and it looks like it includes some other countries as well. There is also a lot to look at here, maybe we can group as such <2.5%, 2.5%-5%, 5-7.5%, 7.5%-10%, 10-12.5%, 12.5%-15%. or something like this? I do think it's hard to understand with each income category broken out like this, maybe with the above suggestions it will be condensed more.

the other suggestion would just be to remove the income level grouping and just look at all in one chart, with the popup as you have it showing the # of countries, countries names, and maybe the exact % for each country in ().

Also can you confirm that this is domestic government spending as a share of government spending and can you clarify if we can use 2020 data for this?

nupur-parikh commented 1 year ago

Chart 2 Maybe TBC @nupur-parikh

_Originally posted by @jm-rivera in #3 (comment)_

Can we still include a second chart for this? The targets would be:

  1. Domestic Government Spending on Health should be 5% of GDP
  2. Domestic Government Spending on Health should be at $86 per capita

Is it possible to show these on the same visualization, understanding that the units are different? Maybe something like this with annotations at each target? Thoughts @jm-rivera ? image

lpicci96 commented 1 year ago

I'm not sure where you are with this chart @jm-rivera , but I think it may work better as a beeswarm (income groups on y axis, gov spending on x axis). It gives more granularity while still showing the spread of the data, and gives you more annotation power. Optionally you can also overlay with violins

jm-rivera commented 1 year ago

I'm not sure where you are with this chart @jm-rivera , but I think it may work better as a beeswarm (income groups on y axis, gov spending on x axis). It gives more granularity while still showing the spread of the data, and gives you more annotation power. Optionally you can also overlay with violins

Very nice suggestion, thank you Luca! I think it will much more clearly show this indeed

jm-rivera commented 1 year ago

thanks @jm-rivera, I like this in theory, but can we limit this to only AU member states? I was looking through some of the bars and it looks like it includes some other countries as well. There is also a lot to look at here, maybe we can group as such <2.5%, 2.5%-5%, 5-7.5%, 7.5%-10%, 10-12.5%, 12.5%-15%. or something like this? I do think it's hard to understand with each income category broken out like this, maybe with the above suggestions it will be condensed more.

the other suggestion would just be to remove the income level grouping and just look at all in one chart, with the popup as you have it showing the # of countries, countries names, and maybe the exact % for each country in ().

Also can you confirm that this is domestic government spending as a share of government spending and can you clarify if we can use 2020 data for this?

Here's a new version, based on Luca's suggestion, which I think works a lot better. What do you think @nupur-parikh?

image https://public.flourish.studio/visualisation/12882824/

It is indeed based on 2020 data, and it's heath spending as a share of government spending.

nupur-parikh commented 1 year ago

Thank you both @jm-rivera @lpicci96 this is definitely much easier to understand and I like this a lot, great suggestion Luca! Just two things:

  1. Is this representative of AU member states? Or all countries? If the latter, can we switch to the former given the signees of the declaration were AU member states?
  2. Small thing: can we change the target line to say "Abuja Declaration"
jm-rivera commented 1 year ago

Yep can do. @nupur-parikh could you provide a list of AU members please?

nupur-parikh commented 1 year ago

This is the best list I could find @jm-rivera, https://au.int/en/member_states/countryprofiles2, I couldn't find one that was downloadable, does this work?

jm-rivera commented 1 year ago

Thanks @nupur-parikh.

Here it is just for those countries

image

https://public.flourish.studio/visualisation/12882824/

jm-rivera commented 1 year ago

What do you think @nupur-parikh? Another option could be to still show all the countries but highlight the abuja declaration countries. I fear this filtered version which only shows the abuja countries feels incomplete in terms of context

lpicci96 commented 1 year ago

@jm-rivera why don't you make those countries a darker shade of the same color and decrease the alpha of all other dots to make them more dull? so that you can still have all countries but you add another layer to highlight those countries

nupur-parikh commented 1 year ago

Thanks @jm-rivera for putting this together so quickly. I think you're highlighting a key tension in the health community about the relevance and context for using a target like this to measure health expenditure. I don't think it makes sense to show other countries in relation to this target though as this isn't something they all signed on too, which is why I have included the information on the Chatham House targets for all countries please see this comment:

Chart 2 Maybe TBC @nupur-parikh _Originally posted by @jm-rivera in #3 (comment)_

Can we still include a second chart for this? The targets would be:

  1. Domestic Government Spending on Health should be 5% of GDP
  2. Domestic Government Spending on Health should be at $86 per capita

Is it possible to show these on the same visualization, understanding that the units are different? Maybe something like this with annotations at each target? Thoughts @jm-rivera ? image

jm-rivera commented 1 year ago

@jm-rivera why don't you make those countries a darker shade of the same color and decrease the alpha of all other dots to make them more dull? so that you can still have all countries but you add another layer to highlight those countries

See Nupur's comment above just in case @lpicci96 !

jm-rivera commented 1 year ago

Is it possible to show these on the same visualization, understanding that the units are different? Maybe something like this with annotations at each target? Thoughts @jm-rivera ? image

Plotting Domestic Government Spending on Health should be 5% of GDP vs Domestic Government Spending on Health should be at $86 per capita wouldn't be appropriate. Basically you are plotting the same variable (government spending) but using two different scales to measure it. What you will end up seeing won't be differences in domestic government spending, but instead differences in population (since once is per capita) and gdp (since the other is a share of GDP).

We can have a scatterplots for these measures, but they would have to compare spending to something else. Are there any useful indicators that come to mind @nupur-parikh ?

nupur-parikh commented 1 year ago

Thank you, that makes sense @jm-rivera. There's nothing useful that comes to mind right away. These two targets are recommended to be used together, so I think the violin plot used above for the Abuja Declaration would look better for these targets and have a toggle between them like this: image

Also not so familiar with how this will look on the page/if this is possible with violin plots but would be helpful to also have a play button to show this over time. The goal (in my mind) would hopefully be to show how many countries have met both targets similar to this on the health topic page. image

jm-rivera commented 1 year ago

The Abuja chart with a time slider @nupur-parikh

image

https://public.flourish.studio/visualisation/12882824/

jm-rivera commented 1 year ago

Thank you, that makes sense @jm-rivera. There's nothing useful that comes to mind right away. These two targets are recommended to be used together, so I think the violin plot used above for the Abuja Declaration would look better for these targets and have a toggle between them like this: image

Also not so familiar with how this will look on the page/if this is possible with violin plots but would be helpful to also have a play button to show this over time. The goal (in my mind) would hopefully be to show how many countries have met both targets similar to this on the health topic page. image

Here is what that would look like for share of GDP @nupur-parikh. I've highlighted African countries but still split by income levels. How does that look?

image
jm-rivera commented 1 year ago

@nupur-parikh the challenge is one of scale on the per capita front. The amounts are two different by income level

image

so the chart would need to show them on a logarithmic scale

image

But that change cannot be done automatically. So in this case it would need to be two different charts. Which would also give us the opportunity to clearly highlight the two targets

jm-rivera commented 1 year ago

Here are then the individual charts

image

https://public.flourish.studio/visualisation/12896408/

image

https://public.flourish.studio/visualisation/12896098/

nupur-parikh commented 1 year ago

Thanks Jorge! The links you shared start at 2019 where as the images you shared start at 2020, am I looking in the right place? I

Overall, these are really great and so interesting to play around with, I like the way you've color coded the countries to stand out and I like how this shows the disparity between income groups at the same time. Noted on the issue with showing both together, are there other options in flourish or word press we can utilize to show how these two relate to each other? All I can think of is a scrolly but would love your thoughts on if this makes sense for two charts only?

jm-rivera commented 1 year ago

Thanks @nupur-parikh! Since they will be in the same section and will follow each other, may that be enough of a connection?

We don't really do scrollys for the topic pages since that makes it harder to get to the specific data you may want to look at.

Besides the 2020 issue (it's a broader Flourish issue apparently), anything else we should tweak before calling it a final draft for this section?

nupur-parikh commented 1 year ago

That makes sense! I'll make sure to keep the text clear and concise then to demonstrate how the targets should be interpreted.

Noted on the 2020 issue (so weird!), just one small thing on the Abuja Declaration one: can we just adjust the annotation line to say "Abuja Declaration Target"

For chart headings do we need to do that now, or does that happen when we build the page?

jm-rivera commented 1 year ago

Noted on the 2020 issue (so weird!), just one small thing on the Abuja Declaration one: can we just adjust the annotation line to say "Abuja Declaration Target"

Will do!

For chart headings do we need to do that now, or does that happen when we build the page?

When we build the page, but never too early to start thinking about them :)