Hello @HwanJang , welcome to the Quick Sight community!
There is no straightforward way to do this in the console unfortunately. If I were doing this and had the option to do it in SQL I would go in that direction. That being said if you want to do it in Quick Sight you can use calculated fields, parameters and fitlers like you mentioned in your first option.