Sharepoint - Online - Hyperlink in calculated column

="<a target=_blank "      
&"href=""https://mysharepoint.sharepoint.com/site/documents/Forms/AllItems.aspx"
&"?FilterField1=MyField"
&"&FilterValue1="
&[Name]
&""">See Data</a>"

Explanation: Make dynamic calculated column Formula URL open as modal

your formula it's ok, under the Formula Box you need to change "The data type returned from this formula" as number by default is marked as "single line text"

Format the column using JSON to create a link

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#create-clickable-actions