Map view by Date

Andrea2 · 01-23-2020 12:06 AM

Hi there. Is there a way to get the map view to display a particular date. I have reps out in the field that log calls and locations. I would like to be able to see on a particular day where they have been on a map view. There is a date field in the table the map is being generated from but I have been unable to create a daily view as it seems you can only select the Location or address columns for data layers. Is there a way to do this?

Remco_Edelenbos

Hi @Andrea,

I think this would be possible with a slice:

with the formula:
[DATE COLUMN]=TODAY()

Then in UX --> " The map view" --> as a source you select the slice you created.

Andrea2

Thank you. I already have a slice with the filter condition [User Name] User. How would I add to that condition to include date today? Not to clever with expressions, keep getting it wrong.

Remco_Edelenbos

you can use a AND()

Andrea2

AND([Date] = “today()”,[User Name]=‘Will Ward’ true) like this?

Remco_Edelenbos

Yes almost, but would use USEREMAIL() instead of username. It depends on your provider login. But not every provider provides a user name.

AND(
[Date]=TODAY(),
USEREMAIL()=will@yourdomein.com
)

Andrea2

Username is available for every user. Do I put the “yes” at the end of the expression?

Remco_Edelenbos

Hi @Andrea,

No, as you can see in the AND() help. the only way the logic expression is true when there is a matching value for both.

So in your case:

AND(
[Date = TODAY(),
USERNAME()="Will Ward"
)

Andrea2

thanks but it is not working.

Remco_Edelenbos

Im sorry, i missed a ] after [Date

AND(
[Date] = TODAY(),
USERNAME()="Will Ward"
)

As you can see below, it worked for me: [Start_event_tijd_] = your [Date]

LeventK

@Andrea
USERNAME() is not unique for each user, therefore I encourage you using USEREMAIL() instead.

And in this expression you shall enclose the email within double quotes:

AND(
	[Date]=TODAY(),
	USEREMAIL()="will@yourdomain.com"
)