search

urbanarchive / qpl-name-explorer

White label site for QPL Name Explorer
2 stars 2 forks source link

Airtable: Is there an easy way to see how many (unique) assets are on the U/A view? The U/A list on airtable includes rows on multiple pictures/comments #80

Open isaacbw opened 1 year ago

isaacbw commented 1 year ago

Airtable: Way to see unique assets locations

U/A view shows a row count that includes every picture (but there are sometimes more than one picture at a location) so they are getting counted as 2, when we really want to know how many unique locations there are.

QPL: "Is there an easy way to see how many (unique) assets are on the U/A view? The U/A list on airtable includes rows on multiple pictures/comments"

isaacbw commented 1 year ago

This is some "airtable magic" formula stuff rather than map development. I wonder if they'd be happy if the List number of asset types feature would fulfill this ask.

isaacbw commented 1 year ago

With the new amount of asset type in the list view helps solve part of this. The way that they've shown me how to do it is to download a csv of the data and remove duplicate geo coordinates... No need to overcomplicate things!