
1. Re: Calculating Average from two datasources (SQL & Excel)
Deepak Rai Feb 1, 2018 12:27 PM (in response to Virginie Bocard)You can either Join your datasources or do blending on some common field and can do calculations. For joining use Cross data base join between SQL DB and EXcel on common field.
Here is It:
Integrate your data with crossdatabase joins in Tableau 10  Tableau Software
For Blending, Use this:
Thanks
Deepak

2. Re: Calculating Average from two datasources (SQL & Excel)
Virginie Bocard Feb 1, 2018 12:38 PM (in response to Deepak Rai)Thanks! But my problem is that I do not have a common field between the two sources? What would be a way to do the calculation then?

3. Re: Calculating Average from two datasources (SQL & Excel)
Deepak Rai Feb 1, 2018 12:45 PM (in response to Virginie Bocard)If you are after 10.3 Version use Join Calculation to Join using 1 on 1.
Follow this:
Joining 2 EXCEL Sheets together with no common fields
Thanks
Deepak

4. Re: Calculating Average from two datasources (SQL & Excel)
Virginie Bocard Feb 1, 2018 12:49 PM (in response to Deepak Rai)Thanks but I’m on 10v1 unfortunately so I can’t take a look. Can we create a calculation?

5. Re: Calculating Average from two datasources (SQL & Excel)
Deepak Rai Feb 1, 2018 12:52 PM (in response to Virginie Bocard)In that case you need to add a Column to both your data sources which should have a value of 1 only across all rows . Then you can join...Cumbersome but works...

6. Re: Calculating Average from two datasources (SQL & Excel)
Virginie Bocard Feb 1, 2018 12:54 PM (in response to Deepak Rai)Thank you for your time. But this is not an option as I don’t have access to modify the SQL datasource ;(
Cheers,
Virginie
Virginie D. Bocard
ITSCS – Program, Initiatives & Analytics Team
ITIL© Certified
Respectful Workplace Advisor for ITS
T +1 (202) 4739665
E vbocard@worldbankgroup.org<mailto:vbocard@worldbankgroup.org>
vbocard
1818 H Street, NW; Washington, DC, 20433
Questions on RWA’s role? Click for more information<http://spcapps.worldbank.org/sites/IJS/SitePages/RespectfulWorkAdvisor.aspx>

image002.png 359 bytes

image001.jpg 2.7 KB


7. Re: Calculating Average from two datasources (SQL & Excel)
Virginie Bocard Feb 1, 2018 1:37 PM (in response to Virginie Bocard)Just to clarify. I do not have a common field nor cannot add one to the SQL data source. Would it be possible then to write a formula that would say something like that:
if assigned group = AFR then sum and divide by 62
if assigned group = EAP then sum and divide by 43 etc. ?
Also would it be possible to graph the results of the calculation?
Thank you for your input.

8. Re: Calculating Average from two datasources (SQL & Excel)
Deepak Rai Feb 1, 2018 1:40 PM (in response to Virginie Bocard)You can do anything if you have data in one place...These are disjointed sources...won't work alone what you are looking for...