Creating total spending visualisations

[jm-rivera]

Something like this by income:

Show the "world total" statistic next to the viz.

The main point of the viz is that:

• health spending has increased
• But very unequally (income level)

Add an option to see the country level data on demand like this

Two charts:

• Money (in constant USD) -% of GDP or Per capita

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

[jm-rivera]

@nupur-parikh Here's a view of two ways of calculating total per capita spending (constant prices).

• One is the total spending (constant usd) for the group divided by the total population for the group (for countries with available spending data for any given year)
• The other is taking the median per capita spending value (in constant usd) for the countries in each group.

The former is more 'reactive' to overall changes in spending in the group, as well as tracing the evolution of population in those groups. The latter is just the changes in the 'median' country for each group.

For this indicator, given that data coverage is pretty good (and stable), I say we present the group totals.

total_per_capita.xlsx

[jm-rivera]

Here's a first draft of the first chart. I've done it as per capita and total. However, the same base chart would work for % of GDP.

https://public.flourish.studio/story/1833879/

[jm-rivera]

And here, a chart like above, but in share of GDP terms:

https://public.flourish.studio/story/1834011/

[nupur-parikh]

Thanks @jm-rivera these are really intriguing! I really like how these are set up and easy to use/understandable. Really interesting to see how much Low-income countries spend on health as a share of GDP and how that has fluctuated over time. Will probably need to note somewhere in the text next to the visualization or for the header that this is health financing from all sources.

Does Flourish give you the option to include the share of GDP as a third view to the first chart? I realize the x-axis are different so this is probably not possible, but if it is, would be great to show all in one so users could toggle back and forth.

[jm-rivera]

I had a long debate with myself about 1 vs 2 charts to incorporate GDP. In short, we can, but then this axis annotation has to go

meaning that the y axis can be anything from %s, to units, to billions... which may be a bit confusing. But it would improve the user experience, having all views in the same chart.

Would that be ok with you?

And new question - do we add 'Africa' to the options? Right now is income levels and individual countries

[nupur-parikh]

Hmm okay I see, can the pop-up still say what the indicator is if we combine all into one? Like this?

Yes can please we add Africa to the options, thank you for flagging. Can this go at the top of the list in the drop down with income groups? Just so you know they are there without having to scroll?

[jm-rivera]

Yes I can find a few places to make the units very clear, so it should be fine.

Yes can please we add Africa to the options, thank you for flagging. Can this go at the top of the list in the drop down with income groups? Just so you know they are there without having to scroll?

Alas, Flourish stubbornly sorts the lists alphabetically. But I can add them to the ones selected by default, so here we would have the incomes + Africa

[nupur-parikh]

Okay great, I think if we can find a way to make the units very clear then we should include all 3 in one chart. If not, then I'm happy to go with what you had originally shared!

And got it, fine by me to include as a default selection, thanks for clarifying!

[jm-rivera]

@nupur-parikh Here's a view of two ways of calculating total per capita spending (constant prices).

• One is the total spending (constant usd) for the group divided by the total population for the group (for countries with available spending data for any given year)
• The other is taking the median per capita spending value (in constant usd) for the countries in each group.

The former is more 'reactive' to overall changes in spending in the group, as well as tracing the evolution of population in those groups. The latter is just the changes in the 'median' country for each group.

For this indicator, given that data coverage is pretty good (and stable), I say we present the group totals.

total_per_capita.xlsx

This is the spreadsheet on the link above @nupur-parikh

[nupur-parikh]

@jm-rivera is it possible also to total health spending as a share of total government spending? Same groupings as the rest of these and same time frame. Understanding that we can't add a fourth toggle to the chart maybe this is a whole new chart we show, this would basically help us understand what health's prioritization is for governments. The inspiration for this chart came from this excellent one from the debt page:

Let me know if you think we're showing too much information for this section and I'll go back to the team to brainstorm how to be more selective about what we're showing.

[jm-rivera]

How does this look? https://public.flourish.studio/story/1834011/

I think these 4 on 1 chart is fine. In the end we're showing only 1 indicator (health spending), just as 4 different 'views'. But up to you if you want to split it into two charts, for example, one for money (total and per capita) and one for shares (gdp and spending). Let me know @nupur-parikh

[nupur-parikh]

Thanks @jm-rivera, I think lets leave it as 4 in one. Really interesting to see low income countries that high and upper middle income countries so low. Based on the WHO data, I was under the impression that low income countries had the lowest prioritization of health, but I guess this may be different because we're showing the median instead of the mean?

Also flagging that Zimbabwe is included in this chart, I know we discussed excluding in a different chart.