Hi, I have a column that has anywhere from 0 to 25 notes in one cell. The delimiter for the cell is a line break after each note. I need to split the cell into a row for each note so that we can filter for just notes that just apply to a group like "Billing" or "Admin". How can this be accomplished? We would like the…
Hi All, I am trying to extract the date from a field based on a pattern - If the first four characters of the field description are *SLD then I need to extract the date from the field description as output date else I need to take the date from the field orddate as the the output date..please find the table below: can you…
I want to leverage the date filter parameter dynamically in beast mode. For example: I have 2 date fields that are populated when an account is opened (Date Opened) and when an account is closed (Date Closed). I would like to have a count of active accounts based on the date range that is dynamically selected on the card.…
Hello Domo users, We have "reports" in a database. There are say 10,000 or more. We need a solution to share ONE report with users. Is there a way to query the dataset based on a URL string? The solution we have loads ALL the reports which are visualized in the same way. We have to share ALL the reports with EVERYONE then…
Hi Beatiful People - I was able to learn how to create a snapshot etl dataflow, just a quick question, where in the dataflow can I add a column that shows the date for the historical data and the date column for the appended data?
I have a couple data flows that use replace text or value mappers to remove certain text characters from a number column to then convert to an integer. Examples of text we are finding in our source data are "#DIV/0" and "--". However, when those characters don't exist at all in the source data, the replace text tile fails…
Hi Guys! I am trying to capture dates that are older than 6 days, but this Beast Mode is showing me zero although I know I have some. SUM(case when DATEDIFF(`Effective Time`,CURRENT_DATE()) >=6 then 1 else 0 end) Thank you!!
Reaching out to the community in hopes that someone has dealt with the use case I'm struggling with. Our support organization operates in a tiered model (Tier 1, Tier 2, and Tier 3). I'm in need of assistance writing a beast mode to calculate the amount of time a ticket sat in each of the tiers. Using the above table, I…
Will Beast Mode calculations show up on Views created for Datasets? I'm working with a view of a dataset, but don't see any of the Beast Modes that were shared with that Dataset....
Hi All, I am trying to replicate the following SQL statement in the MagicETL formula tool.. (SELECT MAX("FISCAL_YEAR") FROM table WHERE "DATE_VALUE" = CURRENT_DATE) AS CUR_FISCAL_YEAR In the Magic ETL tool I am giving the name of the output column as CUR_FISCAL_YEAR and Write Formula as MAX(`FISCAL_YEAR`) WHERE…
It looks like you're new here. Sign in or register to get started.