calculate % of field
I am new to Domo and wondering how I can calclate the % of a field based on one of its values. I can essentially do this in excel using the following function, can I replicate this in Domo?
=COUNTIF(F2:F500, "Closed Won")/COUNTA(F2:F500)
The field that I am trying to count from is titled Stage (Column F) and I am looking to return the % of how many of the stage values are 'Closed Won', and show this in a bar chart for a month by month comparrison.
Would really appreciate it if someone could point me in the right direction.