Chart: Sources of financing

[jm-rivera]

Display the composition of health spending. Provide an option to see by income level (and by country) (pre-select income levels but other individual countries can be added to view). Same as section1: over time. 2000/1 to 2020

Chart 1 needs to show:

• External aid (EXT)
• Domestic government spending (gghed)
• Out of pocket spending (oops)
• Other domestic private spending (pvtd - oops)

Chart 2:

comparison/difference between external aid and domestic government spending. What would be the best viz?

Could something like this work? And filter by income level or continent. Bubbles are individual countries

[jm-rivera]

Hey @nupur-parikh. Here is a draft of chart 1 https://public.flourish.studio/story/1842233/

What do you think?

[jm-rivera]

@nupur-parikh for chart two, based on what we discussed it would be something like this.

However, I'm not sure it shows something clear and easy to understand. What do you think?

[nupur-parikh]

Thanks @jm-rivera , these show some really interesting trends, however it's really hard to understand how each source of financing compares to the other with the tiles. But I love what this shows and that you're able to toggle between the three units, this is exactly what I had in mind! I think we can just make this section 1 chart. The line charts you made for chart one show exactly what I'd want to see for chart 2, so is there any way to combine the four tiles into one line chart with lines for each of the sources then a drop down (rather than multi-select) to select different income groups/countries?

Also will we still be able to add Africa as a group for these charts? Just want to confirm that option is still possible.

And lastly some small text related things, can we change the following:

1. "Government" to "Domestic Government"
2. "External" to "External Aid"
3. "Other private" to "Other domestic private"

[jm-rivera]

The line charts you made for chart one show exactly what I'd want to see for chart 2, so is there any way to combine the four tiles into one line chart with lines for each of the sources then a drop down (rather than multi-select) to select different income groups/countries?

@nupur-parikh just to confirm, 4 sources on 1 chart instead of a grid, with a single select for the groups/countries. And that instead of the current presentation right?

Also will we still be able to add Africa as a group for these charts? Just want to confirm that option is still possible.

Still possible but I need to see about the completeness of the data for all indicators to choose the right approach.

And lastly some small text related things, can we change the following:

1. "Government" to "Domestic Government"
2. "External" to "External Aid"
3. "Other private" to "Other domestic private"

Noted, will change!

[Mattie-P]

Hey @nupur-parikh. Here is a draft of chart 1 https://public.flourish.studio/story/1842233/

What do you think?

On this graph, I think its important to state how you are applying the income classifications in the notes - either keeping the groupings constant across years to the latest definition, or using the historical classifications. Sometimes it can be quite confusing if a big change (i.e. the significant drop for external financing) is down to a country changing income classification that year, or an actual change in financing.

[nupur-parikh]

The line charts you made for chart one show exactly what I'd want to see for chart 2, so is there any way to combine the four tiles into one line chart with lines for each of the sources then a drop down (rather than multi-select) to select different income groups/countries?

@nupur-parikh just to confirm, 4 sources on 1 chart instead of a grid, with a single select for the groups/countries. And that instead of the current presentation right?

Yes please if possible!

Also will we still be able to add Africa as a group for these charts? Just want to confirm that option is still possible.

Still possible but I need to see about the completeness of the data for all indicators to choose the right approach.

Got it, thank you!

[nupur-parikh]

Hey @nupur-parikh. Here is a draft of chart 1 https://public.flourish.studio/story/1842233/

What do you think?

On this graph, I think its important to state how you are applying the income classifications in the notes - either keeping the groupings constant across years to the latest definition, or using the historical classifications. Sometimes it can be quite confusing if a big change (i.e. the significant drop for external financing) is down to a country changing income classification that year, or an actual change in financing.

Great flag @Mattie-P! @jm-rivera how are we applying the income classification for this? Can we use 2020 WB classifications consistently across this page? Or would that make things more confusing?

[jm-rivera]

@nupur-parikh how's this? https://public.flourish.studio/story/1842233/

[nupur-parikh]

@nupur-parikh how's this? https://public.flourish.studio/story/1842233/

I like the lines together in one chart, can you by any chance put the toggle back at the top like this?

Is it possible to add "as a % of general government spending" and/or "as a % total health expenditure" for these sources? would be really helpful analysis.

