Table Visual Conditional formatting

Question & Answer
,
1

Hi
I have date field in table visual and need to display red color if date is within 30days

Thanks,
BS

2

Hi @SantoshB

a. Create a calculated field to get your calculation for the conditional formatting. An example below

image
image483×240 6.26 KB

b. Go to the visual properties and add Conditional formatting on the date column; but apply the condition based on the calculated field mentioned above. Screenshot of my sample below

image
image388×477 16.2 KB

Result

image
image510×399 24.5 KB

2 Likes
3

Thanks. Its working but now() is in UTC format and my results are showing wrong. I need it in cst format. how to change that?

4

From Edit Menu select Analysis Settings.

In the Analysis Settings dialogue you enable the Convert Time Zone and select your desired timezone

5

I have date 12/31/2024 and the calculated field is giving values of -34

6

Hi @SantoshB,

I guess this is due to timezone conversion. Please do a truncDate on both the date fields as follows and then check

dateDiff(truncDate(‘DD’, {ORDER_DATE}), truncDate(‘DD’, now()), “DD”)

7

Since 12/31/2024 is a future date, it is being calculated as negative. If you want to exclude future dates, you can add a clause in the same filter along with less than equal to 30 and greater than equal to 0. This should restrict this records.

1 Like
8

Hi @SantoshB,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post or were you able to find a work around for your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

9

Hi @SantoshB,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!