Date
Discussion List
-
How to find the difference between 2 dates?My dataset aggregate value totals on a monthly basis. Each row represents an individual site and va… -
How to delete portion of text in a column in the ETL?I have a date column that is in this format: The format of the date is fine, but what I am trying …
-
Bar Chart set to show last 12 months, is only showing 11 months of data as the first value is zero.I have a Bar Chart with the last FY worth of data up to 30 June 2021. I'd like the chart to show th… -
-
How can I compare YOY data with an offset of a couple of days?Hello, I'm 100% new to DOMO and I'm looking for some assistance. I'm trying to compare data from 20…
-
Ranking x axis by year then month with a series sort by alphaI am trying to get an x axis to display in date order over multiple years while also sorting by a s…
-
Convert DATETIME (UTC) to specific timezoneHello, Domosapiens! I have an interesting quandry. I have a data flow (using MagicETL - should I be… -
Adding an "Activity_Date" to a nightly refresh dataset.I just set up a connection for a dataset that doesn't have any fixed 'date' column. The only date c…
-
I am trying to get the timecards created this quarter for last quarterI am trying to get the timecards created this quarter (Q2) but for last quarter (Q1) the reference …
-
Creating a static column that doesn't interact with the date filter.I am working with Google Ads Campaign data. I want my 'Campaign' column to display all the campaig…
-
Formula/Beast Mode HelpHello, I'm stuck with how to write a Beast Mode/Formula that looks at two different dates. Here's …
-
Business days between date functionI use the datediff for business days function in a number of mysql data flows and it works great. H…
-
How to create a card with data from the calendar month before lastHi, does anyone have any thoughts on how to create a card that contains rolling data for a calendar…
-
2104 Weeks as option in Multi-Value cardWith so many industries moving to a 2-year CAGR in addition to their regular YoY comparison numbers…
-
2 Different Date Data SetsI have a problem where I need to match up 2 different data sets to show funnel. Create Date & …
-
DOMO SQL MAX(date) not workinghello, hope someone could help on my SQL: I just created a simple SQL under DOMO MySQL to select s…
-
Create a dynamic date range with a beast modeHi, I want to create a dynamic date range to capture the following period: 100 days ago excludi…
-
Diferent date ranges on a DashboardIm building a dashboard and some cards have diferent date ranges, some have yesterday as default an…
-
Get Data Based on Comparison of 2 DatesHi, I have a Dataset with 2 dates open_date,closed_date for a category(has 2 values open,closed). …
-
Date Range BucketsHello, I am trying to create a way to look at upcoming estimated shipping dates but I keep gett…
-
SQL Data Troubleshooting: Neither Date Filter Nor Conversion Rate DataFlow Calculation WorkingHello DOMO Community, Questions: 1. Can you tell me why person_created_date is not filtering &…
-
Show data of last 10 weeksHi, I have a dataset that shows data year to date. And I am using an HTML card to get a table v…
-
Rearrange values on X axisHi, I am creating a view where I want to observe volumes base on a time of the day bucket. So h…
-
How to create a Beast Mode calculation for fiscal year using a date field?Hi All, I have a unique dilemma. I need to create a beast mode calculation to calculate our re…
-
Finding "earliest" date when one of them might be NULLI have a dataset with a key field (loan number) and a series of dates. Within the ETL, I have to c…
-
10Timezone Conversion in ETLSince most datasets are brought in at UTC time, there should be an option in the ETL to convert dat… -
increase - date to dateHello, Maybe somebody can assists how to write the formula for the next issue (ex): date1 = am… -
Adding year value to MM/DD date field.I have a free text note field that we preface each note with a MM/DD format date. I am trying to ad…
-
Setting Date Range for Dataset UpdateHi guys I have an input dataset which are set to refresh every day using the replace method, an…
