-
Create a dynamic date range with a beast mode
Hi, I want to create a dynamic date range to capture the following period: 100 days ago excluding the last 4 weeks (28 days). The date I want to use is signup_date. Is this possible with a beast mode?
-
Diferent date ranges on a Dashboard
Im building a dashboard and some cards have diferent date ranges, some have yesterday as default and some have this month, at this point dashboard works fine, but if we try to modify date ranges from the dashboard lets say lat month its no working, will show blanks. am i missing a configuration? thanks in advance.
-
Get Data Based on Comparison of 2 Dates
Hi, I have a Dataset with 2 dates open_date,closed_date for a category(has 2 values open,closed). I want to build a weekly bar chart with a count of category where the date range is selected for the column open_date but the date range should also be applied to closed_date as well. For Ex:- Open DateClosed…
-
Date Range Buckets
Hello, I am trying to create a way to look at upcoming estimated shipping dates but I keep getting an "error during processing" . I have made buckets for WIP based off days in shop field and basic case formulas in the past with no issues (See attached). I think I am having issues with my approach due to this being dates…
-
SQL Data Troubleshooting: Neither Date Filter Nor Conversion Rate DataFlow Calculation Working
Hello DOMO Community, Questions: 1. Can you tell me why person_created_date is not filtering >= 01-01-2019 results? -As you can see in the screenshot, the person_created_date is returning results prior to 2019. 2. Can you tell me why my SQL is not grouping the data by lead_marketing_channel in Domo Analyzer? -As you can…
-
Show data of last 10 weeks
Hi, I have a dataset that shows data year to date. And I am using an HTML card to get a table view. Is there a filter or setting that can be set, to always show the last 10 weeks of data as time goes by? I have week column and to not overload the table, I always only want the last 10 weeks data.
-
Rearrange values on X axis
Hi, I am creating a view where I want to observe volumes base on a time of the day bucket. So have a variable: time_of_the day that I created using a timestamp variable. When I put the variable on the x axis, it starts with 10-11 AM first and and with the earliest value, 9-10 AM. I would like to organize the values in a…
-
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 revenue for the latest fiscal year. I know I can just manually add the date filter criteria into the calculation or add a filter but the thing is the data is updated every day and we need the date filter criteria to be dynamic &…
-
Finding "earliest" date when one of them might be NULL
I have a dataset with a key field (loan number) and a series of dates. Within the ETL, I have to calculate several "Earliest Of" dates. So if the dataset has the following fields: Loan Number Date A Date B Date C Date D Date E I might need to create a new field called "Earliest of Date A and B". I am able to use the…
-
increase - date to date
Hello, Maybe somebody can assists how to write the formula for the next issue (ex): date1 = amount1 date2 = amount2 date 3 = amount3 p.s. amounts are not on daily basis on the chart (line + grouped bar), I want to show - for the date2 - amount2 (bar) and sales increase (amount2-amount1)(line) - for the date3 - amount3…
-
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 add the year to this field so that Domo can chronologize this field and compare this free text date with things like system driven dates. I am currently using the following beast mode to extract the date from our text field,…
-
Creating custom date ranges for display
I would like to display my cards with a custom date range that doesn't exist. I need financial year to date for Australia. Our financial year runs from 1 July to 30 June and so all our clients here would like their data displayed that way. How can I do this? There isn't an option in the date range field to do this. Domo…
-
Setting Date Range for Dataset Update
Hi guys I have an input dataset which are set to refresh every day using the replace method, and then runs through a recursive dataflow which drives an output dataset that has the most recent data. I remembered in the past (12 months ago), in the DateFrom and DateTo fields for the data connector settings, instead of adding…
-
Same Day Closure %
Hello, I am working on a way to figure out what the same-day closure rate % is for customer support cases created within X time frame. As well as compare that to a previous time frame. Example: Feb 2017 = 73% Feb 2018 = 90% March 2017 = 85% March 2018 = 88% I would like to see if there is a visual way of doing this as well…
-
Ignore filter on a calculated field
Hello, I'm wondering if it's possible to create a BeastMode that ignores date filtering... I have a dataset that contains the following information ID# CUSTOMERNAME STATE FullDate Logins Errors % The card I'm building should only display the data from yesterday BUT, I want to add a field that calculates how many times the…
-
Centro connector All Brand Stats report date range
What is the date range on the All Brand Stats report from the Centro connector?
-
Specify different date formats for multiple sources in ETL
I am combining a number of data sources with date columns using an ETL before performing other calculations on them. Some of the sources have Australian date format (DD/MM/YYYY), and others have US format (MM/DD/YYYY). The ETL gives me results in YYYY-MM-DD format, where it's actually incorrectly converted some of the…
-
Changing Date format to YYYY/MM to exclude days as uploading Monthly data
Hi there, I was wondering if someone could help me with a date format issue. The data is being uploaded as YYYY/MM and it turns it into the format of YYYY/MM/DD but the DD is always 01 since we only uploaded Monthly data and do not have it broken out by day. This does not allow me to use the 'All Time' filter which is…
-
Historical Facebook data
In Facebook Quickstart, am trying to edit a card for Fan Growth in 2016 data but you cannot edit the date range beyond "All-time" (which is the date you signed up). It just says "no data exists". Any help / ideas?
-
Dynamic date range (last two quarters)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…