-
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 -…
-
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 -…
-
Allow Users To Show Time in Local Time
We have users around the world and we store our dates in UTC. But users would really like to view the UTC Date Time in there local preferred time zone. Currently we have to add a lot of beast modes and formulas inside of datasets to accomplish this. And we end up storing the data many times. And create cards to show the…
-
Create Dynamic Date Range End Date in Analyzer Date Range Filter
It would be valuable to have the ability to choose a date range for a card in analyzer that is relative to the current date. For example, "Start Date - X days ago" where X is a number you can set to determine the end date of the filter relative to the current date. Currently to do this, I create a beast mode that I then…
-
Table Date Range Field Drop Down
The table Date Range option should not be fixed on the first Date field in the table. The drop down should be functional regardless of the fields in the table. Currently, the first date field is used for the date grain. This limits functionality and flexibility in reporting. You can only select the date range field when no…
-
Additional Date Filters and Conditions
It would be helpful if there were additional date filters and conditions available to select. For example, we have reports for previous day shipments which works great Tuesday - Friday. However on Monday that report is blank because no shipment transactions were completed on Sunday. It would be great if there was a toggle…
-
Total/Subtotal options for dates
When building a table, it'd be good to have the option to subtotal date fields by something other than COUNT. Basic options like MIN or MAX, would help answering key business questions like when the last interaction took place, or when we first interacted, while still displaying in the table the full list of interactions…