ST_Superman Domo Employee

You will need to use the "Grouped Bar" chart type

Try adding a second Value Scale. You then want the $ value fields to be on one scale and the % fields on the other scale.

Are you wanting the same bar to display both the $ and %? You can try using the Data Label Settings in the analyzer. Use the macros "%_VALUE | %_PERCENT_OF_CATEGORY"

I think that you would need to set this up on a period over period graph. But then it should be possible. Do you have a period over period chart set up? Looking at current month versus previous months? I would suggest starting with that. Once you have the period over period chart set up, let me know if you are still stuck…

I think that Domo ran into some indexing errors on their side over the weekend. I also had a data flow that ran for over 2 days (over the weekend) without erroring out while stuck on the Indexing step. I submitted a ticket through Domo support. I canceled the data flow and ran it again manually, which ran successfully in…

This error occurs when the Left data set of your join has over 10,000 duplicates. If you are joining sales data to customer data for example. The assumption would be that you would join on a customer id field. If you place your sales data on the left, your customer data on the right and then join on customer id; then the…

I suppose that depends on the size of the data set and how you are joining the data. Can you provide more details? I have found that when I try to join 3 or more tables in the same select statement it can sometimes add significant runtime. If you have any transforms that are doing that you may want to consider splitting…

It depends on the chart type. Here is a link to the knowledge base: http://knowledge.domo.com?cid=labelsandhovers

select case when `Activity Date`>='2018-04-24' then 0 else `Revenue` end as `Calculated_Revenue` If you wanted to save the field with the same name, then you could just end it with "end as `Revenue`" instead.

Every case statement needs to finish with an end statement: CASE WHEN `Discount`=0 then `Quantity`/ 64 else `Quantity` / 24 END You will also need to make sure that the `Discount` field is a numeric field. If it is text, then you will need to do: CASE WHEN `Discount`='0' then `Quantity`/ 64 else `Quantity` / 24 END

You need to be using a graph with a date field on an axis. You also need to make sure that the "disable annotations" chart property is not checked:

There was a feature announced at Domopalooza that I think should provide you with this functionality. I have not seen a release date yet, but you will be able to create more of a customized dashboard view with more editable layout options. Anyone from Domo able to shed light on when that may get released?

To quote Joey from Friends, it may be a "moo" point anyway as I could not filter on this field.

They are a little tricky to get working, but window functions are available in beast mode.

I'm wondering if a Windowed function would work for this: SUM( CASE WHEN `Item` = 'ARM' AND `Opportunity Status` NOT IN ( 'closed won','lost') THEN 1 ELSE 0 END) OVER (PARTITION BY `Employee Identifier`) You would need to first have the data sorted by the employee identifier field for this to work. But this would provide a…

You cannot use an aggregate function as a filter. You could sort in ascending order and then the reps with 0 opportunities should be listed first.

I think they announced the updates prior to the actual release. My understanding is that they will be released this week.

I agree that it would be nice to have this ability in MySQL data flows. However, you can use window functions in redshift:

My suggestion would be to just remove the negative number. Rather than showing -65k, have it show 65k. The "Negative" can be assumed based on the title of the field. This would get tricky when you have an actual positive value because it would then show negative. However, that is the only way that I can think to flip the…

if you are using redshift, you can use TO_DATE(`string`, format) example: select to_date ('02 Oct 2001', 'DD Mon YYYY');

To my knowledge, you are not able to create a custom hierarchy for data fields, which is what I believe would be required to create the visualisation you are looking for. However, I started by normalizing your data (collapse collumn in ETL) to create something like this: Then I created a grouped bar chart and used country…

I would say go for it then. Create a new data fusion to join the two data sets and compare. I'm curious how the two would perform compared with one another. If you do get it working, please post how the datafusion performs versus the ETL data flow.

Have you attempted this with a datafusion yet? As I mentioned earlier, I don't have much experience with that tool. However, for data sets of this size, I would tend to rely on a redshift data flow over the ETL. The limitations of the datafusion (output cannot be used in another dataflow and you cannot apply PDP rules to a…

So I guess the question now becomes, do you want to know what those descriptives are currently, or at the time in question. My suggestion is to take your 65k rows each day and run them through the data flow that will attach these "descriptives" from Salesforce. You would then have a complete data set for that day. You…

I have not had experience with datafusion. However, have you considered splitting up your main data flow? Rather than rewriting all 30 million rows, have you considered an append? I'm assuming you are adding ~65k rows each day. Do the historical rows change as well? If not, you could run the data flow only for the most…

This is a lot of data to consume in one visualization. Have you considered splitting this up into multiple cards? Or, if you are going to present from Domo, you could start with a higher level view of the survey results and build out a drill path that would get to the level of detail you want.

Sorry about that. Good catch

You could try this. Using this field as a filter and select 'true' to show only dates you are looking for. case when year(`datecolumn`) <= year(date_sub(curdate(), interval 4 month)) and month(`datecolumn`) <= month(date_sub(curdate(), interval 4 month)) then 'true' else 'false' end

you may need to first use the replace text action. Excel will often populate a ' ' instead of a null value. Use the replace text action to search for ' ' and then replace it with null. Then you should be able to change the data type

This is the only info I could find on changing font size: https://knowledge.domo.com/?cid=fontsize Unfortunately, it doesn't look like it's an option for funnel charts.