ST_Superman Domo Employee

Try this out. This will check the current time and if it is after 11:00 it will say that data for today is "Current", if it is before 11:00 it will say that yesterday's data is "Current" CASE WHEN NOW() >= CONCAT(CURDATE(),' 11:00:00') THEN CASE WHEN `Closing Date` < CURDATE() THEN 'Past' ELSE 'Current' END ELSE CASE WHEN…

Have you tried using a Sumo card? That is really the best way to pivot data in a visualization right now. I ran into this issue in the opposite direction. I had a data set with the months listed as separate columns and I needed a flat file. I was able to find a dynamic SQL statement to collapse the columns regardless of…

I don’t believe this is possible in a beast mode. You could try this in an ETL by first sorting by the target field, then creating a rank column, grouped by the target field. Last, you would want to create a windowed function where you take the max of the rank column, partitioned over the target field. You could then then…

What is the data in Fiscal Period? You need to aggregate that field as well. Instead of `Fiscal Period` you need something like MAX(`Fiscal Period`)

The Domo Admin plug in is not widely made available for some reason. You will need to contact someone from Domo to see if they can get you that plug in. maybe @DaniBoy can point you in the right direction

I think that you have to perform three actions to accomplish this inside an ETL. 1. Select Columns - You will want to select your unique identifier and any columns that you are wanting to copy and change the type of. I would recommend changing the name of the column in this step as well. 2. Set Column Type - Change the…

When you are testing the logic, I would add on a lot of filters to narrow down the data sets. Rather than sales accross the globe, focus on one country, or even one city. If you apply the same filters to each dataset as you are "previewing" the data; you should be able to see how the joins are performing. Once you are…

There is a pretty handy Excel plug in that will help you do this, but I am not sure of a way to do it from within the Domo instance. Maybe if you set up the MyDomo app?

You also need to make sure that the Date Range Field is being used in the table or visualization. If you don't actually want to see the date, then you could apply the date field to the sort by section.

You could also just make a card with the first 5 bars and then have it linked to the full card. This way, when the user was viewing the dashboard, they would just see the first 5 bars but when they clicked on it for more detail there could be a linked card that would take them to the full data set. The option to link a…

Hi, Welcome to Domo and to the Dojo ? There are two ways to approach this. The first is to make the thumbnail as large as possible The second, is to adjust how the card is displaying the data. It looks like you have a very long tail on the card that you shared, you can have Domo display the top 15 or 25 bars of data and…

Hi, If I'm understanding the question correctly, you can accomplish this with page filters (there is rumor of a page quick filter option in the works that will make this much easier to use). Under the wrench menu, you will want to select "Turn on Page Filters" then you select the field that you want to filter all of the…

I agree with @AS Aaron here. You will need to have a total sales column in your drill down data set. If you don't already have it, you can create it with the windowed function in the ETL (or with a MySQL Redshift data flow). Let us know if you need help creating the field. Or if this isn't the issue, we will have to go…

I struggled with this one. This may be a case where Excel performs better than Domo at the moment. I could not find a way to get the calculated `Delta Budget` field to calculate currectly for the total row. Instead, you have to pick an agregate function (sum, min, max, avg, etc.) which does not work at all. You can see in…

I really wanted to learn how to do this with the regex function in the ETL dataflow. However, I am not any good at regex so I gave up. Here is a solution for this with a MySQL select statement: I will paste the code here so you can copy and paste... SELECT `Placement Name` ,SUBSTRING_INDEX(`part1`, '_',1) as `output` FROM…

Talk to your Domo CSM about setting up the "MyDomo" app in your instance

There are two chart properties that should help you accomplish this. The first will display a percentage in the legend: The second will display the percentage in the pie chart itself:

Thanks @zcameron Also, for what it's worth... had I seen your post prior to working on this, I would have moved on to the next topic. ?

This request cannot be completed with a beast mode alone. Beast modes cannot perform functions to look accross multiple rows of data. You first need to add a field to your data set that will provide the First Receiving Day for each Order Number. I did this with an ETL: I began by using your supplied data set as the input…

I'm not sure what is gained by trying to uncheck the generate output table when the function you are writing the code for is to create a table.

The workbench is driven from the client side. You can create some scripts that would allow you to schedule regular uploads, but Domo does not have the ability to request the data from your workbench.

I would recommend learning how to implement PDP in your instance. Contact your Domo CSM and see if they can put you in touch with someone to set this up. We have a fairly large instance and we are pushing our metrics out to our global salesforce. We don't want sales reps to have access to information for any account that…

If you would like help with the MySQL code, feel free to ask. But @AS is right, I'm not aware of a way to do this inside an ETL at the moment. I have heard tell of some additions to ETL that will allow you to write in Python or R code directly to the ETL. But for now, I think MySQL is your solution.

I feel that there are more advantages to keeping the dataset together as one big dataset. We have some pretty large data sets and I have not seen any noticeable delay in performance when using a large data set. The biggest advantage is that when you create a new card, even if it is for a specific facility, you could easily…

I think that you want to take the count function out of the case statements. Try something like this: COUNT(DISTINCT CASE WHEN `Data Source`='Collected' THEN `Message Key` END) + COUNT(CASE WHEN `Data Source` = 'Delivered' THEN `Data Source` END)

That's great news! I'm constantly encouraged by how quickly Domo accepts feedback and implements changes. Keep up the good work guys!

I have not tested this, but I would be curious if all the the views in your drill path are using the same data set. Do you change data sets after the third view? I've run into some strange issues when I swap data sets along the drill path.

I was able to accomplish this with the following steps in MySQL: SELECT `Resolution Time` ,STR_TO_DATE(`Resolution Time`,'%H:%i:%s') as `Date field` FROM table_name This will change your text column to a date time column. Then I changed the time to seconds, summed them and converted the seconds back to your format with…

That's correct. Currently, you need to set the date grain on the main card before drilling into the data. I believe this feature has been posted in the ideas section, but if not you should add it ?

Is it possible that the task names are slightly different? I noticed that your field names were different `TaskName` and `Task Name`. This shouldn't be an issue, but if the task was also slightly different then they would not join. Something like 'RunReport' and 'Run Report' or even 'run report' would not be matched.…