Also very interesting to see this for LICs, I was under the impression that domestic government spending has been relatively level, are there are any outlier countries that could be influencing this or is this what we are actually seeing? Love to see my assumptions being challenged like this, this analysis has already been insanely helpful!

[jm-rivera]

I like the lines together in one chart, can you by any chance put the toggle back at the top like this?

Alas, we're at the limits of what Flourish can do for a single visualisation. We either have them as separate charts, or we have them as a grid of charts (like what I sent). But there is no way to add buttons + have 4 different series shown at once + allow filtering by country + have a full timeseries.

Is it possible to add "as a % of general government spending" and/or "as a % total health expenditure" for these sources? would be really helpful analysis.

Instead of any of these or in addition to them? If in addition, i'd encourage us to be a bit more selective in what we're showing. As it stands we're showing nearly 20K data points on this chart alone. We're probably at diminishing returns with adding more complexity vs how much users are likely to get out of it. What would be the 2-3 most meaningful ways to visualise the same data (currently we have total, per capita, share of gdp + potentially share of government spending and total health expenditure). Otherwise, I suggest we split this into two sets of views. One of them focuses only on percentages, and another one only on amounts (total and per capita).

Also very interesting to see this for LICs, I was under the impression that domestic government spending has been relatively level, are there are any outlier countries that could be influencing this or is this what we are actually seeing? Love to see my assumptions being challenged like this, this analysis has already been insanely helpful! !

Good catch - I wasn't removing Liberia. Check again please

[jm-rivera]

No never mind, I was removing Liberia. We would have to check the data more closely to figure out if there are any potentially strange countries

[nupur-parikh]

Thank you for clarifying all of this! I discussed with the rest of the health team and we've narrowed this down based on your great suggestions.

We have decided that it would just make sense to show 4 sources on 1 chart, with a single select for the groups/countries, and only showing the sources as a share of total health expenditure. We decided this way would be best as this is the one thing we are always asked about health financing. If possible in the pop-up, can we add the total USD there to allow users to access that info if needed? However, if not possible that's fine too!

Sorry for the confusion there and as always thank you for helping me think this through!

[jm-rivera]

Thank you for clarifying all of this! I discussed with the rest of the health team and we've narrowed this down based on your great suggestions.

We have decided that it would just make sense to show 4 sources on 1 chart, with a single select for the groups/countries, and only showing the sources as a share of total health expenditure. We decided this way would be best as this is the one thing we are always asked about health financing. If possible in the pop-up, can we add the total USD there to allow users to access that info if needed? However, if not possible that's fine too!

Sorry for the confusion there and as always thank you for helping me think this through!

Yes great idea on the pop-ups! I'll work on something new for you tomorrow

[nupur-parikh]

No never mind, I was removing Liberia. We would have to check the data more closely to figure out if there are any potentially strange countries

One more question on outliers, I looked at some of the charts again and Zimbabwe's figures also seem to be outliers: I referenced Gbemisola's methodology document for the DRM dashboard and looks like she excluded both Zimbabwe and Liberia from the analysis. What are you thoughts @jm-rivera ?

[jm-rivera]

Here's a new version @nupur-parikh https://public.flourish.studio/story/1842233/

This also excludes Zimbabwe. I remember looking at that point with Gbemisola. I think it deserves a bit of a closer investigation when we do the fact-checking process. For now we should exclude.

[nupur-parikh]

Here's a new version @nupur-parikh https://public.flourish.studio/story/1842233/

This is great @jm-rivera, thank you!!! Two very small things:

1. Can we change the y-axis label from "Share of Total (%) to "Share of Total health spending (%) for clarity?
2. Can we label every five years on the x-axis starting from 2000?

This also excludes Zimbabwe. I remember looking at that point with Gbemisola. I think it deserves a bit of a closer investigation when we do the fact-checking process. For now we should exclude.

Got it, thanks!

[jm-rivera]

Thanks @nupur-parikh, I updated the y-axis label.

As for the second one, would prefer we didn't. Still early days for this, but here's more about how we're trying to harmonise our visual identity

[nupur-parikh]

Thanks @jm-rivera, makes sense! I'm fine to leave the x-axis as it is based on what you shared.