ST_Superman Domo Employee

There really isn't a function for this. You just need to write the field name in the beast mode:

The color rules are applied to either the card or the color set. Both of which would get applied to your drill path. The work around is to create a beast mode that does not have the color rule. For example, if you have a color rule on `sales` and then you want to change or remove those rules on your drill path the beast…

In that case, it would probably be simpler to create separate cards for each of the metrics. But if it needs to be on the same card, and controlled by a quick filter then it's going to get very complicated.

You can accomplish this in a dataflow. You first need to collapse your columns down first. The idea is to change the data set from something that looks like Table A to Table B: You can then use the Value field as the y-axis and apply a quick filter on Type. Let me know if you would like help with the data transform.

I think that something like this would work as a summary number for this then: (I think it is easier to read in the photo, but I will paste the text here as well) good luck! CONCAT( ROUND((SUM( CASE WHEN `CHANNEL`='RET' THEN `CASE PICK` END) / SUM(CASE WHEN `CHANNEL`='RET' THEN `ORDER CASES` END))*100 ,2), '% for RET…

Any chance you could provide a snippet of your data? I'm not sure exactly what you are looking for, and it may help provide some suggestions.

You should be able to add as many calculations to that con at statement as you want. CONCAT( ROUND((SUM(case pick calculation) / SUM(order cases calculation))*100,2), ‘% | ‘, (SUM(CASE when `Channel`='RET' then `ordercases`end)),' | ', (SUM(CASE when `Channel`='FSV' then `ordercases`end)) ) i am am not sure what your…

I would recommend downloading the Domo plugin for Excel. You can find it in the Admin tools section: And then you can download the data set directly into Excel. This also allows you to update the data on your Excel sheet by clicking a button.

I'm not sure how to get access to redshift (we had access here when I started). I would contact Domo if you don't have it turned on. Meanwhile, you can accomplish the same thing with a couple of steps inside a MySQL dataflow. You would first need to create a list of Accounts and the max dates: SELECT `Name` ,MAX(`Date`) as…

I'm not sure if this is doable via an ETL. You can accomplish it with a redshift SQL dataflow. Obviously you would want to partition by your unique ID rather than the NAME field, but I didn't have that in my data set. Let me know if this works for you. I can try to look into the ETL option, but I'm not sure if it's…

I would just create a beastmode that will allow you to filter out today's date. You could then use this field to exlcude today's date and keep the date range as YTD. You would just filter to exclude 'true' values 

Is the last month always 12? I got it to sort correctly this way: The =test beast mode is: Otherwise, if your last month is not always 12 then you would need to add a field in the dataflow that would tell the formula what month to use. Something like `Max Month` that would be the same value for each line of data and then…

I would think I about creating a beastmode that would help you sort the data. Is the last column always the current month? CASE WHEN `MonthField`=MONTH(CURDATE()) THEN `ValueField` ELSE 0 END I think you should then be able to sort by this field in descending order first I'm not really able to test this out without any of…

Sorry, I just realized that I posted the TotalViews Card twice. Here is the AverageViewPercentage Card:

I have a couple of thoughts on this one. Are you sure that you want a table card with only one row of data for each ID? If you are open to viewing this with a visualization, you can do so with one card and a quickfilter (or with two cards): Otherwise, I think the easiest way to accomplish this in a table card is to use an…

Please up-vote my idea here: https://dojo.domo.com/t5/Ideas-Exchange/Display-quot-empty-quot-Date-values/idi-p/27318 I have the same issue

As Aaron mentioned earlier in this post (thank you @AS), you need to place the Aggregate function on the outside of your case statement. COUNT(DISTINCT (CASE when `Category` = 'service' then `Invoiceno` end)) Same with the others: SUM(CASE WHEN ‘promotions’ IS NOT NULL THEN ‘net amt’ END) COUNT(DISTINCT (CASE when `Gender`…

Thanks. I'm assuming that Callsid is a unique field for each call made. My thinking is that you would want to add a field COUNT(DISTINCT `Callsid`) OVER (PARTITION BY `CustomerPhoneNumber` ORDER BY `CustomerPhoneNumber`) as `NumberOfCalls` You would need to use the "redshift" option in a SQL dataflow to do this. This would…

My guess is that the data is coded in a different timezone. (UTC?) You can adjust the timezone using this statement: SELECT CONVERT_TIMEZONE('EST', `timestamp field`) this should convert the timezone to EST time. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Time-Zones/m-p/21326#M2285

You can improve the performance by adding an index prior to the joins. You have to add a transform for each table you are indexing. 3b) ALTER TABLE proc1 ADD INDEX(`dates`,`shop_town_id`); 3c) ALTER TABLE proc_group ADD INDEX(`created_at_trans`,`shop_town_id`); then run your join statement (#4) 4b) ALTER TABLE proc_join…

I found this article on APPROX_COUNT_DISTINCT: https://docs.memsql.com/sql-reference/v6.0/approx_count_distinct/ Hope that helps. It looks to be a performance issue when dealing with very large data sets.

I think that the issue here may be more related to the limit of beast mode calculations. Could you provide a sample of your data set? I think you could accomplish this by engineering some fields with a MySQL data flow, or possibly a Magic ETL but I would like to see a sample data set before going too far down this road.

Thank you Aaron. Happy Holidays to you as well.

I believe that you can accomplish this with the "Scale Marker" chart property.

This is not something that you can accomplish with a beast mode. I did this with a windowed select statement using a Redshift DataFlow: select "type" ,"number" ,MAX("number") over (partition by "type") as "max" " -- this will add a column with the max "number" value for each "type" from dojo_help order BY "type" ASC I…

Your idea of a virtual filtered dataset is fairly accurate. I think of PDP as more of a redacted file. You get your output dataset, you build your cards with it, and then PDP goes through and "hides" any data that a user does not have access to. You can use a PDP enabled data set as an input dataset for a data flow.…

Sorry, it may be too early to help on Dojo for me this morning. I read your post a little more closely. I think that I would approach this like this: SELECT *, CASE(WHEN `Updated Budget` != 0 THEN `Estimated Budget` ELSE `Updated Budget` END AS `Estimated and Updated Hours`, FROM (SELECT `Estimated Budged`, ifnull(`Updated…

Have you tried this: SELECT ifnull(`Updated Budget`,`Estimated Budget`) as `Estimated and Updated Hours`

@RGranada I have a new wrinkle to add to this problem. I would like to create a card that has one row for each account. Then I want to have a separate column for each of several different products. The trick is that I then want to be able to format the color of the values in each column based on the competitor name. I have…

oops, I think that I missed an extra END on that last SQL statement