search

duxbuse / ninthage-data-analytics

A better way for the project to ingest tournament results
GNU General Public License v3.0
1 stars 0 forks source link

Blending datasources create too many front end limitations #123

Closed SanderND closed 1 year ago

SanderND commented 2 years ago

Blending two datasources in Tableau limits the development possibilities too much. Data should come pre-joined from GCS.

Join: static unit data to lists based on the name of the unit and name of the army.

SanderND commented 2 years ago

Working on this. Steps to take on GCS:

1) selfjoin to find opponents armyname in the TBL_TABLEAU_INTERFACE query: done 2) replace exclude join by a regular join which explicitly selects the fields i want in the TBL_TABLEAU_INTERFACE query: done 3) join the static data for only those columns i need in the TBL_TABLEAU_INTERFACE query: in progress. Making materialized views first, then join to lists. 4) test in Tableau 5) remove obsolete queries and put only one interface query in 'views' package.

duxbuse commented 2 years ago

@SanderND I think you managed this, is the ticket still required?

SanderND commented 2 years ago

Yes, im working on this. But its not finished. I need the correct version in the list data to properly join to the static data. When that is done i can try to close this issue.

Op 1 sep. 2022 om 13:38 heeft Sean @.***> het volgende geschreven:

 @SanderND I think you managed this, is the ticket still required?

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.

SanderND commented 1 year ago

Done!