-
Bell Curve - Large Data
Hello, I am working with a large amount of rows, due to sales items having multiple sizes/colors. Looking to build a size/bell curve to present to the client but when I use the Histogram, it doesn't group by the category names/sizes but in the table view it shows the units by group. Histogram: Thank you in advance for the…
-
Network Down or Performance Issues Alert
Hello, Have an alert, when we have performance or network issues at DOMO. Just so we know when those occur, in case we are working with clients during that time.
-
Dataset TimeZone Select
Hello, Having a dataset timezone select would be amazing so you do not have to convert all of your dates one by one. Would be great to set the dates, within the dataset, to the timezone you wish and then have it convert to your company settings.
-
ShareASale API Connector
Hello, Has anyone connected with ShareASale using DOMOs API connectors. I have tried the JSON connectors and I'm not having luck. Link below. https://help.shareasale.com/hc/en-us/articles/12442753460375-Merchant-API-Building-Blocks
-
DOMO Office Plug-In - Excel Filter
Hello, I am working with a client on importing a item list, into their Excel planning worksheet. When I get to the "Setup Filters and Select Columns" it won't let me enter in multiple selects for the "contains" value match. I tried to add another "selling season" filter but it gives me a duplicate filter message. Any help…
-
Wrap Header but not rows in Tables(Pivot mainly)
Hello, I was curious if you could add something, in the table cards(Pivot mainly). It would be having the ability to wrap the headers but not affect the rows. Here is an example of the "visual issue". It would look much cleaner if it didn't make that double row. Similar to an "auto align" but not crunching up the…
-
Beastmode Case Statement with NOT IN operator
-
Data Type Detection for CSV SFTP Advanced
Only available on the xlsx version. Helps with leading zeroes.
-
Breaking out a string
Hi, I have product information that is a string seperated by commas. I wanted to take the first line and convert it to the lines in bold and continue the pattern. How can I accomplish this: Style #Selling SeasonsM200B14BAR14B ,15D ,14C ,14D ,15A ,15B ,15C ,16A ,16B ,16C ,16D ,17A ,17B ,17C ,17D ,18A…
-
Shopify - Month over Month % Change Beastmode Help
Hello, I've tried to use this formula but it isn't working: I'm trying to calculate the % change MOM for count of customers. This using Shopify orders datasets. (COUNT(DISTINCT CASE WHEN ((year(`processed_at`)=year(curdate())) AND (month(`processed_at`)=month(CURDATE()))) THEN `customer_id` END) / COUNT(DISTINCT CASE WHEN…
-
Rolling Total in Table View
Hello, I'm sure this is easy but I can't seem to get this to work in the table view. Here is my data and my desired outcome is the "TY MTD Actuals". DayDay(Name)TotalTY MTD ActualsGRAND…
-
Grouping by the Hour and alerting based on count of usage per hour.
Hello, I am trying to do a group by using hour of day. The date operator in Magic does not have that funcationality but curious how I can do it within magic or in SQL. Here is my data where I want to count how many times a code was use in an hour for each day I want to use. COUPON-CODEupdated_atOrder #Goal(Count of Usage…
-
Providing a True/False(Y/N) if text in a comma separated string is in a separate column
Hello, I have data that looks like this and the goal is to validate if the order season is in the selling season. I tried like but it didn't seem to be consistent. Any help would be appreciated. Order SeasonSelling SeasonsGoal18SP18SP,18SU,18FA,19SPY19FA18SP,18SU,18FA,19SPN18FA18SP,18SU,18FA,19SPY20SP18SP,18SU,18FA,19SPN…
-
Regex to Only show data before a certain character
Hello, I have data that looks like this: line_items_nameGoalBanks Short | Navy Camo - Navy Camo / SBanks ShortsThe Rise The Shine Tee | Charcoal - Charcoal / LThe Rise The Shine TeesClassic Vuori Tee | Heather Grey - Heather Grey / SClassic Vuori Tees I want just the items to the left of the | to show. How can I achieve…
-
Table Cumulative Sum
HI, I am trying to get my data in the left to look like my data on the right. I've seen some similiar cases but the once I see are moving into a line graph and I need these to be in table format. Current WantFIscal Month and NameLY $TY $Plan FIscal Month and NameLY $TY…
-
Create a Time Stamp Column, using data and time, in workbench for each time the report is ran.
Hello, I am sending over CSV files hourly, using the append update method. I want to add a "time stamp" column, using date and hour, to mark that unique file each time it is ran. So if, if the first file is sent over and processed through workbench at 3/23/2018 at 1:48PM I would like to the time stamp to reflect that for…
-
Grouping Dense Rank into Weeks
Hello, I am trying to build a product lifecycle comparison using first invoiced date as day 1 and then consildated all of those into multiples of 7, to get sequential weeks. For instance; day 1-7 would be 1, 8-14 would 2 and so forth. Mind you, I am using dense rank. Any help would be amazing.
-
Postal Tracking Numbers in beastmode that link to google or website
Hello, I am working with a number of clients that attached their BOL or tracking numbers to their invoices and I was curious if anyone has figured out to make that field clickable to where it will either go link to the tracking number of the carrier or at least google to go from there? Would be great to open another window…
-
Copying or "save as" a workbench job
Curious if anyone knows if you can copy of "save as" a workbench job. If not, which I think is the case, any tricks that you have used to mirror them? Also, I am doing some transforms and column name changes in workbench so this is why copying in workbench would be a huge help. Not sure if the DOMO ETL is faster and maybe…
-
Workbench Filter Dataset on a Year of a Date
Hi, I am trying to bring in some ODBC datasets, but only want workbench to pull in anything that is for the current year. I have invoice date in my dataset as a column that I want to use the following transformation to isolate only invoices for this year. See screenshot below. I know that I can use redshift/SQL/Magic to do…
-
Ebay Connector
Hello, Has anyone had any luck connecting to Ebay? I know that they are a DOMO customer but curious if anyone has had any luck with this? Appeciate it. Jerry
-
Fastest way to append? Magic seems a bit slow
Hello, I am appending 2 datasets that have a only a few common columns to give me and my clients the ability to bring their plans in without having to join them and cause some duplications. With that being said, does anyone know of a faster way to do this beside append in Magic? I know that fusion cannot do this because…
-
Connector if SFTP file updates
Hi, I am sending files from my ERP to a SFTP and pulling that file via the SFTP CSV Connector. The challenge is that it schedules to pull every 4 hours but I was curious if there is a way to set up a connector that pulls from the SFTP, only when the file is updated. Right now the challenge is that my ERP sometimes finishes…
-
100% Stacked Bar in 10% increments?
Hi, Anyway to adjust the % increments from 20%s to 10%s? Thanks for any help. Jerry Heard
-
Beastmode to Group All Months into a Total Month
Hello, I'm trying to use a multi-line chart where I already have my years broken out but want to have the months be seperate but also have a total. Can you please let me know what I am doing wrong in this beastmode. It "validates" but the "Total" never shows up: (CASE WHEN (month(`Start/Invoice Date`) = 1) THEN…
-
Isolating the max date for a date and time stamp
Hi, I appending warehouse data on an hourly basis so we can see warehouse activity by hour by day by week and so on. I am trying to build a filter or indicator that will allow me to filter the most current timestamped date only when needed. I am using the below beastmode and it's not working. Any suggestions as I thinking…
-
Changing date from 2016-01-22 to 01-22-2016
Hi, I've seen posts that are similiar but not quite my same issue. My data is coming in like 01/22/2016 and DOMO is changing it to 2016-01-22. Can you please help on converting it to month-day-year format. I've used the below but wondering if there is anything in the ETL(Magic preferrably) to do it so I don't have to have…
-
Pulling PNG Images into DOMO using FTP server calls via SKU keys
Hi, I have sales data with product information that aligns with our PNG files names inside our ftp server, where all our images are stored. Is there a beastmode where it will populate an image to the table view through calling the ftp, using credentials and some sore of concat(key in below examples) of the data's…
-
Chart properties subtotals and weighted averages
Hello, Hope you all are having a great week. I have a question about one of the new analyzer additions(which I Love) and in particular chart properties Total Row sub-totalling. It works great for summing up values but when it comes to showing total %, to let's say % to plan, it totals all the %'s and doesn't use a weighted…
