Discussions
-
Comparing year over year data- by same week day
Hi All, I want to compare the sales volume for 2020 against that of 2019 on a by day basis. For example: 1st Feb, 2019 was a Friday and 1st Feb 2020 was a Saturday. Instead of comparing Feb 1, 2020 against Feb 1, 2019, I want compare Feb 1, 2020 against the nearest Saturday in Feb 2019. Has anyone faced this scenario…
-
Append to dataset based on month and year partition value
Hi everyone, I have a table in my database that is updated everymonth and the table has a partition column like 201911 for Nov 2019, 201912 for Dec 2019 and 201001 for Jan 2020. I want to append these values from the table to a Domo dataset every month without duplicates but not sure how to do that using the replacement…