Hi @syhrh , I'm working on similar requirements.
1. for the fill property, use the switch condition like switch(thisitem.status.value,"approved",Green,"inprogress",Orange,RGBA(0,0,0,0))
2. for your 2nd question there are two ways, 1 is use to nested gallery and pass the following filter to items property
filter(datasource, yourdatecolumn = datevalue)
otherwise
use a text label and in text property show the count of requests on the day. like countrows(filter(datasource,datecolumn = datevalue)) and onclick of it show one more gallery to display all of your requests
