PacificCommunity / Terria-PacificMap

Other
1 stars 2 forks source link

PacificMap SDMX - slices of data cube with no data #69

Closed AnaBelgun closed 3 weeks ago

AnaBelgun commented 3 years ago

PacificMap trying to display slices from data cubes which don’t have any data i.e reproductive health data for males, or women less than 15 or greater than 60.

Possible solution: using the indicator as the “primary” variable and then only displaying values for the other variables (sex, age etc) where data exists in the cube. Issue here may be processing required each time user changes indicator to filter valid parameters.

image Additional comments:

• #68: Last n periods is a query parameter that can be passed to the SDMX API

• #69: Some useful information can be collected from SDMX actual content constraints providing the list of codes used in a table rather than processing the dataset

nf-s commented 3 years ago

I have disabled the //Pacific Data Hub .Stat/dataflow-DF_HEALTH - Health indicators dataset. As the way the dataflow dimensions are structured isn't compatible with Terria.

For example

Here if we specify Sex = "Male" and Age = "15-49" we get

image

But if we change Sex or Age to Total we get nothing

Possible solutions

On Terria side we can disable the Age and Sex dimensions - but this means that indicators which have multiple Age/Sex values may not display correctly

On SPC side - add values for Sex = "Total" and Age = "All ages"

nf-s commented 3 years ago

Another example

Sustainable Development Goal 03 - Good Health and Well-Being**

Sex = "Female"

image

Sex = "Total"

image

nf-s commented 3 years ago

These SDG goals are quite problematic

image

All for the same reasons as outlined above:

Possible solutions

AnaBelgun commented 3 years ago

Update 21/10/2021: