2 Replies Latest reply on Feb 20, 2017 8:05 AM by Ramu Machineni

How to create alert ?

Ramu Machineni Feb 20, 2017 6:52 AM

Hi All,

Can some one please help me, how to crate alert on the date filed,

Ex:

Below table, I want to show the Doctor Patient Name in red colour, nd doctor name in different colour for the patients whose check up date is expired.

I mean need to compare check-up date with SYSTEM DATE.

Logic should be like this:

IF( Check up date) < system date then patient name Then " red"

Check up Next Date	Patient Name	Doctor Name
28 January 2017	Som	Raj
28 February 2017	Ram1	Som1
28 February 2017	Raj	Ram7
26 February 2017	Raj	Shiva4
22 February 2017	Shiva	Ram1
22 February 2017	Raj3	Raj
21 February 2017	Shiva2	Ram2
21 February 2017	Raj2	Raj
21 February 2017	Ram2	Ram5
21 February 2017	Ram5	Som2
2 March 2017	Ram3	Som3
14 February 2017	Som2	Raj3
13 January 2017	Ram7	Shiva3
11 February 2017	Ram	Ravi
11 February 2017	Shiva3	Ram3
10 February 2017	Raj	Ram3
1 March 2017	Ram3	Shiva2
1 June 2017	Som1	Raj2

1. Re: How to create alert ?

Stephen Rizzo Feb 20, 2017 7:53 AM (in response to Ramu Machineni)

Finding a solution is difficult without knowing how your table is set up (what fields are on your row shelf, columns shelf, values area, filters card, etc.). Typically you would add the desired highlighting by creating the calculated field

[Is Late] = IF [Check up date] > TODAY() THEN "Late" ELSE "Not Late" END

Then dragging [Is Late] to the "Color" tab.
Like Show 0 Likes(0)

Actions
2. Re: How to create alert ?

Ramu Machineni Feb 20, 2017 8:05 AM (in response to Stephen Rizzo)

Thank you Stephen.

Good day.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How to create alert ?

1. Re: How to create alert ?

2. Re: How to create alert ?

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account