How to check two dates and the [total] value on each date to set a color rule

AppSheet AppSheet Q&A
1

I want to check my date column. In the [date] column I want to check between - today’s date and yesterdays date. I want to check if the [total] from yesterday is smaller or bigger than todays. Also, this needs to be PER [location] column and per [ category] column:

Tiger1_0-1655758665236.png
Tiger1_0-1655758665236.png527×417 11.1 KB

2
  1. Create a slice for today’s records.
  2. Create a slice for yesterday’s records.
  3. Then: Re: FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), R… - Google Cloud Community
1 Like
3

How do I combine the two slices to create the color rule I need? I need color “red” if yesterdays total was less than todays. I need “green” if yesterdays totals were more than todays.

4

I guess you’d need to compare the two totals rather than “combine” them. So you’d use < and > to compare the calculated totals.

2 Likes
5

How do I compare slices? Would these need to be virtual columns?