For Map Chart, How to show one marker for each 10 mins of its DateTime constraint

[CHUN KIT LEE]

Dear All,

Is it possible to group and show the first marker with 10 mins intervals just like the image attached below

For more example:

 

 

 

2020-11-02 16:20:05

[Gaia Paolini]

I think the main part is to calculate the marker.

 

From this answer you can get the date binned to the nearest 10 minutes

https://community.spotfire.com/questions/how-bin-minute

 

So [date_bin10] is calculated as:

Time(Hour([date]),Integer(Integer(Minute([date]) / 10) * 10),0,0)

 

Then you calculate the distance between the original [date] and the binned date [date_bin10]

[distance_to_bin] calculated as:

Abs(DateDiff('second',[date],[date_bin10]))

 

Then you calculate the marker when the distance is at its minimum for every value of the binned date.

Marked calculated as:

case when [distance_to_bin]=Min([distance_to_bin]) over ([date_bin10]) then String([date_bin10]) end

 

In the Map Chart you can then set the labels to Marked (since it wants an aggregation, you can use e.g. First(Marked))