I’m not talking about a case statement per say that forms categories based on parameters. I need to list 3 categories in a beast mode that then I can use to create a filter card that will then remove/add these metrics to cards. For example; ’Conversion %’ ’AOV’ ’Net Sales’
Hi all Anyone know if this is on the horizon? Combining unique values in a comma separated string. Anyone know? The issue is mapped out in the 4 year old post I've linked to below. Thanks
i have data like this : And with magic ETL want to concatenate contents of column C for same values in Column A. Desired result: Result with Group by's concatenate
Hi, Upon connecting my Domo instance to Microsoft exchange ( In order to track # of emails around the corporation) I can only see the Microsoft account that's logged in through Domo, I want to be able to see all accounts from 1 connector. Is this at all possible or does anyone have any experience with the connector. Thanks…
Hi all, Is it possible to format date to just month and year. Currently when grouping together time series data I use the 1st day of the month e.g. all data in November would be under 01/11/XXXX — I wanted to know if it is possible to have columns in a date format that is Nov XXXX. When I group like this in a view it…
Can I revert back to the old version of a dataset and retrieve the lost rows?
I am looking for a way to add historical data into my already existing recursive dataflow. My two input datasets are 1.) an email connector that uploads once a day, 2.) a copy of my output dataset as an input dataset acting as my historical records. My output dataset has data from 2021-2023 but I would like to add data…
Have a field settlementID, I'm wanting to display when there isn't a value for that row to show pending else show the settlement id something like when settlementID is blank then 'Pending' else settlementID thank you
Hi, I have a question related to keeping a running total and then moving that running total to a new column called 'Most consecutive days' and I am not sure if I need to do this in a beast mode or MagicETL Is there a way to, for example, product A sold for 10 days in a row, didnt sell a day then sold for 3 days in a row…
I have the following table and i would like to understand how to get the difference between dates: id | status | date 1 | disconnect | april 4 1 | reconnect | april 7 2 | disconnect | june 4 I would like to understand the average days that persons reconnect in the entire dataset. Can a partition function work here? The…
It looks like you're new here. Sign in or register to get started.