![Marc Reid](/img/default-banner.jpg)
- 16
- 109 519
Marc Reid
United Kingdom
Приєднався 5 сер 2018
Tableau Tips and Tutorials
I'm a Tableau Desktop and Server certified data analyst sharing Tableau content on my blog (datavis.blog) and here on this channel. If that's of interest, go ahead and subscribe and if you have any feedback or video requests, let me know in the comments. Thanks.
BLOG: datavis.blog ➝ Tableau tips and tutorials
WHO AM I: datavis.blog/about/
TWITTER: datavisblog
PORTFOLIO: public.tableau.com/app/profile/marc.reid#!/
LINKEDIN: www.linkedin.com/in/marcreiduk/
I'm a Tableau Desktop and Server certified data analyst sharing Tableau content on my blog (datavis.blog) and here on this channel. If that's of interest, go ahead and subscribe and if you have any feedback or video requests, let me know in the comments. Thanks.
BLOG: datavis.blog ➝ Tableau tips and tutorials
WHO AM I: datavis.blog/about/
TWITTER: datavisblog
PORTFOLIO: public.tableau.com/app/profile/marc.reid#!/
LINKEDIN: www.linkedin.com/in/marcreiduk/
How to create a Dot Plot in Tableau
This short video steps through how I created this dot plot dashboard in Tableau.
📑 Blog post
datavis.blog/2023/02/28/dot-plots-in-tableau/
📊 Visualisations
tabsoft.co/3Za7Nhi
💾 Data sources
data.world/makeovermonday/2023w9
▶ Subscribe for the latest tips and tutorials: bit.ly/TableauTutorials
🔗 Social Media
Blog: datavis.blog ➝ Tableau tips and tutorials
Twitter: datavisblog ➝ Follow for new blog & video posts
Portfolio: public.tableau.com/app/profile/marc.reid#!/
LinkedIn: www.linkedin.com/in/marcreiduk/
📑 Blog post
datavis.blog/2023/02/28/dot-plots-in-tableau/
📊 Visualisations
tabsoft.co/3Za7Nhi
💾 Data sources
data.world/makeovermonday/2023w9
▶ Subscribe for the latest tips and tutorials: bit.ly/TableauTutorials
🔗 Social Media
Blog: datavis.blog ➝ Tableau tips and tutorials
Twitter: datavisblog ➝ Follow for new blog & video posts
Portfolio: public.tableau.com/app/profile/marc.reid#!/
LinkedIn: www.linkedin.com/in/marcreiduk/
Переглядів: 2 516
Відео
Tableau Image Role + Cloudinary = data driven images
Переглядів 1,5 тис.Рік тому
The Image Role feature in Tableau let’s you show images directly in headers in your visualisation using a URL to a web hosted image. With Cloudinary you can dynamically generate modified images by adding parameters to those URLs. This video walks through an example with profile pictures for sales people on a simple business dashboard. 📊 Visualisations Image Role dashboard: To be added here. 📑 B...
Tableau INTERSECTS() Spatial Function Tutorial
Переглядів 3,1 тис.Рік тому
This new spatial function, introduced in v2022.4, makes it possible to determine if two spatial objects overlap without needing to perform a spatial join. This video steps through two examples: Point & Polygon and Point & Line - showing how to use the new function in calculations and for encoding marks in the view. 📑 Blog post Intersects Spatial Function: datavis.blog/2022/12/28/intersects-spat...
Dynamic Zone Visibility - Full Dashboard Tutorial with instructions
Переглядів 9 тис.Рік тому
Dynamic Zone Visibility (DZV) is a real game changer for creating more customised and personalised dashboards in Tableau. This video walks through how I created a dashboard with five dynamic containers, each containing charts relevant to a particular analysis scenario. See below for more information and instructions. 📊 Visualisations DZV Dashboard: bit.ly/3P932QI 📑 Blog post DZV Overview: datav...
Dynamic Zone Visibility in Tableau 2022.3 - Example use cases
Переглядів 6 тис.Рік тому
The Dynamic Zone Visibility feature allows you to dynamically show different charts, objects and containers based on the value of a calculation or parameter. This video walks through a few scenarios of how it might be used. Future videos will walk through how to create similar examples in more detail, creating the calculations needed etc. Blog Post with more details including three key things t...
Custom Number Formatting with Unicode characters in Tableau
Переглядів 2 тис.Рік тому
The formatting cheat sheet is linked below. Custom number formatting in Tableau provides lots of flexibility for displaying the same data in many different ways. See the two blog posts below for many examples with formatting codes you can copy and paste. 📑 Blog posts Part 1: datavis.blog/2022/07/31/tableau-custom-number-formatting/ Part 2: datavis.blog/2022/08/28/tableau-custom-number-formattin...
Create a disappearing container in Tableau
Переглядів 2 тис.2 роки тому
Have you ever wanted to display a message in a window when your dashboard first loads that the user can easily close never to see again? This short video tutorial shows you how you can do just that! 📊 Visualisations Top 20 Nasdaq Stocks: tabsoft.co/3s7kquK 📑 Blog post Disappearing Container: datavis.blog/2022/06/30/create-a-disappearing-container-in-tableau/ 🔗 Social Media Blog: datavis.blog ➝ ...
Customise Tableau Viz-in-tooltips - Add a dynamic reference line to a viz-in-tooltip
Переглядів 2,8 тис.2 роки тому
The default viz-in-tooltip will show data that matches the dimension values of the underlying data point (mark) that you hover over. This video shows you how to change this default behaviour, removing the filter and adding a dynamic reference line to the viz-in-tooltip using a parameter action. 📊 Visualisations Superstore Example: tabsoft.co/3FubwNm Top 20 Nasdaq Stocks: tabsoft.co/3s7kquK 📑 Bl...
Creating Horizon Charts in Tableau - Tutorial & Template workbook
Переглядів 1,7 тис.2 роки тому
Horizon charts are useful for showing many data series in a relatively compact space while still being able to see the dominant trends. This video gives an introduction to the chart type and then a step-by-step tutorial for quickly creating a horizon chart in Tableau by copying all the required calculations from a template workbook. 💾 Data sources Nasdaq Stocks: support.google.com/docs/answer/3...
How to create a custom Mapbox map and use in a Tableau dashboard
Переглядів 8 тис.2 роки тому
Mapbox maps are highly customisable and enable you to create the perfect map to integrate into you Tableau visualisation. This tutorial steps through how to create new map style in Mapbox, how to publish the map and then create a map URL to allow the map to be used in Tableau. 📊 Visualisations Singapore National Day: tabsoft.co/33BOSld Travel Map: tabsoft.co/2IRCYfn 📑 Blog post Using Custom Map...
How to create flight paths in Tableau by drawing lines & points on a map with MAKEPOINT and MAKELINE
Переглядів 16 тис.2 роки тому
A step-by-step guide to creating flight path maps in Tableau including links to the source data and a complete workbook to download. We'll walk through how to use the MAKEPOINT and MAKELINE functions in Tableau calculations. 💾 Data sources Flight data from The OpenSky Network: bit.ly/3i4YYkE 📊 Visualisations Creating Flight Paths in Tableau: tabsoft.co/3t9GtSA Dynamic use of MAKELINE with param...
Calculate the AREA of your polygons in Tableau and then create charts to compare the sizes.
Переглядів 3,5 тис.2 роки тому
Using the AREA function in calculations enables you to build charts based on the total surface area of the polygons in your spatial files. This opens up new analytical opportunities and different ways to view and analyse your spatial data. I walk through a few examples with three different spatial sources. 💾 Data sources OS Data Hub: bit.ly/3M7kWBg (select the ESRI Shapefile format) Historic En...
Tableau BUFFER functions - a complete TUTORIAL on using buffers for spatial analysis
Переглядів 12 тис.2 роки тому
In this in-depth tutorial I walk through how to use various Tableau spatial functions (Buffer, MakePoint, Distance) as part of an interactive geospatial analysis to determine how many Airbnbs there are within 500 metres of EV charging points in London. 💾 Data sources Airbnb data: insideairbnb.com/get-the-data.html Charging points: data.gov.uk/dataset/1ce239a6-d720-4305-ab52-17793fedfac3/nationa...
Creating Spatial Joins in Tableau - a TUTORIAL on joining polygons and points in Tableau
Переглядів 11 тис.2 роки тому
Learn how to create a spatial join in Tableau between two spatial files, one with polygons and one with points. I'll also step through how to create an interactive dashboard to filter the spatial data and highlight it on a map with two map layers. Related blog post with explanatory images and an introduction to spatial joins: bit.ly/3HF8vdc 💾 Data sources Link to the Mauritius spatial data if y...
Tableau Map Layers - an in-depth TUTORIAL on using Map Layers to show Points, Lines and Polygons
Переглядів 27 тис.2 роки тому
Learn how to use map layers in Tableau to create a 3-layer map with polygons, lines and points and also how to use the different map layer options. 💾 Data sources Link to the Mauritius spatial data if you want to follow along: bit.ly/32AAlIt 📊 Visualisations Completed workbook on Tableau Public: tabsoft.co/32SqmOJ 📌 Chapters 00:00 - Start 00:28 - Dual Axis Maps (prior to map layers) 00:57 - Map...
Thanks so much for this video. My join is not working. I receive an error that states "The join field [Calculation] is a spatial column and must use a spatial comparison. I've set both of them as spatial calculations. I'm quite confused here.
I figured it out. I needed to change my equals sign to "intersects".
Can you please provide a link to the exact dataset?
Hello Marc, My points are working perfectly fine but the flight path is giving me NULL, any idea why ?
Hi - It's quite difficult to debug that kind of issue here in the comments. I'd recommend posting on the Tableau Forums where you can also upload your workbook as it will be much easier for someone to diagnose. Thanks. community.tableau.com/s/explore-forums
Can you please tell me which data to download, when I open the link you provided in the description I don't know which data you took, it's frustrating that I cannot find the correct data, I can't follow you.
I no longer have the exact links as this was some time ago, but from the linked page is you search for these you should find them or similar data sources: 1. Admin Areas (polygons). 2. Roads and streets (lines). 3. Educational facilities (points)
Simply amazing on how you start telling the story.
Thanks! Glad it was useful.
Amazing playlist for a newbie on tableau. One question, if possible: how to highlite/select an administrative area on the map and show how how many educational facilities are there ? Thanks a lot !
Thanks for the kind words. You could put a count of facilities on to the tooltip of the admin area layer, then when you hover you'd see that number. Hope that helps.
@@MarcReid Thanks a lot !
Amazing tutorial - shows the right mind can extract the best from tableau!
How do i reduce the arc curve so that it is not out of the map bounds?
It's not possible to adjust the arc that Tableau creates between two specified points. It's generated algorithmically
Hi Marc, thanks for the informative video, it is really helpful. I have used the above for creating a geo map between Members and Zip Codes. We generally host events at specific Zip codes and hence need to find out members which reside within 5/10/20 mile radius of that Zip code . I have created the join using the below I have two data sources : Member and Zip Code Columns in Zip Code dataset include : First5 (which are the Zip Codes), Zip5 latitude, Zip5 longitude . Columns in Member include : Member Id, Mem_lat, Mem_long, Zip5 latitude, Zip5 longitude, First5 . inorder to find members within a specific radius i have used both the tables by joining them using : i used the below in the member table- Makepoint( Mem_latitude,Mem_longitude) intersects i used the below in the Zip Code table- BUFFER(MAKEPOINT([Latitude],[Longitude]),5,"miles") After which , i used right join , in order to ensure that in my geo map, I get both : Members in range Members out of range However , in the geo map when I add members IN range + Out range , there is difference of around 40 members.Please can you help me with it
Hi - It's quite difficult to debug that kind of issue here in the comments. I'd recommend posting on the Tableau Forums where you can also upload your workbook as it will be much easier for someone to diagnose. Thanks. community.tableau.com/s/explore-forums
How can we add a filter for only one of the layers of the map? For example, I want to color all the province of a country based on sum(value) but then make a shape for the provinces that are bigger than 5 (for example).
something like: IF value>5 THEN [GEOGRAPHY] ELSE NULL END. If that doesn't work / not what you meant, then I'd recommend posting on the Tableau forums with an example workbook.
@@MarcReid yes sir, that worked. Thank you!
How would you go about integrating a Via point in the O&D? Is it possible
Thanks Marc. This is really helpful. I have the same issue that @roiargaman850 raised a year ago. The In Range calculation does not color points correctly if distance parameter value is less than maximum available value. When parameter is at maximum everything works perfectly. However, when parameter value is less than maximum some points are not being colored correctly. For example, I can clearly see some points are within range of buffer 1 but colored gray because, for some reason, the distance is calculated from buffer 2, which is further away and that's why it's being colored gray. I know some people raised this question a while ago. I wonder if you heard any resolution to this issue. Thanks again for the excellent tutorial!
Hi Tom, it's difficult to debug these kinds of issues here. I'd recommend posting on the Tableau forums and attaching a packaged workbook. It will be easier for someone to explore the issue in detail. Thanks. community.tableau.com/s/explore-forums
Thanks for the video Marc. I learned a lot from your video and I used it for one of my projects. Everything works well except sometimes when buffers overlap and distance parameter is less than maximum value Tableau does not color buffers correctly. For some buffers the distance is clearly less than chosen parameter value but it colors gray (false). Seems like Tableau is picking the distance from other overlapping point. But when use a table view, the distances and true false conditions are correct. I tried to use different LODs to color correctly all points within all overlapping bufferes but no luck. Do you know what could be the issue? I think it might be Tableau glitch. Thanks.
Tableau is written in an Alien language.
Beautifully Explained. Behtreen :) Keep it up so we can learn more. Never got this extent of explanation :)
Thanks! Glad to hear it was useful
Hi Marc, great video. Really appreciate this!! Im wondering how to do this exercise if the two datasets are already in one reference excel file. For example, if ev charging points data and airbnb data are stacked in 1 excel. I attempted this by creating new calculation field and was able to get ev charging location and airbnb location ok (using if function to slice the data) but i was not able to get the distance function to output anything. The distance function calculation was valid but it doesnt show anything. I think the problem is I did not join anything at all (your case, you had to join the data from two files or table and chose intersect and so on). For my data, there isnt anything to join at the datasource level. Is there a way to join the data at the field level? Sorry for bombarding you with this but please help a lad out. Thank you!
Hi Nicccy - yes, you need two sources to make the join. Can you separate the data out into two separate sources? If not, you could duplicate the source - connect to it twice - and filter each source to the relevant data then make the join. Hope that helps.
That's impressive work! I'm particularly curious about the images that appear when hovering over map points. How did you achieve that?
See this blog post for more on using images in Tableau. Hope it helps! datavis.blog/2020/12/24/five-ways-to-use-images-in-tableau/
Refreshing ! Now, I will go blow some minds.👍
HA! Thank you for explaining this in the context of the old dual axis map approach. I’m rebuilding an old dashboard designed back in Tableau 6.0 and was about to refresh my knowhow on dual axis maps. Map layers and your video make things A LOT easier!
Great to hear, James!
Thank you! My group project was having trouble combining latitude and longitude data with spatial data. It would cause an error with the dual axys method. This one is the perfect method for what we were looking for!
Glad it helped!
Very nicely explained. Thanks a lot!
Thanks! Glad to hear it was helpful.
Hi Marc, thanks a lot for this video! I have a question, if I want to see how many Airbnbs are in a buffer around other Airbnb (skipping the part with EV stations). Do I need to duplicate the source and join them with Intersects or is there simpler solution?
Hi - yes, I think a self join would be the way to go. Essentially it's a row level calculation so both points to be on the same row.
@MarcReid Thank you very much for this tutorial, although it has been online a while, it is extremely helpful. And this comment is extremely important, because I got the impression from other tutorials that it is possible do to these calculations with different rows. However, I tried to check if there is any point within a (rather large) series of overlapping buffers and failed. Due to the multiplication in the intersects this seems to be tricky, because every buffer have true and false intersects. Has anyone an idea how I can identify the buffers with no points within a defined range?
Thank you Marc, You made my day!
Hi Marc, big fan here, your mapping tutorials have been a huge help for a project I'm working on, thanks! Quick question, at the beginning you joined both datasets using intersect and an inner join, this join returned all the points inside the buffer but in my application I need to see the points inside and outside the buffer, how can I do that? Thanks! 🙏🏼
Hi Adolfo - thanks for the kind words. You should be able to use an outer (or right) join to include those points that don't intersect. If you still see issues, I'd recommend posting on the forums along with your workbook so someone can take a closer look. Hope that helps.
I have the problem in overlayed maps where adding a filter forces the top layer to disappear - what could I be doing wrong?
I'm not really sure what the issue is here. I'd recommend posting the question on the Tableau forums where you can also upload your workbook for the best support: community.tableau.com/s/explore-forums
Thank you for this tutorial, if i may ask, I have a data set with a column of values, some values has 1k , 2k and some normal decimal 500, 600, how do i normalise this column to be all decimal not string so i can apply calculations?
Hi - I'd recommend posting this question on the Tableau forums: community.tableau.com/s/explore-forums
Thanks a lot ! This is really helpful
Thanks!
Thank you Marc for this video. It's the best about DZV I've watched. Thank you also for the numerous tips scattered across the video. I've learned a lot despite the fact that I'm using Tableau for several years now 🙂
Hey Alain, thanks for the comment! Great to hear it was useful.
What a good surprise! This is my native island!
The disable selection tool isn't available in the Tableau 2023.1.0. How can I find it? Thank you!
Please can you confirm what you mean? thanks.
After you added the third layer on the map, you went on to disable selection on the map (time: 05:45). I created a dual-axis map on my worksheet in Tableau, but the layer of the map I imported from a spatial data (shapefile) is still enabling selection. How do I disable the selection? The version of the tableau I use is 2023.1.0. Thank you. @@MarcReid
@@MarcReid After you added the third layer on the map, you went on to disable selection on the map (time: 05:45). I created a dual-axis map on my worksheet in Tableau, but the layer of the map I imported from a spatial data (shapefile) is still enabling selection. How do I disable the selection? The version of the tableau I use is 2023.1.0. Thank you.
Thanks for clarifying. at this time stamp (6:06) ua-cam.com/video/ppo3d9HFMrc/v-deo.htmlsi=NZ84EuD6KkbzhwJH&t=362 I select "Disable selection" from the drop down menu. Are you seeing that option?
@@MarcReid Thank you so much for your response, but the drop down option is not available in my Tableau version which is 2023.1.0. How else can I go about it? Thank you.
Excellent presentation thank you very much. Struggled a bit transitioning from my 2019.1. This helped loads!!
Great to hear. Glad it was useful.
Hey Marc! This video is seriously the most helpful and informative tutorial I've ever come across, so I seriously appreciate it! Quick question in my case is that for my "In Range" calculation, my "AirBnB" locations are currently showing up as both true and false for in range and I can't figure out why. Any ideas?
Hi Scott, thanks for the kind words - much appreciated. It will depend on your data and how you've configured the join (inner, left, outer), but if a point meets the join criteria for multiple buffers, you'll get multiple rows. To ensure the True rows are on top, you might need to reorder the values in the colour legend (top right in the video), you can click and drag them. Hope that helps. If not, the best thing to do is open a case on the Tableau forums so the workbook can be shared (community.tableau.com/s/explore-forums), there's generally a very quick response.
@@MarcReid Thanks for the quick response man, made me an instant subscriber. Yeah I'd suspect something must be going on with my joins. When I make the "In Range" field a filter and have it set to true, the color's reflect appropriately along with the accurate distances being displayed. However, when I set it to All, the distances get really wonky and begin to calculate for other locations rather than the one it's "within range" of I'm guessing. I'll go ahead and try to switch away from an inner join if that works. What do you mean by "To ensure the True rows are on top, you might need to reorder the values in the colour legend (top right in the video), you can click and drag them"? in case you have another moment?
@@scottgill1515- the odd numbers you are seeing might be the aggregation of values for the dupe rows. (see this timestamp for more: ua-cam.com/video/pqb6RMGFVl0/v-deo.htmlsi=5RNz5uDjy1R-aIlg&t=500). re the colour reordering, if you have one point in range of one buffer but out of range of a second buffer (true and false), those two points will overlap on the map so you'll true or false on top depending on the z-order depending on how the colours are sorted, which you can change by dragging the colours in the legend to change. Hope that makes sense.
@@MarcReid You are the smartest man alive!! No fix needed with the join just needed to re-order the color legend like you suggested haha. Have no idea how you figured that out but it's awesome. I appreciate you so much!
@@scottgill1515 - 🙂 Happy to help.
how would you go about adding the total number of flights from one specific location to another in the tooltip? for example there are 30 flights from LAX on one day, I want to show how many of those flights went to JFK when you hover on that specific flight path.
I haven't looked at this data in a long time but I'll assume there is a flight Id field there in which case you could create a calc: COUNTD(Flight_ID) and put that on the tooltip. Alternatively, you could create a bar chart showing the number of flights between each origin and destination and use that as a viz-in-tooltip, filtering on the origin when you show the tooltip. (see Tableau's help page on viz in tooltip to learn more).
Marc, thanks a lot for the video, tried to repeat but how to make the names of the chain the same color as the circles? It was left behind the scenes in the video.
Hi - see this help page for a screen shot and description: help.tableau.com/current/pro/desktop/en-us/annotations_marklabels_showhideworksheet.htm#format-mark-labels:~:text=click%20Match%20Mark%20Color
@@MarcReid Oh, it worked 'Match Mark Color'. Thanks a lot, data community is splendid!
You are amazing
This is exactly what I needed. Thanks so much for explaining this so thoroughly!
That's great to hear. Thanks for the feedback.
Thank you so much, really good explanation
Thanks!
@@MarcReid Is there a way to make the arrows straight and to see the direction of the arrows ?
@@lavaforce-overwatchmoments9848 - the lines will always be curved to represent the curvature of the earth, though this will be less noticeable for shorter distances. you could create a new map layer with spatial points to indicate the start of the lines (use the same lat/long you are using to create the lines).
Hi, I am able to see the layer control icon and it is not showing up under map options as well. Do I need to update? how do I get this feature??
Hi - the layer control was introduced in 2021.2. See this video for more info: ua-cam.com/video/g6Ikidt8taQ/v-deo.html
thank you, this is great visualization. May I kindly ask what is Row _ID? and what does 'marks' means in left-bottom corner ? thank you.
Thanks. Row ID is a unique value for each of the data. A mark is how Tableau renders data in the view - it could be a bar, line, circle or shape for example. That counter tells you how many marks are being rendered in the view.
Thanks for sharing. How can we show negative values on "hh:mm:ss" format please ?
I think this forum post will help guide you in the right direction: community.tableau.com/s/question/0D54T00000C5yWvSAJ/time-difference-is-displayed-as-negative
Thanks for sharing, Marc! As you did, I couldn't get the X "click" inside the container. However, once I had the X in the container, I changed it from floating to fixed, and it did the trick.
I seem to have an issue that when clicking the 'X' the hamburger button to reshow the box remains...? Anyone know how to get rid of this?
It's hard to say without seeing your workbook. Feel free to download the workbook at the link in the description to see a working example.
Marc, this is amazing, thx! It works great except for some performance issues: We are searching for gastronomy from OpenStreetMap in 500 m radius of Airbnbs & every query takes forever to load. Do you have some tips for us to make our dashboard more presentable? Greetings from Berlin
Hi - thanks for the feedback. Spatial joins can be slow if you're working with a lot of data especially if points are contained within multiple buffers as you are then creating multiple rows for each point. If you can pre-filter that data that would help. For further help it's best to post a workbook on the Tableau forums where someone can then take a look.
Great content Mark! Thanks. If I have a question that related to a project that I am working on, what is the best way to contact you if you don't mind. thanks
I'd recommend posting on the Tableau forums, Ahmed. You're welcome to tag me but most likely by the time I see it someone will have already answered. community.tableau.com/s/explore-forums
Great work. How can I create a 20 mile buffer radius around each point? Can you make a video on that?
If you have a file with latitude and longitude points, this is the calc: BUFFER(MAKEPOINT([Lat],[Long]),20,"miles")
Hi Marc, Great content. Really helpful. I want to know one thing that can I set this Layer option was parameter in my dashboard? Like when I represent my dashboard, if I choose layer 1 it will show layer 1 and so on. I don't want that option on the map instead of that I want it as parameter. is it possible ?
Thanks. One way to do that is to use a parameter in a calculation and return your spatial object based on the parameter selection. For example: IF p.Select_Layer = 1 THEN [My_Spatial_Object] ELSE NULL END. And drag that calc onto the view as a map layer. It will then only show when the parameter is set to a value of 1.
This is such a fantastic tutorial. Great use case and demo of dynamic zone visibility, and also excellent tips on using sets and set actions, parameter actions, dynamic titles, etc. etc. I'll be recommending this to my TUG members and anyone wanting to learn more about DZV. Thanks Marc!
Thanks a lot, Jen. That's much appreciated and I'm glad it was helpful. All the best!
Great work brother! Can I blend two data sources to make this happen? I have schools as points and buffer and other points to be counted inside the buffer.
Thanks. No, for the Intersects function it needs to be the same data source. But you could make a spatial join with your two data sources. See this video for an example ua-cam.com/video/MXquD73rnic/v-deo.html
Excellent. Thanks, Marc!
Nice one Marc
Hi may I know how to get the clean data set?
Hi - Please see the earlier comments with links to data. You can also download the workbook and extract the data from that.