marcel_luthi Coach

404 is the not found error. From the documentation, it seems Domo Bricks currently only supports getting data through either the SQL Endpoint or the Data Endpoint, not the Search one you're trying to leverage here. You might be able to work around this if you can use a different library to perform the call to the search…

What kind of card are you trying to use and what does the raw data look like? Some cards in Domo come pre-built with Period over Period capabilities that would take care of showing this for you without the need of any BeastMode, this works great specially if your data for each month is calculated by the default Group By…

If you're using a Date field, Bar cards would by default fill out Missing Dates, you can disable this in the card properties.

What does your data look like and what kind of card are you outputting your result to? On your approach, you're only fixing by Year but if your data is meant to be broken down by person as well, you'll also need to include that in your fix function (otherwise it'll be the fixed of the entire universe and not for each…

@john_nguyen what are you trying to achieve here? The formula is failing because you're not specifying what the INTERVAL is (DAY, MONTH, etc), once you add that before the THEN on each clause it will no longer fail. However, it's most likely not doing what you want as the WHEN statement is not really returning a…

Is there any particular reason why you're using MAX(SUM() FIXED())? You also mentioned the Denominator being the same as the Numerator without the hour part, but in the last formula I see you're using 2 different aggregation columns. More often than not, you'll use a SUM(SUM() FIXED()) approach if the goal is to get the…

There are limitations on how Pivot Tables are shown there is an open Idea you can support: For your specific purpose you might be able to get it to look the way you want by: Leave the Suppress Single Line items option unchecked. While in Analyzer, hover over the first entry in the Currency Column, and you'll see a…

While hovering over the filter indicator for the card will tell you which filters are being applied to it and hovering on the filter name tells you which DataSets are affected by it, most users are unlikely to know which of the cards in the story are from one of the listed datasets, so this visual aid would be awesome!

Just to be clear, your dataset currently has 3 columns: row number (unique always filled) C which currently has only a couple of values and most of them are null, and that you're trying to fill out Property Data with the actual names of the companies While I would strongly advise to have this filled in the source, if that…

@ST_-Superman-_ suggestion sounds like the most scalable and clean solution, so that way the system will always show the top N categories and group the rest of them under other but still allow you to see how that other is made up when interacting with the card. This makes it dynamic, so that in the future or for the the…

Agree with @MichelleH, first thing is to know what valid values look like in Domo, as there is no intrinsic conversion from Float to Date. Since the type is returned as float, that either means most of your entries were -3 which is how Domo decided to use that type for that field (not so great news and perhaps you'd need…

This is a duplicate for: Not sure if or how they can be merged 🤔

A less elegant way which I had to use in the past, that might come in handy in your case (supposing the quarter is an actual value and not dates that you're having Domo aggregate to a specific quarter, in which case you'll need to deal with it). So my sample dataset has 2 columns as you mentioned, Revenue and Collected…

I just tested on my end and seems to be working. What kind of card are you trying to use this in? I've done so in a Megatable with no issues. You need to be in the card view mode not the Analyzer for the link to work. When looking at the card and clicking on the link it opens in a new tab as expected. Keep in mind that…

That's weird, perhaps a new layout being rolled out, as I still get the check boxes there but there are many differences between your view and mine (we both have the same role). A silly question, but just in case as sometimes pages might render differently if you're working on a mobile device and some options might not be…

I'm not 100% familiar with the Google Drive Service Connector, but from the documentation, this will allow you to get information about the files in Drive, not to actually read the contents of those files, which I understand is what you're attempting to achieve. You can see this by the fact that this connector only has 2…

Do you have the default Admin Role or a custom one? Go to the Users Section and make sure your role is Admin: If it is and the check boxes are not showing I'd open a ticket with Domo support. If you have a role other than the default admin one, make sure that role has the Manage all Cards, Pages and Data apps permission…

If we're talking about wishes, I'd also love LIST_AGG to be included, but I know that is not as standard 😅

You'll need to host your image elsewhere, outside of Domo. There are several free image hosting sites out there you can check and perhaps use depending on how sensitive your data is. If your company has a website and FTP access, you might want to talk with the department that manages it to see if they can create a…

An update on this. After reading other questions, I was able to get the text and image to show in the same cell, but to do that I had to use the HTML table option, not the Mega Table. Please try that and see if it works for you, also worked for partial links. The Adding Graphics, Links, and Images to Table Cards Using…

@user046467 can you post a sample of what the dataset you have looks like? As Grant said, you can do a lot with Windows functions (or the Fixed function) but there are limitations for which pre-aggregating needs to happen at a ETL level, but without fully understanding what your data looks like, we're mostly guessing in…

I cannot agree more, I have some ETLs that are practically impossible to follow visually.

I have tried multiple ways and I can only get the image to show, whether I use a table, div with float or with display flex; similar to how if a use a href tag, I cannot make only a portion of the text a hyperlink. Is there any particular need why you would need the Image and the text to be together as part of a single…

Just in case needed, here's what the ETL to stack this might end up looking like: From there you use the formulas that @GrantSmith shared, the only thing you might want to consider is on the last one if it's possible to have dates with Services but no Sales as this would make the ratio to be a DIV/0, which you might want…

Quick question, should the link just take you to the main ADP website or a specific page? I learned from experience that mixing double and single quotes is often misleading and confusing. The following syntax should work and take you to the ADP homepage on all rows, you might need to update the href to something different…

Would be good to highlight that if you go the ETL route, things will go eerie if besides the selection of # of days, the users (or you) need to apply apply filters to the card level, as the Rank and Window Tiles won't be responsive to these filters and might end up throwing odd results (One of the key difference on when to…

Thanks, extremely useful for when you want to display multiple summary numbers!

Keep in mind that if your string contains more than a single -, you might need to update the formula slightly. @MarkSnodgrass video on how to build a word can be used as a reference to build this, you only need the part to know how many - are in the original string to know to get the last part.

The suppress single line subtotals work up to a certain point and with certain limitations from what I've tested in the past: Sometimes you want some subtotals to show even when there is a single line, to drive consistency in presentation. In Mark example the second block (104471) is the perfect representation of this, if…

I might be wrong, so right now your Dataset would be pivoted, so in a single Row per project you have up to 9 possible Go-Live Dates (with Initial and Actual) for each. Something like: There are 2 approaches I can think of for this: Beast Mode approach: One that will return the number of times it was completed within the…