ST_Superman Domo Employee

You need to make sure that the entire path to the API is correct. Would you mind sharing your query and maybe a portion of the schema map for the salesforce object you are pulling in, highlighting the api in question? Thanks,

I would think that it is incredibly disorienting to see a graph with bars and multiple lines, all on different axis. I think that best practice would be to at least keep all of the same element types on the same axis (lines on one axis, bars on the other). I would recommend evaluating the question you are trying to answer…

If you know the fields and the values that people are requesting to save the filters as, there is a sort of work around by using a table card with html coding to pass filters on to a new page. Basically, you need to have a separate column for each field you want to filter, and a row for each combination of values. You can…

I did get an email this morning about a product update rolling out next week (4/16). May be different for different instances.

I'm not sure of a way to do this via a filter. I have solved a similar problem by building two subpages. One with USD and the other with the same metrics in local currency. Is there a need for the same user to switch back and forth? Or would most users just want to see one currency. If most users are only interested in…

You can do this through ETL or MySQL Here is a screenshot of my ETL. If you need more help setting it up let me know and I can provide more detail tomorrow. If you prefer MySQL, I can work through that code as well. Let me know your preference.

I created a data set with two fields for this; `route date` (date field) and `Lifts` (integer) I then created a few beastmodes to engineer a few more fields: -Route Month: This allows me to see the month name in the flex table card MONTHNAME(`route date`) -Route Year: This is for the series on my running total graph (I…

https://www.domo.com/integration-cloud There is an extra charge for the integration cloud, but that would give you some of the write-back functionality that you are looking for. However, I believe that the current build of the Salesforce writeback connector will only allow you to write to standard fields or "net new"…

There is a Domo Stats data set that you can access via the cloud apps. I am currently using the Domo Stats - Data Sets connector to show me the "age" of my key data sets in my instance. You can probably use the page or cards data set to accomplish what you are looking for.

I'm not sure why we are so hyper focused on getting the summary number to do such heavy lifting here. I think that we could leverage stories to bring together a flex table and a running total graph to look something like this: Would this meet your needs? If so I can try to walk through how to build it

Sorry... Sum(case when year(`route date`) = year(current_date()) - 1 and month(current_date()) = month(`route date`) then `Lifts` ELSE 0 END)

Try this Sum(case when year(`route date`) = year(current_date()) - 1 and month(current_date()) = month(`route date`) then SUM(`Lifts`) ELSE 0 END)

OK... I have a solution for you, but I have to do this in a MySQL dataflow. You will need to use your emailed data set as the input for the dataflow. In my case, I just created a very simple dataset with only two columns, but it should function the same way regardless of how many columns you have. Here is my sample data…

This would be easier to explain if I could see some of the data behind the calculations. Can you add a total row under the chart properties? Then add the total open and total click fields to the table. That should show you how the summary number is getting it's value

I think I should back up and explain what your original beastmode was doing when you used it as a summary number. It was adding up all of clicks (for every campaign) and dividing that by the total opens (for every campaign). This would mean that you are not getting a sum of each campaigns individual CTO, but rather an…

If you want to sum the individual CTO's for each campaign, I would recommend a different beastmode. try creating a CTO Summary field sum((`total_click` / `total_open`))

Do the files come from two different sources? Or is it completely random which of the two date columns will be used? Unfortunately, I don't believe that this can be solved outside of an ETL. I would suggest that the easiest fix would actually be to pick a standard format for receiving the file. Perhaps you can have the…

In this case, you are using a calculated field to display your summary number. The aggregation is then happening withing that calculated field statement. Presumably CTR / Open Rate which are also two calculated fields. Would you mind sharing the code for the CTO beastmode along with what your desired summary calculation…

I'm not sure how the same data set can change field names depending on the row of data. Would you mind sharing a screenshot or excel sample of your data set? That should help me find a solution

I just created a data set and tried this out. It worked for me. Let me know if I'm setting this up incorrectly: The "Combined Date" calculated field is: IFNULL(`Source Date (America / Chicago)`,`Source Date (America / New York)`)

create a Calculated Field: ifnull(`Source Date (America / New York)`,`Source Date (America / Chicago)`)

Can you share a screenshot of the Card Analyzer? Would be helpful to see how you have the card built

This has to be a bug. I am having the same issue that @BruceP is having with the order by clause. Have you submitted a ticket yet?

You can use regex expressions in the ETL replace text tile. I don't think there is an option to use regex in MySQL

I like the Color Rules addition. Looks great

Just change the count to be count(distinct) instead

You will need to make sure that you are sorting your table card with the same values that you include in the order by clause of this beastmode:

In your image, you have rank 3 listed twice. Was that a typo, or is there something more to the rank calculation than just row number?

The table, as built in this article is actually using HTML code to embed images of the Sales "bar code" I would encourage you to try building this table using the new Flex Table Card.

@cwolman - you didn't do anything wrong. The interactive filters do not work on mobile.