Im a new metabase user - love the product
I have a table with records of items sent, and a field that is set to a date if the item is accessed by user.
I can do various group by’s to show 2 columns - (count), and (countif accessed by date is >0)
How do I add a 3rd column which shows the percentage accessed
ie. (countif accessed by date is >0 ) / count *100
eg: How do I create the “% accessed column” in the example below (data grouped by Branch - 1 row for each item sent) - my current question built has the 1st 3 columns but cant figure out how to add the 4th column
Branch. Items Sent. items accessed. % accessed
xxxx. 1000 500 50%
yyyy 2000 200 10%
Thanks in advance !!