topic Re: Background Color Expression for Holidays in App Development

Background Color Expression for Holidays

joshdellapietro — Tue, 05 Jan 2021 20:07:26 GMT

Hello,

I currently have a pivot table showing me sales by week (image 1). My weeks are calculated using the following field, [Shipping Date.autoCalendar.Week] with the field [Shipping Date] just being MM/DD/YYYY. Now, I also have loaded a field called [Holiday Date] which again is in MM/DD/YYYY format. My goal is for holiday weeks to be highlighted in light gray in my pivot table (image 2).

I thought a simple formula would of work like:

IF([Shipping Date.autoCalendar.Week]=[Holiday Date.autoCalendar.Week],lightgray())

But I am not getting any results from this.

Re: Background Color Expression for Holidays

settu_periasamy — Wed, 06 Jan 2021 04:57:57 GMT

Hi @joshdellapietro ,

Is that holiday date field is linked to your Shipping Date Calendar table?

Re: Background Color Expression for Holidays

joshdellapietro — Wed, 06 Jan 2021 15:03:47 GMT

Hi,

No, they are loaded separately. Linking them is an option.

Re: Background Color Expression for Holidays

settu_periasamy — Wed, 06 Jan 2021 15:08:46 GMT

Ok. Can you just create a Straight table char with two fields (Shipping date and Holiday Date) and check those date values are matching ?

Re: Background Color Expression for Holidays

joshdellapietro — Wed, 06 Jan 2021 15:12:58 GMT

Yes, it allowed me to link the two showing that the date values match.

Re: Background Color Expression for Holidays

joshdellapietro — Wed, 06 Jan 2021 15:35:34 GMT

Figured it out, this formula worked:

ONLY(IF([Shipping Date.autoCalendar.Week]=[Holiday Date.autoCalendar.Week],lightgray()))