ST_Superman Domo Employee

You need to aggregate the data to the same level prior to joining the tables. You will need your revenue table and your spend table to aggregate their values by date and AdID. SELECT `AdID` ,count(`AdID`) -- this will tell you how many times the AdID appears each day ,`Date` ,sum(`Spend`) as `Total Spend` FROM spend_table…

This is why I will only select one data source when telling Domo to run when datasets update. I do think it would be a product improvement if Domo could check if the dataset had a run time that started after each of the input datasets last updated. You should be able to set an alert with the "Domo Stats - Data Sets" data.…

Yes and no... You can use windowed functions in a redshift dataflow. But not in the standard MySQL dataflow option. If you aren't familiar with redshift, then you will need to study up on some of the differences because it uses some different syntax.

I assumed it was to be used if you were using the profile as a directory. Similar to the alternate phone number. Domo communicates by using the primary email or texting the primary phone number, but users can choose to display alternates if they wish. Most of my users would get annoyed if they received the same message in…

I would suggest the following steps in a SQL dataflow: SELECT `Kingdom`, `Animal', MAX(`Age`) as `Max Age`, MAX(`Weight`) as `Max Weight` FROM 'Table' Group By 1,2 This will give you a table with: Kingdom, Animal, Max Age, Max Weight Then you can get your desired output table: SELECT `Kingdom`, SUM(`Max Age`) as `Age`,…

I'm not familiar with "messaging dashboard" Could you explain what you are looking for?

When you hover over a visualization, you are shown the hover text for the spot your mouse is at as well as the "Hints" or tooltips for the other areas of the graph. If you select "Remove Hints", you will no longer see the tooltips when hovering. I am not aware of a way to customize the hints to display the % however. That…

If you need more help on this, it would be helpful to learn more about your data structure and how you are wanting to display it.

The mega table is in beta. My understanding is that when it is ready for public release, it will simply replace the table card. @chucki in case I've got this wrong...

Python has a len() function... you would just define your new field... something like this length = len(string_field)

You just need to filter your list first. I created a basic dataset to try to mimic this for you here: In this case, I have two Site IDs that have the same customer name, "Clark Kent". The first step is to create two filters. One that contains the data that you don't want to change, and one that has everything you want…

You could also do a calculation to get the max date for each contact ID. Then perform a calculation to determine how many days ago that was. Finally filter out any contacts where there have been more than 365 days since the last activity. This way you wouldn't be restricted to a calendar year (and having to rework it each…

I'm not super familiar with setting this up in Workbench, but it appears that the LAST_VALUE syntax in oracle would require some kind of a window I'm not sure how to define the window in workbench, but I would assume your issue is with the last value function in your where clause

translation provided by google: I want to study certification exams on an iPad or smartphone I want to run Partner Learning Center (PLC) on mobile (iPad or mobile), but the screen is cut off. Is n’t it mobile-friendly? If it is not done, can you respond?

@John-Peddle in case he knows what a Peddle stat is ?

can you show what kind of card you are using the calculation on? I tried to create a sample data set and found your calculation performing correctly.

Hi @julz Welcome to Domo, and to the Dojo. It is hard to say what the most efficient way of doing something will be for you. It depends a lot on how your data is structured, and what you are looking to produce. If you don't mind sharing your dataset schema and perhaps a few examples of what you would like your output to…

I'm not aware of a way to hide the header altogether. However, you could "hide" the text by making the font color the same as the fill color

@jeffcroskrey tell me more about this beta... and why hasn't @chucki invited me to it yet? ?

The summary number does have to be an aggregate function. Maybe I just need some more details about what you are trying to create a link to, and how you want that to work. I've created links using something like this in the past: max(concat('<a href="' ,'https://your_url.my.salesforce.com/',`Salesforce Account ID`, '"…

You can also use ALTER TABLE your_table DROP COLUMN `Column1`,`Column2`,...; If you are only looking to remove a few columns. (This would be in a MySQL dataflow as well)

It's removed for me as well

You can also use HTML code in summary numbers. You can use that to create the link as well

I would recommend using magic ETL to first split your product column and then Collapse Columns to convert those column values into rows. The output you would be looking for would look more like this: OPPNUM Products 12345 Product1 12345 Product2 12345 Product3 22222 Product1 ... If you need to keep this in a beastmode…

I'm not sure those values are exact. What happens if you build a card from the data set and use count(distinct `Account ID SF`) In theory, you should end up with the same number of rows as your dataset. Not sure why (or how) there could ever be more. Sounds like a bug to me.

It's still there:

You can export your dataset from the "data" menu

You mention both ETL and SQL in your question. Are you wanting to add the unique row identifier in the magic ETL dataflow, or via the MySQL dataflow?

You would need to do this in a MySQL dataflow, but I believe you can use the CONV() function there SELECT CONV(`hex field`,16,10) as `decimal field`

Good point. It should really be: (COUNT(DISTINCT case when `useractivity_status` = 'Active User' then `usersid` end))/ (COUNT(DISTINCT `usersid`) over ())