It's possible - getting the two types of dots on the map under different colours is fairly easy, but with the way the data is in the same rows is a little more complicated, as you need to duplicate the rows and have one set as students and one as data.
I've attached an example where I've done this, I've unioned a CSV with the data in, then set one copy to be student, and the other to the campus using the table name.
Then I've created variations of the lat/long which pick up from the relevant field for the type and added them to the map.
After that it's just a case of using the 'type' field for a colour.
studentcampus.twbx 47.5 KB
Thanks for the reply, Chris. Your solution works in simple scenarios. In my case the data is more than 10 million records and growing. I have a lot of measure like performance, attendance etc in the data. So, duplicating records is not a feasible solution. Can we do it in a more efficient way?