Best Of
Re: Monthly Reports (Google Sheet). Help with next steps.
There is a Google Sheets connector that you can use. You'll want to prepare your spreadsheet as much as possible before ingestion into Domo with the proper columns/labels. With this connector, you can set it up to import manually, or on a schedule.
If there are any transformation that are difficult to do in Google Sheets, you can leverage MagicETL within Domo to get your data in the proper structure before using it in visualizations.
Here is a link to the connector -
And an article with more information on the connector -
Re: Hashing Data in Domo
There is a beta you can participate in by reaching out to your CSM. It is the Column Masking PDP beta. It will allow you to hash data in Domo. Disclaimer: beta participation is not guaranteed and is by request.
Re: Magic ETL - tile now beyond scroll ability
@Jbrorby I'd say if your canvas looks like that you're probably reaching the limits of what should be done in a single ETL. A better practice might be to break some of these sections into their own ETL's and then use those outputs as inputs into a main dataflow that gives the same output as this. Just based on your screenshot it looks like you have a lot of different inputs that feed into it, are there any logical groups you could start to break this up with?
Re: Magic ETL - tile now beyond scroll ability
I think what others have said are more likely, but I am curious if this has anything to do with the ETL mini-map beta. Are you a part of that beta? You'll know if you are if this map pops up in the bottom right of your ETL:
Re: Creating a date range in Beast Mode
If you're going to go this route, use the Domo Date Dimension so you don't have to keep updating the spreadsheet and calculate the groupings dynamically.
Re: Need to update the logic from a previous discussion
In order to do that, you would need to fill in the missing data. The best place to do this would most likely be in your ETL combined with a date dimension. This will help you make sure you have data for every single day of the week.
You can also wrap your column inside of an IFNULL() to replace Nulls with Zero
Does the DomoStats Consumption Datasets count towards our Credit Consumption?
See title. I feel like that's a slimy move to say, here check out your credits, and by the way, to see how much you're using, it'll cost you… But maybe that's just me.
T8or
Re: Freeze Top Row of Tables
I agree this could be a good enhancement to Heatmap tables specifically, as that doesn't show up in their chart properties.
My recommendation for an alternative is to use Mega Tables as column names are locked at the top as you scroll. See also Chart properties > Heatmap options in to apply coloring to get colors how you want. Also, in the General > Number of locked columns, one can lock the number of columns to allow a side-scroll. The Header Row settings here are mostly for formatting and height.
Also, Pivot Table headers are frozen at the top automatically with a couple formatting settings shown in this doc -
Re: Magic ETL Join Tile
@ArborRose Something super cool coming to beta that will help with this! Our MagicETL product team has been working on an update to the join tile that will allow for custom expressions as the join condition (think formula-based filter). It's undergoing a small UI update but will be re-entering beta next week.
zcameron
Re: Magic ETL - tile now beyond scroll ability
I would also confirm if it is occurring from another browser. However, if you have tested the scale and the issue is still happening. I recommend submitting a case with our support.
JJohnson