Data Analyst Journey / Merge Query Feature

[walbuc]

From Cesar input:

Thanks Walter
Here are a few tables I would like to be able to build at the OEC and DataUSA, which are two sites I know rather well. I am providing the goal of what we would like to have, but I understand that we may hit incomplete versions of this goal first. It is a rather ambitious goal. What I don't want is to have a false goal, because I've seen that sometimes at DW we stop at the first iteration, thinking that this is the end (and then we start reworking the software for that first step and never get to step 2).
At the OEC, I would love to be able to build the following tables
1.
Country | Year | ECI | GDP per capita | GDP per capita (Year + 10) | Population | Diversity | Total Exports | Growth of Exports Between Year and Year +10 | Natural Resource Exports
2.
Subnat 1 (E.g. autonomous communities in Spain, states in the US, Brazil. China, etc...) | Year | Product | ECI | PCI | Exports of subnat in that product-year | Exports of subnat in that product-year+10 | Relatedness of subnat in that product year | Relative relatedness of subnat in that product year | RCA of subnat in that product year

In DataUSA
County | Year | Obesity | Poverty | Income | Average Commute Times | Population Density | Average Age | Obesity (year + 5)
Let me know if these are clear.

Thanks!

---

For new Complexity Endpoint:

I was trying to get relatedness values for Spain from the Data Explorer, but these are not available. We do have them in Cotec and in the OEC, so they are part of the derived values we can create, but they are not available in the data explorer. This was in an attempt to satisfy a client request. So it would be good if the "add column" feature would also include derived quantities, such as relatedness, relative relatedness, PCI, ECI, etc.