search

devinit / datahub-cms

A better organised version of https://github.com/devinit/digital-platform to act as a CMS for the Data Hub
0 stars 5 forks source link

What's the source of data for "What is the total revenue of x?" chart, digital recipient profile? #5

Closed epicallan closed 7 years ago

dw8547 commented 7 years ago

@epicallan, which section of the DH?

dw8547 commented 7 years ago

I have the following:

database schema data_hub_tab data_hub_visualisation table
ddw digital_profile recipient_country_profile Government finance: What is the total revenue of x? domestic
ddw digital_profile recipient_country_profile Government finance: What is the total revenue of x? warehouse/fact/gdp_usd_2015
epicallan commented 7 years ago

Hi @dw8547

Both the figures in the domestic and GDP table are ways of getting this value, my question is which table do we use. The code in the current live datahub wasn't clear in some way about which table to use, as if it had errors. Thats why this issue is here.

cc @BeckyWillmoth @kb4777

dw8547 commented 7 years ago

@epicallan, the analysts were to clarify this in January but I don't recall hearing back on the issue so don't know now. Will chase.

dw8547 commented 7 years ago

@epicallan, the metadata in the web app indicates that we settled for domestic.csv.

epicallan commented 7 years ago

cool thanks @dw8547