PCF Application relies on 2 workbooks published on Tableau Cloud, and available to a selection of Syensqo’s Users as per security requirements specified prior.


This document aims at navigating the data source panel as well as knowing how to reach underlying data from the source. But also, outline all computed elements on each dashboard currently available on all Tableau servers projects:

PCF - Product Carbon Footprint

PCF - Carbon Footprint - UAT

PCF - Product Carbon Footprint - DEV


  1. Data connection

             a. Service Account

While dashboards can have a User as project or workbook owner. Connection and extraction of data from Google big query will always be used from a dedicated Service account. Credentials need to be requested to and granted by CloudOps team.

These credentials will allow connection and data extraction from each GCP projects and are available on Google Drive. 




               b. Data Source Panel

Tableau workbook will only extract data from Google Big Query following the same model for all dashboards and each data source as seen below:



         2. PCF - Product Carbon Footprint Advanced Workbook

    1. Product List dashboard


               b. Product List Calculated fields


Please refer to the document:

 


              

                    c. Biogenic dashboard



                 d. Biogenic Calculated fields


Please refer to the document:


                 e. Breakdown dashboard



                 f. Biogenic Calculated fields



DatasourceTypeNameRemote_NameFormulaFields
DM_PURE_Core_HD_SERF_Yearlydimension[Get PURE Data][Calculation_232357629656440832]"Get Data" 
DM_PURE_Core_HD_SERF_Yearlydimension[Reset button][Calculation_232357629682872321]"Reset All Filters" 
DM_PURE_Core_HD_SERF_Yearlymeasure[Counter +1][Calculation_3313523471385870337][Parameters].[Counter] + 1 [Counter]
DM_PURE_Core_HD_SERF_Yearlymeasure[Counter Even/Odd][Calculation_3313523471392104450][Parameters].[Counter]%2 [Counter]



                 g. PURCHASE 



                  h. PURCHASE Calculations



DatasourceTypeNameRemote_NameFormulaFields
DM_Purchasingmeasure[Counter +1][Calculation_3313523471385870337][Parameters].[Counter] + 1 [Counter]
DM_Purchasingmeasure[Counter Even/Odd][Calculation_3313523471392104450][Parameters].[Counter]%2 [Counter]
DM_Purchasingdimension[Get data][Calculation_967711005884104706]"Get data" 



  1. PCF Related Dashboards


             a.Product List

                           1.Dashboard




                           2.Attributes Dependencies




           b.Product Details




           c.Product Breakdown




                d.Biogenic

                                 1.Dashboard



                                         2.Biogenic Dependencies



  

                   f.PCF & Breakdown Calculations


Refer to GSheet for Calc. details and definition

https://docs.google.com/spreadsheets/d/1IUHaIPGbNZJaqlNV2hD86hc3O4kklcDhCw89t1Jeh90/edit?usp=sharing


                 g. PCF - Product Carbon Footprint Advanced Workbook


                         h.Parameters

 

DatasourceTypeNameRemote_NameFormulaFields
Parametermeasure[Volume / Total CO2][PCF/Weighted PCF (copy)_313563185235230725]"Total CO2" 
Parametermeasure[Whitespace][Parameter 1 1]0.663831915957979 
Parametermeasure[Show/Hide][Parameter 1]"Energy" 
Parametermeasure[Counter][Parameter 2]144.0 
Parametermeasure[MatName/SiteName][Parameter 6]"MatName"