Tableau substring

Question

I am not sure how to use the mid function.

This is the account number

10010730000091

and I want to do Substring(Account_Id, 4, 6) in Tableau. Basically, I need the six numbers from the fourth position. 

Answer 1

Use this MID Syntax in tableau:

MID(Account_Id, 4, 6)

Want to become an expert in Tableau? Join now: Tableau certification