n8isjack Contributor

@pauljames there are a lot of simple reasons that get in the way. Without more detail it is hard to say why that might be in your case. First, the above formula lets you see them side by side, but to compare them it would have to be aggregated. The same record cannot be both this year and last year, but if you use a SUM to…

Is ADP one of the approved links for you company? You might need to url approved by Domo Support.

Hi Ajita! I think you are really close. I think you are just missing the ending 'a' tag: </a> This example also simplifies the concat: CONCAT('<a href="https://www.adp.com/" target="_blank">', EmployeeID, '</a>') Good Luck! brought to you by Arigato Analytics www.arigatoanalytics.com

HUGE fans of Domo here... but who even asked for this? I don't get how it is better. It isn't easier. It isn't clearer. ...it isn't the end of the world. But it is no small frustration I feel when using it now. I'm guessing there was a reason, but for my team this is not helpful.

I get a the message. @StefanoG in your devtools network request can you see more information? Can you see the actual error message? When I do a domo request the promise rejects and I get the error message:

Hard to say. It should work just fine. I think it is likely to do with the actual path. Is it a file that is part of your custom app, or is it external. If it is external: Is it a publicly accessible path? Must you be logged-in to see the image?

Your Beastmode looks good, but you can't use the card's date selection because it is year specific. In essence when you choose 'This Month' then you filter out all data from last year. Consider these beastmodes with no date filter: `This Year` CASE WHEN YEAR(CURRENT_DATE()) = YEAR(`Date`) THEN `Net Sales` END `Last Year`…

Hm, it is very hard to know what you're doing from just the error logs. Can you show us any of the script you wrote? Including packages, but perhaps delete the sensitive stuff like credentials?

Ok, remove duplicates. Powerful and scary at the same time. I've killed myself over it in years past, not just in DOMO. I'm happy to share what I've learned. Hope it helps. Here is our pretend data: Shape Weight Color Date Square 3 blue 2019-01-01 Square 3 blue 2019-02-01 Square 3 blue 2019-07-01 Square 23 blue 2019-05-01…

You may have already found the answer, but it sounds like you need to update the [Group By] action so that in step 1, you ONLY select the state field. The aggregation could COUNT any of the other fields that is never blank. The result will only have one row per state, the state name and count of rows. Then you can [Join…

There are a handful of ways to achieve this, but almost all of them require a dataflow or blend. My prefered way is via SQL, which also could have a lot of approaches. It can be done via magic etl as well, so I'll show that too. Here is the logical thought process: * Get the maximum _BATCH_ID_ value in the dataset (1…

I have to think that you are getting NULL values for your rounded numbers. Such as where there are no records that match your case statements when you filter. It would be quick to test out. Try wrapping the numeric calculations in an "IFNULL(...,0)" function to default nulls to zero. Like this: CONCAT( '<div style=…

That probably just means the id/secret were wrong.

Did you use domo.js to get data from a dataset? That will enable you to change the graph to match the data.

First you need a clean id to join on. I don't know if those are typos under your [Object UID] field or not, but it would need to have all non-numeric characters removed. Then you can join the two tables normally. Then you have the lift of creating a new "Number of Cats" field and one for dogs, etc... * For the clean id you…

I would start with a Sumo Card, using the pivot settings. Stores in the row categories. Date in the column categories (with a date grain of weekly) Sales in the values section

You could possibly do it in one step: REGEX: ^.*\|(.*)\|.*$ REPLACE: $1 The trick is to make sure your pattern matches the ENTIRE string. Use parenthesis to capture the part you want to keep and when you replace with the captured portion it will replace the entire matched string (which is the whole field) with the captured…

It should happen automatically. Couple questions: * What chart type are you using? * Are any chart properties sets? * Is the date field accidentally a text field?

I know Domo has a time limit for calculations. If the query can't run quickly they kill it to keep all other cards/dashboards loading. COUNT(DISTINCT) is probably the worst performant aggregate function. It is just so awesome. I can imagine that if anything was going to kill a card it would be COUNT(DISTINCT). Sometimes…

First, let me make sure I have my head wrapped around what you are trying to do. Playing with your data, with a name for the columns: Number Color 1 red 1 blue 2 purple 2 purple 3 yellow 3 red 3 blue 3 yellow If I understand correctly, you don't want the `Number` column to be associated with more than one value for…

Additional note if this is for a table card. You can still do your own html links if you disable the drill paths. We did this before and turned off drill paths, then for the first column only we did a beastmode that resulted in a hyperlink to another page. It is possible to filter that next page/card too... but that is…

Yes you can, but if you are showing a lot of columns it could be difficult. If any single column is aggregated then the others will only show unique values. To test it simple just add two columns such as agent and count of `somethingelse` If this is your data: Agent Amount Product Jim 50 Box Jim 60 Bag Jim 40 Box Jenny 90…

Let me clarify. Did you remove access to the page for yourself? If this is the case an admin can add the page back for you in Admin > Pages. Also, depending on the user's permissions if someone else has the page still they could add you back.

The API does not allow for filtering data, unfortunately. You will have to download the whole file and then parse and filter it programmatically. I don't have a great workaround suggestion for you, but here is one advanced possibility: Using a Blend (Data Fusion): The api will let you download a blend dataset. The…

Sure! When I say 'simplify' I mean pick as few "Dimensions" as possible. Here is a screenshot of the selected dimensions for a Google Analytics connector: Google Analytics Connector There are 3 Dimensions selected. * Date: like 1/1/2019 * Medium: organic/social/referral/etc... * Source: website where they clicked the link…

It is difficult to know for sure, but for Google Analytics there is one main gotcha that will cause exactly what you are seeing. I'd bet you have Dimensions that are inflating the number. This applies to Visits or Users as well. Short Answer: The same session is counting more than once and you need to simplify your…

I am pretty certain that only Table Cards and Summary Numbers are allowed to show html. It is blocked anywhere else and treated like plain text like you see here. There are advanced methods for creating custom cards that bring power via Design Studio or Dev Studio.

Will you help make sure I understand what you mean by Accounts. * Dataset accounts used for connectors? Data Center > Accounts * User accounts associated with your login? * Access Tokens used for automation? * Client ID / Client Secret used for APIs? Logging into Workbench is assiciated with an individual. Workbench jobs…

Something to consider is that you can embed Trello into a custom card. Using the Dev Studio, which is an Advanced Domo topic but a fairly straight forward html atmosphere, you can embed anything you want into Domo. I've seen Google docs embedded right into a page. The team uses google sheets right inside of Domo. If you…

?