ST_Superman Domo Employee

This is a great use for this card! Thanks for sharing. You just earned yourself another youtube subscriber as well ?

This will need to be handled at the data set level. So you will need to create these calculations withing a dataflow. I'm assuming your data is set up to look something like this:…

Yes. You will need to install the domo app in each instance of Salesforce that you are wanting to connect.

I would encourage you to change the field type of any ID field to a string. Only use values for fields that you want to do calculations on

Is the Marketing Department the only department that is missing an Organization ID? if all the other rows apart from marketing have a value in them, you could just use a replace text to replace any null or blank values with 4410. otherwise you would need to filter just the marketing values first and then perform the…

I'm not finding anything either. My guess is that the embed feature is not available yet? I'll do some more digging to see if I can uncover anything.

There is definitely a bit of a learning curve when trying to switch from MySQL to ETL data flows. I find myself using a lot of both. Somethings make more sense to me in ETL (particularly collapsing or uncollapsing data sets and windowed functions) while other things seem easier to do in MySQL. The biggest pointer that I…

I would suggest creating a webform called "exclusion_accounts" You could then bring that into your ETL as another input data set. Then join it to your table with an outer join so that you end up with only the accounts not in the exclusion data set. Let me know if you need more details

Can you show me the settings of your graph?

I believe that "filter" card is actually a custom SVG map. By leveraging the custom map with interactive filters, the card is essentially operating as a filter card.

You should be able to click through the announcements. There is some really good stuff there though, so I would recommend reading them.

I think even a regular user should be able to add themselves (or others) to a page that they own. Try going into the admin section and adding yourself back to the page

There are alternatives, but it looks like this beta is getting released publicly this week. Let's revisit this after you have access to this feature. In the meantime, could you message me with a sample of your data set?

Try this sum(case when `Status` = 'Open' then `Value` Else 0 end) / (100000 - SUM(case when `Status` = 'Won' then `Value` else 0 end))

As an alternative, there is a “Domo Admin” plug in for excel that would let you pull down your card metadata (including page name and card title). You could then concat the page name with the card titles in excel and then use the plugin to push the new values back into Domo as new card titles. beats manually updating them.…

I would be happy to help you out. Can you share a sample of your data set? Also, does your Domo instance have access to the “design dashboard” feature?

You can get a little fancier if you have the Dashboard layout beta:

I'm not sure what your data set looks like, but have you tried the 100% Stacked bar graph type?

I want a function to display the conversion contents created by ETL in SQL format I'm just providing some basic translation as I would like to see this idea get some upvotes. If I'm understanding correctly, you would like something similar to what the advanced salesforce connector offers where you have a visual component…

I believe that the image you are showing is a bit misleading. I think it is actually an image, and not a dynamic bar graph built inside a table card. I do think this is a good feature request though. I feel like this functionality is pretty simple to accomplish with excel. 

Yes. It would be a calculated field. My first question would be do you have a field that names the projects in your data set? If you do, then create a new beastmode max(`project_name`) if you don’t have a field like that, you could just use max(‘Project A’) note that the second example is using single quotes instead of the…

Are you making use of the summary number? you could do something like: max(`Project_Name`) and pick that for your summary number. Then, you would be able to see the project name on the card. Have you considered creating a dashboard for yourself that would only contain one “version” of each of the cards that you could then…

Here is my advice for page/card/quick/interactive filters. You need to select one way to control any field you are wanting to filter for. For example, if you want to use th e interactive filters for the date field, then you shouldn’t apply any of the other filter methods to that field. You could use page filters for a…

Tooltip fields! Coming soon to a Domo instance near you. (or you can contact your friendly domo success manager to be added to the beta)

You will need to create your averages in a data flow. The calculated fields only have visibility to one “row” of data that is in your card at a time. Let me know if you want help with the data transforms. Some things to to think about... do you want to see a set average per year, or quarter, etc.? do you want to be able to…

Can you post a sample of your data set? And maybe an example of what the calculation should look like?

My guess is that your MMM-Actual column is a calculated field (formerly known as beastmode...) which is filtering the data somehow. Something like SUM(CASE when `Month` = 'Sep' and `Year` = `2018` then `Sales Actuals` else 0 end) You will need to apply a similar filter to the goal data: SUM(CASE when `Month`='Sep' and…

You could also use the SQL transform option to drop the columns. (you can only drop one column at a time though) Create a transform, select the SQL option: ALTER TABLE `table_name` DROP COLUMN `_BATCH_ID_`; then drop the other batch field: ALTER TABLE `table_name` DROP COLUMN `_BATCH_LAST_RUN_` You can then use SELECT a.*,…

This can be accomplished with filters depending on how your data is structured. My guess is that the Tableau data set is essentially stacking the data tables on top of each other with one column called `Date` that has values ('Daily', 'Weekly', 'Monthly', 'Quarterly', 'Yearly') and another column called `Date Channel` that…

I do not believe that this can be accomplished via the calculated fields, or beast modes. If I'm understanding the request, you want to get a rank of the top 60 days of sales performance (out of the last 120 days) for each day, and then return the value of the 60th best day out of those 120. As your post showed, that means…