My date filters are on the struggle bus in the new year y'all. CASE when WEEK(`Week Date`) = Week(CURDATE())-1 then 'show' else 'hide' end = 'show' The filter is simply returning this current week instead of the previous week. I assume this is because we are in Week 1, and the previous Week was 52. What's a better formula…
We need to map the Date field so that every date value is the first of the month. The value mapper tile can do this one at a time, but we need to do this in bulk. Can anyone recommend the best approach using a function?
Hey Domo Smarties! [Annotated Screen Cap Below] What's the best way to filter out duplicate rows according to the latest modified date in an ETL? Desired Result: One unique entry by "start date" and "model" with the latest "ob modified date".
Hello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter Start/End Date. For example: Input: November 8, 2022 Desired Output: Previous Quarter Start Date - July 1, 2022 Previous Quarter End Date - September 30, 2022 Previous Two Quarter Start Date - April 1, 2022 Previous Two…
Hello, I am using HubSpot Connector to create contact reports in Domo. A custom HubSpot Date property is pulling into Domo in a strange format and I can't seem to get this formatted as a date using Magic ETL or Beast Mode formulas that I have come across in other threads. My first booked Calendly date field should in this…
I have daily per-item data. I am creating a new View so that it is grouped by month. When I select group by month, it converts the column's data type from date to text. Why? And how do I prevent this? Domo should already support MM-YYYY formatting
Hey Everyone - Looking for help on how to compare same store growth on a MoM, YoY, and YTD when comparing various upload dates. EX: Athens/UGA is a submarket with with a 28 properties that we have collected market rent data on for 5 months now. Would like to compare December->November/January/December 2021 (if we had the…
Hi all! I am looking for advice on extracting a Maturity Date from a column containing a string of text, example: string: 12months,MATURITY DATE:23-Jun-2022,BALANCE;$12345,PRODUCT Return: 23-Jun-2022 I am able to successfully select the date by using: \d{2}-[A-z]{3}-\d{4} But am unable to replace this so that it only…
Hi, Assume my data like that I want to become If I use Remove Duplicates in ETL, it only keep the old row. What should I do now ? Many thanks
Hello, Our company offers several different product lines and I am attempting to count how many times each combination is owned. There is a field that comes through to Domo from a SFDC connector with this information, but there is a ton of duplication within as a customer can own multiple of 1 product. Example: I'm…
It looks like you're new here. Sign in or register to get started.