ST_Superman Domo Employee

You can create a Bar and Line or Bar and Symbol chart. I am not aware of an option to create a Symbol and Line chart. Try creating your visualization as one of these other options and see if it will work for you.

You will need to prep your data some to accomplish this. You need to have a unique Identifier for each. The data sets in Domo do not have multiple "sheets". You will need to import each sheet into Domo as a separate data set. You can then create a dataflow and join the two data sets on your indentifier field.

I've run into an issue with saving cards when using a beastmode field as a quick filter. Try removing any beastmodes from the filters and see if that will allow you to save the card.

This seems to be an odd request for a visualization. The best solution I can come up with is just a table card with a beastmode that would give you the User / Reviewer. The beastmode I used is: CONCAT(`User Name`,' / ',`Submission Reviewed By`)

No worries, you just need to change my formula to fit your field names: I used `Date` because I did not know what you called your date field. Change it to `Your Date Field Name` and it should work

Could you provide some additional information on your question? I'm not sure I understand exactly what you are asking here.

You can accomplish this by creating a beast mode calculation and then using that calculation as a filter case when `Date` = CURDATE() THEN 'true' when `Date` = DATE_SUB(CURDATE(), INTERVAL 30 DAY) THEN 'true' else 'false' end

There is currently a feature within a card called quick filters. Domo is currently working on a "page" quick filter that would allow you to apply these quick filters to all of the cards on a page. However, the current process for accomplishing this requires some extra clicks and does not look quite as clean. You will need…

This is a pretty common issue with Beast Modes. When you are thinking about when to try to tackle something with a beastmode calculation, it is important to understand that these calculations can only look at one row of data to perform the calculation. To create a running total, you will need to add some transforms in a…

The only thought that I have is that ETL just doesn't like joining data when the left table has more than 10,000 duplicate "keys" in it. It's an interesting question as to why this is an issue, but I would just keep your larger lists on the right side of the joins.

Are you joining on a unique identifier? could you provide some more information about the data involved?

You can make a County map. You need to join the Zip2Fips data set from Domo Dimensions to your zip codes. Then you can create maps like this: I'm not aware of a way to get it down to the zip code level. Maybe someone else has more insight into that and will share.

You may have stumbled accross a bug. The chart properties keep all of the same settings when I use the save as option.

Try bringing the data into an ETL first, so that you can change the type of your date field to a date. That should solve this issue.

Can you provide some more information about what you are trying to graph? Maybe give a screen shot of the graphs you are trying to emulate in the new analyzer? I'm sure that the ability to replicate the graph still exists, but I'm not sure how to get you there from the info you gave.

Then I think this would work to stack up the data for you in a MySQL data flow: select sum(case when `Type`='Opportunity' then `FY 2018` end) as `Opportunity` ,sum(case when `Type`='Risk' then (`FY 2018` * -1) end) as `Risk` ,'FY18' as `Category` FROM risk_opportunities UNION ALL select sum(case when `Type`='Opportunity'…

Thanks for the response. I was under the assumption that your risk and opportunity for the two different groups was coming from two different data sets. Looking at the pics you shared in the original post, it looks like the fields that you are wanting to work with are from a beast mode as well. Would you mind sharing the…

The new analyzer that is getting released has a lot of new "Color Rules" that you can use to define the colors of each series.

Check the App store. There is an app called My Domo Community which would probably be a good place to start.

I would use MySQL for this issue. My understanding is that you have two different data sets. One for FY18 opp and risk; and one for predicted opp and risk. You will want to stack these two data sets into a single data set. SELECT fy.`opp` AS `Opportunity`, fy.`risk` AS `Risk`, (fy.`opp` + fy.`risk`) AS `Difference`, 'FY18'…

You could use an ETL:

The values are still there. They have just been imported as type DOUBLE. Depending on what you are wanting to do with the data, you can either convert it in MySQL using something like this: SELECT convert (`General`, decimal(9,7)) as `General` from dojo_help_2 You can use an ETL by usint the "Set Column Type" action and…

Excellent work! I do have a few suggestions though... The first is just a typo, you'll want to change the last line of Step 1 to "AND COLUMN_NAME <> 'Product Type';" I would then change Step 4 because as it stands, the Date field is a VARCHAR and not formatted as a date. SELECT `Product Type`…

Sorry, I was in a rush with my last post and just pasted an image from stack overflow. This is how you would create the running total in a mysql dataflow: * You need to create a procedure:* CREATE PROCEDURE runtot() BEGIN drop TABLE if exists running_totals; set @runtot:=0; create table if not exists running_totals as (…

I don't believe that there is a way to do this with a beastmode, but you could accomplish this inside a MySQL dataflow with something like this:

If you have a data set with no Date values, then the "Date Range" field is not an option. I'm not sure what the advantage would be of removing this option from a data set that contains date valuse, but if you really wanted to, you could just change the type of those fields in your data set and then the date range would go…

I would suggest the export to excel option. However, this still does not allow you to see the active filters that were applied. This may be a good suggestion to add to the Ideas section here.

When I need to "unpivot" with Domo, I like to go with ETL. There is a tile called Collapse Columns that does what you are wanting to do: Configuration This will "unpivot" the data for you... like so: Preview

can you look at a data table to check the values of those fields to make sure they are correct? Or you could create a sumo card to check the sum of unique visitors when the segment is Overall and when it is a conversion. It could be an issue with the data and not one with your beast mode.

Perhaps we need to look at the data to get a better picture of what is going on here. You have a column called `Segment Name` which contains the values "Conversion Activities - Overall" and "Overall". In your equation, we search for the value "Conversion Activities - Overall" and when we find that we sum the `Unique…