Godzilla Contributor

In Edit mode, change the 'Graph By' field in the time grain to 'None'. Once you do that, it will allow you to change the Date Range field. 

You can remove the time grain on the top of the card by going into edit mode and making sure the Date Range field does not have a field selected. If it does, change it to 'Select a date column'. As far as preventing the users from using the filter option(the funnel icon), I don't think there's any way you can turn off the…

you can run the job more frequently (maybe every 2 or 4 hours) so the total new leads do not go over 2000 and just append them to your dataset. 

Firewall might be blocking the ports. You may have to open the ports in your firewall. 

Add your first metric as the Y axis field in the builder and the other four metrics under the 'Series'. Make sure the aggregation for each field is set to Sum or Count. 

it might be due to the results of the first 2 statements are returning a string but the Count distinct returns a numeric value. I believe all the results have to be the same data type in a case statement. 

i believe the limit is not on number of rows but on how much data they can show. That being said, if you eliminate unnecessary columns, i think you can get more rows to show but if your dataset is more than couple of thousand records, i think you'll still have an issue. 

try this STR_TO_DATE(CONCAT(month(`Date`) , '/1/' , year(`Date`)),'%m,%d,%Y')

Sounds like the date value you are uising is not a Date data type. You have couple of options: * You may want to consider fixing that through your data load process. * Create a Beast Mode calc using a CASE function to map Jan-Dec text values to a numeric sortable value, and drop that into the Sort criteria. * Try…

make sure the date field your using is loaded as a date or datetime data type. Also, i would sort the chart by the date field to make sure it stays in order. 

not in a regular table card. 

I don't think you can do exactly what you have with the out of the box chart types in Domo. However, another way i would do this is by showing the totals as the top level chart and then build drill through charts to allow the users to drill in and see the monly breakout. Or, if you're showing YTD, you can train…

I was going to recommend using workbench instead as it's lot easier to get going. The connector will require you to open some firewall ports to access the DB. With workbench, you can connect to any db using odbc connection. The only downside with workbench is if you need to schedule jobs, you'll need to install it on a…

Yes they have a MS SQL Server connector. 

Also try the following. it should work if your months are always 2 characters (01,02, 10,12, etc.) SUBSTRING(`FiscalYearWeek`,7,2)*1

can you provide a screenshot of what you're getting?

you can convert the string to a numeric value by multiplying it by 1. so try RIGHT(`FiscalYearWeek`,2)*1 for me, the RIGHT function is not working i think because it's a new function that may not be rolled out on my instance.

they recently had a release so may have broken something in that release. 

you can use Magic ETL to join the two datasets (using an outer join). After you join the datasets, you can add a data filter and set the unique identifier from spreadsheet A to 'is null'.

try deleting few of the blank columns at the end of your file just incase it's trying to load those. 

make sure you don't have duplicate or blank column names.

In order to do this, you'll have to have the $ and the % as separate fields in your datasets(cant create beast mode fields in Sumo). Once you have all that in your dataset, you can create the Sumo table and set it to Pivot view. Add your $ and % columns as the value fields and then click on the column headers in the pivot…

Sumo table would be your best solution. 

DATE_FORMAT(`DateFIeld`, '%m, %d, %y')

make sure in the 'Date Range' drop down in Edit mode, you have the right date field selected. The time grain on top uses the field you have assigned here to change the views as you change the time grain selection.

you can use a beast mode field to calculate the ratio where you would only include records where the Opportunity date is between certain dates. in your calculation you would have a case statement to check for the dates. assuming you're loading the opportunity records with a Date and OppertunityStatus fields, you can do…

You have couple of options 1. DomoBuzz - you can add commentary to DomoBuzz from the detail page of the chart so Domo links your comments to a specific card. 2. Card Description - you can add commentary to the card description in Edit mode. Users would have to hover over the Title of the card to see the comments so it's…

if you have the lead activation date and the age fields in your dataset, you might be able to do this in a Sumo card since it has the pivot capability. You might be able to do the conversion rate calc as a beast mode if you have something in the dataset identifying which are converted leads.

Yes, you can write an update statement to update your SQL database. However, you can't reference Domo to do your update, meaning you can query against the Domo db to update your sql db.

you're right, i don't see the option to send as Email for table charts.