Jaketh13 Contributor

@Godzilla I don't know what your column names and values are, but I've done it with all kinds of crazy stuff in my own cards. Here's an example of one I've done in a card on my instance: CONCAT('My Closed Cases this Week: ', SUM(CASE WHEN `Owner.Name`='Jake Harris' THEN 1 END),' / ', ' Agent Avg: ',…

@user07065 You should be able to put any of your calculated fields in the Summary Number. One thing to note is that they don't display with the "=" before the name when you're looking for them in the Summarry Number "Field & Function" dropdown. If you are still not seeing it in there, send a screenshot of the name of the…

@mkozai nearly all of the other filters you put on a card from the Data Table will be evident. If you filter a row, it will appear in your filters, if you do a sum, it will show that it's being summed in the preview. I definitely think you're right about the row limit though. That's something that would be worth indicating…

@DataSquirrel I don't know that there's a list currently of which chart types have automatically calculated mins, maxs, and avgs, but they're generally meant to be available only on charts where it makes sense. For example, a running total bar graph wouldn't make sense with max/min/avg (max is always last, min is always…

Depending on how all of your raw data looks and how you want the chart to look, the simplest solution might be to use the PoP charts offered. If that doesn't work for you, then you will need to create period totals for any agregations that you want to compare in a separate column. For example, if you wanted to compare…

@AL-where Not sure about exactly how to set up your custom connector, but if you're able to get the file deposited in an SFTP server, you could use the CSV-SFTP Connector to pull the file into Domo.

@user02741 do you have a sample file I could look at (one that doesn't have sensitive data)? The only times I've gotten a successfull PUT request with 0 rows and 0 bytes was when I was uploading a test file that didn't have any actual data.

If you are looking at the preview in a DataSet, it will usually display any columns with the "Date" data type in the MM/DD/YYYY format, but in order to be a "Date" data type, the underlying data must be in YYYY-MM-DD. Any other month/day/year format has to be Text. If you wanted it to stay in a specific format, the easiest…