We understand the main use for column masking is to protect sensitive data but our use case further extends it to be used to generate Sample data.
Currently we create copies of datasets and dashboards for our Sample data which is used for demo/training purpose which requires us to hide/mask data for all the columns. We can use text masking methods but the option for numeric fields is only to be NULL which will not show the visualizations on the dashboards/apps.
If we can have masking methods like Random numbers with Seed or operations like below -
- scale = 0.6 + (MOD(ABS(HASH([Metric])), 8000) / 10000)
- jitter = 1 + ((MOD(ABS(HASH(CONCAT([Metric],[Date])), 4001) - 2000) / 100000))
- Value = Value * scale * jitter
Also for text fields options like Regex in a Formula Tile would be helpful.
Feature Reference-
https://www.domo.com/docs/s/article/360042934614#column_policies
Note:
Column policies are data type-specific. You can use all masking methods with text-type policies. However, you can only use Nullify and Unmasked with numeric and date/time type policies.
