Dear H_L,
'Approximate Distinct Count' is not available in Adhoc.
If you wanna use the same, create the metric in Adobe Analytics and then use the metric in Adhoc. Sorry, you cannot create one in Adhoc.
I would also prefer using it in Workspace since Adobe has released the announcement on the sunset of Adhoc.
Thank You
Arun