-
is there anyway to change default time in Domo?
Seems like date/time format always defaults to 12:00am. Is there anyway I can change this universally so that it always just defaults to 11:59pm when no time is specified in date/time format?
-
Transforming an array of custom fields
I have a dataset currently flowing in from MongoDB which is essentially populated based on custom fields that are optionally set within the source. Each element in the array has the name and value of the custom field (ie. customField<0-N>_fieldName and customField<0-N>_fieldValue). The issue is that it's not always the…
-
Split columns based on number of characters using regex
Hi all, I need to split a column that contains both a client name and number into 2 separate columns. Some client names themselves contain whitespace, so I cannot split on whitespace and am looking at Regex, though it's been a while since I've used it. All the client numbers are 5 digits long, though they are randomly…
-
Count Unique IDs by Month-Year
Hi all, I have a date column (formatted as a timestamp ex. 2022-02-17T23:57:03Z) and a column of Unique IDs in my dataset. I am trying to create a new count column which provides the count of each Unique ID within a certain Month-Year in each row of my dataset. For instance, if I have 3 unique counts of Unique IDs in…