Question

How sum fields in different explores?

  • 12 February 2019
  • 3 replies
  • 76 views

Hi All,

I tried use merged results to sum fields in diffrents explore, but not worked, there are other way to do this?


someone can help me please?


Regards,

Douglas Rezende


3 replies

Userlevel 4

Hey Douglas! I know finding information you need from Looker means alot to a data analyst. What error are you looking at? Are you able to screenshot and post it here so the community will be better able to assist you?


Just by any chance if you get this:



You will need to select the primary key to merge the 2 dataset on both view.


If you want to read more about merging in Looker. You can check out the documentation at https://docs.looker.com/exploring-data/exploring-data/merged-results#merging_queries

A transact SQL solved my problem.


Thanks a lot

May I ask how ‘transact SQL’ work please? I have sth similar need to tackle. 

Reply