1 Reply Latest reply: May 9, 2014 10:06 AM by Jonathan De Deken RSS

    Google Map - Date as dimension

    Clarissa Buda

      I have a google map created using a scatter graph.

      My data looks like excel file table attached.

      The issue I keep running into is that since I have multiple longitude/latitude values for the same area, my expression SUMS them together if I don't have a date selected. I want to be able to see all data points, regardless of date, but be able to narrow down to a date if necessary.

      How can I modify the expression to stop this from happening? I was thinking I needed to add an aggregate to it but I'm not sure how.

       

      my latitude and longitude expression formulas are as follows:

       

      latitude: 

      =

      sum(((256*pow(2,($(var_zoom)-1)))+((0.5*

      log((1+(

      sin((

      latitude)*

      pi()/180)))/(1-(

      sin((

      latitude)*

      pi()/180)))))*((-256*

      pow(2,

      $(var_zoom)))/(2*

      pi())))))

       

       

       

      longitude: 

      =

      sum( round (256*pow(2,($(var_zoom)-1)))+(

      longitude *((256*

      pow(2,

      $(var_zoom)))/360)))