ST_Superman Domo Employee

Here is an example: case when `Profit`<0 then CONCAT('<div style="text-align:center"><img alt="DOWN" height="20px" src="http://www.clipartkid.com/images/27/download-public-domain-ihtHTQ-clipart.png">','</div>') else CONCAT('<div style="text-align:center"><img alt="UP" height="20px"…

Have you saved the ETL and then do a full run and there is still no data? I have run into an issue where the preview table (as I'm building the data flow) does not have any output, but when I save and run the join works correctly. If that doesn't resolve your issue, could you provide some screenshots of the data flow so we…

I'm not sure if there is a Domo connector or dataset already set up to do this. However, we use Salesforce. We want to keep a constant exchange rate for the entire calendar year, so we simply input the data into Salesforce at the start of the year and then extract our conversion rates into Domo. I suppose for this purpose…

I would just caution that you will need to update this beastmode any time that you want current conversion rates. If you take a similar approach from inside a SQL data flow, you could connect it to a datasource that provides updated conversion rates. You would just need to pull out the currency codes. SELECT * ,CASE WHEN…

If you prefer to not use the MySQL redshift transform for this, I would recommend trying out the new "Rank and Window" tile available in the Magic ETLs now. Knowledge Base Article for Rank and Window action

Drill paths are still considered to be a part of the same card. So applying a rule to the card will apply it to all of the drill through views within that card as well. One alternative would be to create a beast mode for the fields that you want the rules applied to. For example, if you wanted color rules for profit you…

Depending on what you want your scale markers to be, you can create a manual range (with an upper and lower value) or create quantile lines. Select Range Input a manual value or Avg, etc. You can change the fill color You can have up to 10 quantiles

Nicely done @RGranada One change that I would make, although it would not impact this card at all, is that MAX(i4w_date) should be "Last_Login_Date" and the MIN(i4w_date) should be "First_Login_Date". Also, if you group it by i4w_userid; then the last part of your select statement would just return 1's so I'm not sure that…

No, that makes perfect sense. If he wanted to graph the average check by week or month, or to be able to select the level of granularity, he would just keep the date field without the beastmode. The downside there is that when you are looking at the day view, he would also see any empty days in the x axis. Thanks for the…

I believe that the color rules are currently either applied to an entire data set, or to a specific card. However, when you apply the rules to a card, you also apply them to all of the drill through views of that card. If you are using a table, you could use html code to create a format for a single cell: case when `Field…

@RGranada Just so I understand, what is gained by concating the date field like that?

you can create a beastmode to concat the different values that you want to include. Then you would want to select that beastmode as your summary number. This does cause some issues when exporting the cards in different ways, so make sure that you test it out. concat("calculated value",' text ',"calculated value 2", ' text…

This depends on what kind of card you are using. You can use html coding in a table card. This means you can use a case statement to bring in an image based on data values. case when `Profit`<0 then CONCAT('<div style="text-align:center"><img alt="DOWN" height="20px"…

The biggest difference when drilling into a table versus a heat map is that drilling into a table will only apply one filter. Drilling into a heat map typically applies two filters.

Link: https://dojo.domo.com/t5/Ideas-Exchange/Display-quot-empty-quot-Date-values/idi-p/27318#M5634

Does this mean that I would need to have at least one row of data for each month, for each year, for every combination of customers and products? We have thousands of products, so this would involve adding a lot of data to our datasets. I was hoping this could be a default feature of any graph that used a date field on an…

Steve Cook at Domo was able to help me solve this issue. It turns out that when you using a drill path on a card, all of the color rules for all of the data sets in that path need to be "applied". In my case, the first data set had 48 rules and the second data set had a few as well, so I was not able to save the card due…

I think the issue that I am having is because I am changing data sets in the drill path. The odd thing is that I have a version of this card working in my Domo instance and when I try to edit the card that is working, I get the same error message. Is anyone else having issues when changing data sets in the drill path?

I do not have a beast mode, but I do have a regular Date field on the x-axis. The field is Date of Invoice and I am trying to graph it by month. Do you think that could be the issue?

I'm still receiving this error message. I looked through my Chrome extensions but did not see any ad-blockers 

that's great @kbota. Any chance you could share here?

Are you using Workbench? the Excel plug in? or the "Connect Data" File option from inside Domo?

The previous solution was for a scenario where there was only one store. You would need to use the amazon redshift data flow option so that you could set up a windowed function. You could also possibly accomplish this via a magic ETL now, but I have not used the windowed function there much yet. Let me play with it a bit…

This does not seem to prevent drilling into the data, it just makes the drill path return an empty set if you drill into the "wrong" field.

Here is the Heat Map I described earlier. When you click on a value, it applies two filters to the drill through path (Name and Month)

This seems like a good topic to add to the Ideas section. It would be nice to apply some dynamic rules to the color rules. Right now, when you add color rules to a table, it will give you the Min, Avg, and Max values. It would be nice to apply the rules to the Max value. Instead, I think the work around here is to just…

I have had this feedback from users as well. The issue is that you are using a Table card I am guessing. If you were to use a Heat Map, you could use Name as the y-Axis, Month as the x-Axis and Credits for the value. Then, when you drill into the data, you would be clicking on the intersection of two fields: Name and…

Hi JSuggs- You can accomplish this with a Line + Grouped Bar card. Under the General Chart Properties tab, you will want to specify 2 series on the Left Scale: You will then want to graph `date` on the x axis, and your two beastmodes as the next two fields (Click Rate and Complaint Rate) One note here is that you will need…

You need to check the box at the bottom of the page filter: As long as your sorting columns have the same field name, it should apply to all of the cards.

To my knowledge, this feature is not available yet. You should add it to the Ideas section and you may see it in a future release.