ST_Superman Domo Employee

I agree with @dthierjung You will need to make some changes to your data structure. Try getting to a more "flat" data set that looks more like this: You can then use a beast mode to calculate the different values you are looking for. Here is the beast mode that I used for Tom - Survey Count: And here is the "Grouped and…

You can use STR_TO_DATE() but you will first need to convert it to a string: STR_TO_DATE( CONCAT(`Period`,'01), '%Y%m%d') You could do this as a beastmode or as part of a select statement in a MySQL data flow

Could you provide more details about how your data is structured and what you are trying to graph?

Ok, If you need to push the date forward two weeks then I believe you are going to need to "flatten" your data set. You currently have a date set the looks like this: Test Cycle Activation DateApproved Test CasesPerformance Payout (Base…

No worries @user18945 can you attach a screenshot of what your dataset looks like. That will help me write the SQL code for the beast mode calculated field 

Try creating a beastmode like this: CASE WHEN `series_field`='red' then DATEADD(`date_field`, INTERVAL 2 WEEK) ELSE `date_field` END

I find it to be best practice to include the file name, location, and date the file was last edited in the description of the data set when using the file upload feature

We are pivoting with a SUMO card to check the contents of the data set. In order to make a SUMO card, I botherly move the screen to some page and create a SUMO card from "Add card". There is a "create visualization" button on the dataset screen, but I do not think it is possible to create a SUMO card.I'd like you to be…

If you are most comfortable with R, you should consider evaluating the scripting tiles. These are a premium service that would allow you to write your r code directly into an etl tile. 

Try something like this: COUNT(DISTINCT CONCAT(`Field 1`,`email_name`)) I can't tell what your field names are, but that should give you the total that you want in the grand total row.

or... via ETL

If you have access to the Dashboard Beta then you can create your dashboard to mimic the screenshot you attached (although I'm not sure how you would get the star metrics accross the top unless you were using HTML from a table card to bring in images). Once you have the dashboard created. You can schedule that as a report…

Are you combining "Page Filters" and "Quick Filters"? These two filters don't always play nicely with each other. If you are using a combination of page and quick filters, make sure that you don't list the same field in both places. (i.e. don't have `Year` be a page filter and a quick filter) Otherwise, I agree that this…

You can set values for quadrant lines in the chart properties of the bubble chart. You could also write a beastmode that would label each quadrant so that the color of the bubbles would match the color of the quadrant from your image. However, I'm not aware of a way to have the background of each quadrant change colors.

I think that a target date would be a great feature request. However, I have accomplished something similar to this by adding more stages (one for Plan and one for actual)

The problem here is the aggregate that you are using. You are counting the distinct number of Product IDs. This count would be the same regardless of a positive or negative value. You should try something like this: case when lte_tbl_return_code.return_reason_description is not Null then -1*…

That does seem Problematic. Where are you wanting to pull the data down to? Would the Domo embed feature be of any use here? Admittedly, I don't do much with APIs so there may be a solution I'm not aware of. However, I believe that only data sets can be accessed via API calls and not individual cards.

I understood your question a little differently than @Valiant did. It seems to me that `# Svc-ShipwiretoIM360integration` is a beastmode calculation. If that is the case, then you actually need to type the whole beastmode again. You cannot reference the beastmode by name in another beastmode. Try changing to something like…

If the number is that small, I would recommend filtering out those values first. Here are the steps you would need to add: First, add a filter before the "String Operation" where we created the LPAD field Second, you need to apply the opposite filter so that you only include the three values that don't need 9 digits: (make…

Correct. Using the PAD function will force all of the fields to have the specified number of characters. Is there another field in your data set that would indicate that the bank_id should not have 9 digits? You could filter those out before using the Pad function and the join the two back together.

Just to confirm, the field that should have the 9 digits will be whatever you choose to name the new column in the settings for that step (in your screenshot `LPAD`)

From looking at your first post, I think you should change the length to 9. From my understanding, you are getting a value of 071000013 but Domo is dropping the leading zero to be just 71000013.

can you share a screen shot of the settings for each step?

 

You can use LPAD() in a data flow. You can use this with text or value fields.

Is it possible that a single email name could be found in multiple categories? When you are using a total row with an aggregate field, the total row simply applies that aggregation to the entire data set. i.e. if your aggregation was MAX(`Revenue`) then the total row would only give you the max value for your entire data…

I don't think you can have the option to change the "Hints" field. I would suggest hiding the hints if it is causing confusion. This would be a good feature request though.

The closest thing that I have come up with to a solution for this is to use a webform. We use this for some financial dashboards because we needed to be able to manually select which month was going to be reported. I simply created a webform with the fields we needed to be able to filter by. Then I use the webform as an…

If you are viewing the failed data set in the Data Center, you should be able to get some more information by clicking on the "History" tab.

I think that this could potentially be accomplished with a custom chart as well. It would depend on your data set, but if you have data coming in that would give you the values that you need, then you should be able to map those values to differend areas of a custom chart https://knowledge.domo.com?cid=custommaps