i have date and time in my column , i have to separate date in tableau dashboard, as date with date column and time, if time received is 9:00:12 Am then have to show or highlight time as 8AM and if i receive at 1 PM then i have to show or highlight at 12 PM with some colour
DATEPART might do the job for you. Date Functions
Create a calculated field
IF DATEPART('hour',[DateTimeReceivedField]) < 12 THEN '8AM'
ELSEIF DATEPART('hour',[DateTimeReceivedField]) < 17 THEN '12PM'
ELSEIF DATEPART('hour',[DateTimeReceivedField]) < 20 THEN '5PM'
ELSE '8PM' END
That says if the hour received is in the morning then report 8am, if the hour is before 5pm then 12 pm, if the hour is before 8pm then 5pm otherwise 8pm. Note this doesn't take the date into account so you may wish to modify for cases where the data hasn't arrived that day. Plus you may need to tweak the time rules I've implemented based on your actual time rules.
this is really helpfully on conditions
i alsoneed to show time as
8AM 12 PM 5 PM
when 8AM staifies, then that should be hightlighted.can you please help on this
Sorry, I don't understand the question
first i have to create some view where i can show time as below
5AM 12 PM 5PM
if time data condition matches for 5AM then 5AM has to highlight with some color
if time data condition matches for 12PM then 12PM has to highlight with some color
if time data condition matches for 5PM then 5PM has to highlight with some color
Ok, just drag the calculated field to the Colour shelf, then you'll have a different colour for each value.
can you please provide more information this
using this i can provide color but based on condition how can i provide color
i am very begnerof tableau, really need help on this as how to show data as below based on coldition. Can you please provide one documentation as to accomplish this.
i have one calendar date column, now need to shpw data at dashboard as
5 AM 12 PM 5 PM
and also if my date is having timestamp as 5 AM then i need to show green colr on 5 AM
if next day if my date is having timestamp as 12 PM then i need to show green colr on 12 PM.
also need to show date above and below timestamps with condtion and also color. Please suggest
5 AM 12 PM 5 PM ( with color on only one of the times which matches)
can anyone suggest on my request
Would you be able to provide sample data so we can try and help?