2 Replies Latest reply on Dec 27, 2016 1:40 PM by marcin.m

    Problems with LOOKUP and mixing Non-Aggregated with Aggregated




      I am still quite new in Tableau. I am running into a problem with LOOKUP functions. I have a data source that gives me coordinates of fueling stations. I am trying to calculate a distance between two fueling transactions using a geometric formula. I am using LOOKUP to pull coordinates of a previous transaction. But in my geometric formula I am getting error for mixing Aggregated and Non-Aggregated items. I am not sure what that means. I have two questions: How do I fix it (i made an image with info that should help), and where can I learn more what aggregated vs. non-aggregated means (I also need to learn more about discrete and continous too).


      Thank you for help in advance


      Previous Lat.jpg