2 Replies Latest reply on Feb 24, 2012 4:58 AM by Xavier P

Flag events based on date match

Xavier P Feb 24, 2012 12:08 AM

Hello peeps

This one is a real problem, at least for me!

I have two sheets, user activity and customer support activity: usage and support.

On the usage tab, I'd like to flag the fact there was a support event, i have marked two examples: open and close.

Is this possible with a calculation to pull an event when date matches?

1. Re: Flag events based on date match

Andy Cotgreave Feb 24, 2012 2:33 AM (in response to Xavier P)
Hello Mister X
Try the attached. I edited the relationship between the two data sources so that the Dates match on Month/Day/Year of date (do this on Data...Edit Relationships).

Then I changed the date pill on the column shelf to MDY(Date) - and then you can add Event to the colour shelf.

Cheers
Andy

Match date.twbx.zip 22.2 KB
Like Show 0 Likes(0)

Actions
2. Re: Flag events based on date match

Xavier P Feb 24, 2012 4:58 AM (in response to Andy Cotgreave)

Exactly that! Thanks Andy!! Just trying to understand, for date relationship, is the format there prevailing over what you set within the data source?
Like Show 0 Likes(0)

Actions

Tableau Community Forums