ST_Superman Domo Employee

You want to use the SQL option. You can then click on "+ADD TRANSFORM" and select the SQL option. This will allow you to write SQL code that does not create an output table. However, in order to save the dataflow, you will still need to create an output for the data flow. This single transform will not create a new table…

Yes. When you click on "Add Account" the default setting for some reason is for them to populate your email address for customer. However, the note to the side tells you that it should get populated with the portion of your URL before the .domo.com part. Try adding a new account and make sure to populate with the correct…

It looks like you have set up your your account incorrectly. The part that you ***'ed out should be your domain address (i.e. companyname.domo.com)

If you are wanting to edit the page owners, I think the functionality in the pages section of the Admin settings works pretty well. They have updated it some time back to allow you to make mass changes. You can search for a specific owner or parent page, etc. and then select all of the results and perform any of the…

This is definitely available now. There is an annual price tag associated with access to these ETL tiles, I would contact your Domo sales rep if you want an exact figure.

I feel like there is an echo here. I think this is the same issue that was brought up by @cwolman earlier today. If the input datasets are not changed when a data flow is scheduled to update, it won’t run. I would recommend adding an input data set that does update at the interval that you need youdont even need to include…

That should work. Essentially, Domo added a feature a while back that looks at the input data sets and if none of that data changes, then it won't run the job again. You need to have some kind of input data set (even if you don't end up using any of the fields) that will change each day.

It's a setting under the "General" Chart properties. You will need to have the two fields that you want to be lines added to your chart as the Y-axis and the first series. Then the bar field (or fields) can be put as the second (or third, etc.) series. You want to indicate that there should be 2 series on the left scale

If the data sets are not changing, is your expected output changing? You might want to try bringing in a data set that changes each day. (like one of the NOAA weather datasets) That way you would have a change in the input and the data set would fire.

I think you should be able to just join the data again, only this time join on cn_state. Then clean up the extra fields that are created.

I'm not sure if your Domo instance has this data set added or not, but there is a "Domo Governance Dataset" that offers what you are looking for. To get there, you will need to follow these steps: You will probably need to be an admin in order to bring this data in.

Could you provide a small sample of your data set? I think it might help to understand how the data is structured and what your expected calculation is. Also, it looks like you are trying to track sales (or something similar) for the first month of a customer. I would probably suggest engineering at least one field in your…

The integration cloud might offer some more appealing alternatives. It allows you to write back to outside applications like OneDrive or smart sheet directly from a Domo dataset.

The beast modes were in my first picture it’s just: QUARTER(‘date_field’) and YEAR(‘date_field’)

oops, I also switched that last chart to a grouped bar and not a stacked bar

Just swap quarter and year then:

You can accomplish this using the new category 2 field. Let me know if this is what you were looking for. Or please provide some kind of sketch or screenshot if you had something else in mind.

Do the cards that you are trying to filter use the same date field as an axis?

My next guess is to make sure that you are only filtering in one way on the card. Domo offers several layers of filters. You can filter with page filters, filter cards, card level quick filters, and built in filters for a specific card (from the analyzer). In my experience, these filters don't all play nicely together. If…

Could you go to Edit dashboard and then click on the arrow next to your filter card. Select "Change Interaction" Then send a screenshot of those settings?

You could use the rank and window function tile in an ETL dataflow to accomplish this. You would basically need to have several date fields present; year, quarter, month, week, and date. Each field would essentially be a date calculation like YEAR(`Date_Field`), etc. You could then make a windowed function to rank the…

Add a filter to remove anything with a value of 0

Can you provide a screenshot of the visual bug? The only way that I know to pass filters through is by using some HTML coding from within a table card. I use that trick a lot to filter a destination page based on the line that is clicked on in a table card. I am not aware of a way to pass that on when you are talking about…

Here is a tutorial I made on Friday for creating a custom map to use as a page filter.

I don’t think you need the sum() part. Drop the sum and just use the + sign

You can add a transform step before or after any of the transforms

Those look great. Let me know if changing the background doesn’t work. I’m not familiar with illustrator, but that should do the trick. 

The colors won’t come through in the map. The map cards are all just one color with different shades for values. You could change it to any of the other themes, but it would be all one color. As for the squares, did you “draw” a square around your shapes when you labeled your groups? Or did you select the actual vectors…

You would need to have a .SVG image file. But here is a tutorial on how to use Inkscape to create regions embeded into a .svg image, which you could then use to upload as a custom map to your domo instance and then map your data to the regions that were created.…