Community Forums
Community Forums
helpme12345 Member
Overview
| Roles | Member |
|---|---|
| Badges | 5 |
About Me
| Not much happening here, yet. |
Analytics
61
161
28
Reactions
Discussions
- I have a dashboard that I added a donut filter to at the top containing Category A and Category B. Below it, I have a single bar chart with no series that shows the amount of new paid companies in a g…
- I have a list of companys that have different subscription intervals (monthly, annual) and I'm seeing duplicate rows. To mitigate this I want to have one line item for each company, I have tried using…
- I have snapshot data everyday that has customers and their statuses. I want to create a formula that looks back one day and reports the status (previous day status) How would I do that in Magic ETL?
- I have rows of data that look like this: Customer: ID: 12 NULL 12 NULL 12 NULL 12 NULL 12 NULL 12 56 How do I fill in the above rows with the customer ID, 56, Using ETL?
- What is the best way to individually parse out a string like this? 1-2-3 want the following: 1 2 3 Open to use either Magic ETL or BM.
- Currently am using this formula to exclude current week: CASE WHEN WEEK(Snapshot Date) >= WEEK(maxSnapshotDate) AND YEAR(Snapshot Date) >= YEAR(maxSnapshotDate) THEN 0 ELSE 1 END however, it is exclud…
- I have a list of companies and their create date. I want to create a beast mode that checks if a list of companies has the same create date. Any help here? Would this need to be done in Magic ETL?
- Is there an easy way using Magic ETL to create new columns based on existing columns. For example I have an ID column and a Page Name column and want to make each ID and Page Name a net new column to …
- For this question: Join together two DataSets with MySQL using the name, year, and gender columns and include appropriate indexing. Not sure what to index here, is there any additional resources aroun…
- Is there a Governance connector or way to filter to a dataset and determine which columns are used in cards/beastmodes?
- I have a snapshot dataflow that has captured bad values. I only need to filter out those values that don't match the current format. What is the best practice for this?
- Is it possible to add a hyperlink in an alert message. I am having this alert hit slack and would like the ability to include a card hyperlink.
- Is there a way that you can view what the query would like after you use a set up a tile function in Magic ETL?
- I have 2 datasets I am appending together and want advice on how to handle null values. For example, one dataset has ID,Name, CustID and one is just ID and CustID. How would I use ID in order to fill …
- When I append data on a Excel File export (same structure) the valid ID's in the ID column are errored out with ERROR:#N/A Right now its at 58,000 rows, is there an issue here? Wondering why its error…
- I have data that I snapshot daily. It has employee name and employee status. Once the status gets updated, it remains that way: ex for one employee: 1/1 Name: active 1/2 Name: active 1/3 Name: active …
- I have a name column with a full name: example Bob Dylan and am joining to another dataset by name. I'm having issues and believe its due to extra white space after the last name. I tried using Replac…
- I have rows that look like this: Interview with Bob Dylan - CSM and want to parse just the CSM. I tried using Replace Text file, selecting reg ex and using this: -.* but it returned the former portion…
- I have two timestamp fields: completed at and delivered at. I want to find the difference of both and take the average. The dates include a window that is sometimes over a day. I read this By @GrantSm…
- currently I have this query and I have 16 exclusion reasons. Is there a more efficient way to write this beastmode? CASE WHEN exclusion reason 1 IS NULL THEN CASE WHEN exclusion reason 2 IS NULL THEN …
- I have two datasets, same structure/columns, 1 large dataset with all records and another large dataset with suspected duplicate customers removed. I want to join these together and create a flag for …
- Stuck doing this in Magic ETL: Trying to calculate the average time between orders. For each record in the DataSet, add a field showing the number of days since the previous order for that customer. C…
- How do you add a dataset in sandbox? Not finding much documentation
- I am attempting to pull out a string using Reg ex. I want to get the card name, so text after the --- card_name: and between measurable_id. I am using .*measurable_id) but it is giving me an error mes…
- Can you schedule a view to run daily?
- Trying to get the %change in overall Row Count DoD looking at today vs. yesterday. This is what I have but is not successful. Any suggestions?: (SUM(CASE WHEN DAY(`Snapshot Date`) = CURDATE() THEN `Ro…
- What is the best way to show row count growth of a dataset day over day? Currently using DOMO Stats to show each datasets total row count I think I can create a beastmode for this, any suggestions her…
- I have a current dataflow that is recursive. I want to make sure the company records that are being snapshotted are. I am planning to use a field "Snapshot Date" which is the current date timestamp on…
- I'd like to create a new dataflow, preferably not MySQL, to show that the fields I intend to snapshot daily are actually being snapshotted. For more context, I have a list of companies with subscripti…
- I'd like to build a recursive dataflow, but capture data by month. Any idea how this can be solved?
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In
