MarkSnodgrass Coach

It looks like you are missing a comma in the function syntax. It should be: DATE_SUB(`Year/Month` , INTERVAL 12 MONTH)

@eriena It looks like you want to show the totals for each month for the previous year in addition to all the detail. You can with just a few steps in Magic ETL: Use a group by tile to group your totals by month Add a formula tile and use the DATE_SUB() function to create a new column that would have the previous years…

you might try using SUM to do your counting. For example, you can do something like this: SUM(CASE WHEN `column` >= 1 THEN 1 ELSE 0 END) You will want to change the WHEN statement to what would work in your situation, but this might get the results to display the way you want.

@user027926 To fill in blanks on the pivot table, try going to the chart properties -> general and select "Fill Empty Data Cells With 0"

@AnaKS if you are using Workbench, on the configure tab under additional settings, make sure Allow Schema Changes is selected. I would also suggest you click on the preview icon and then go to the schema tab to see what has been updated. You can also try locking column types on the schema tab to see if that helps.

Agree with @GrantSmith . Here is an example where I use tooltip1 to store the count of a field an incorporate it into the hover text

From the KB Article https://domohelp.domo.com/hc/en-us/articles/360043429573-Table-Chart You can have up to 25,000 rows in a Mega table. If you are viewing your dataset in the data center and export to CSV, you may be able to export up to 1m rows.

@Emma the IFNULL function is also useful for this and does the same thing. COALESCE is useful when you need to evaluate multiple fields before replacing with a single value. Here is what yours would look like with the IFNULL function: IFNULL(`Total Stock`,0)+IFNULL(`Total QTY to be delivered`,0)-IFNULL(`Total fcst…

You need to change the equals to greater than and equal to and less than and equal to like this: (CASE WHEN `Ship_Date` >= CURRENT_DATE() - INTERVAL '4' WEEK AND `Ship_Date` <= CURRENT_DATE() + INTERVAL '4' WEEK THEN 'INCLUDE' ELSE 'EXCLUDE' END)

@Anna Yardley If you could add the ability for a user to change a topic to a question after they posted, that would be extremely useful. So often, people start a topic when they intended to start a question and they don't have the ability to mark an answer as accepted. If you can give them the ability to change their post…

I apologize, I'm having a hard time fully grasping what you are trying to do, but I would suggest a filter tile with a formula rule that looks something like this: `salesstartdate` >= `calstartdate` and `salesenddate` <= `calstartdate` This would filter to where the date from the calendar table is between the sales start…

What are you trying to accomplish when you filter?

Ok. In your case, I would suggest a Left Outer Join and make the calendar the left table. This will give you a row for every day and your sales date will have a value when there is a match. You actually won't need that constant field that I described earlier.

@User2021 did you apply any filtering to the calendar dataset prior to joining with your main dataset? Also, make sure your join criteria only includes the key column. Don't add any other columns to your join criteria.

You can accomplish this with the DATEDIFF() function, which calculates the number of days between two dates. Example: DATEDIFF(`DateA`,`DateB`) To count how many are within 30 you would add a CASE statement around this, like this: CASE WHEN DATEDIFF(`DateA`,`DateB`) <= 30 THEN 1 ELSE 0 END

If you go to the Data Center and then click on your dataset and then go to the History tab, you have the ability to delete different updates by clicking on the wrench on the right side.

You are on the right track using the Domo Calendar. What you need to do is an Add Constant tile after each dataset and create a column such as JoinCol and assign a value of 1 to each. Then join the two datasets on that column, using a left join of the calendar so that you get all the dates. If you are just wanting the…

In your card, how do you have the field formatted? If you are leaving it as default it may be rounding it to the nearest whole number. Make sure you click the pencil icon when hovering over the field and choose Format and Display As Number and choose the appropriate decimal places.

I would use the split_part function in a formula tile. It will look for the comma and split accordingly. Last Name SPLIT_PART(`employeename`, ',' ,1) First Name and anything else SPLIT_PART(`employeename`, ',' , 2)

If you have added the DomoStats Datasets and Dataflows App you should have a dataset called DomoStats - Dataset and Dataflow History. This has row counts for datasets in it.

If you are trying to get the date that is just after the "_ to _" you can use this in the formula tile to get it: DATE(REPLACE(LEFT(split_part(`metricdate`,'_to_',2),10),'_','/')) If you are trying to get the date that is before the " _ to _ " that will be slightly different.

I would delete and recreate to ensure they are created properly.

I was able to recreate your problem now that you describe that you are doing it when using the dataset view option in Analyzer. That view in Analyzer is new, and I believe you found a bug. I would submit a ticket to support@domo.com and explain your bug. They will send it to the engineers to get it fixed. In the meantime,…

Another option would be to create a drill path to a table card rather than to the raw data and do the format option as suggested. This would allow you to keep it as a number in case you need to do any calculations.

When you are in Analyzer and editing the card, click the pencil icon when you hover over the field and choose Format and then choose Display as Number and uncheck the Use Thousands Separator option. This will display your number without any thousand separators.

Yes. If you don't already have the date dimension dataset added to your data center, you can add it by going to the Data Center, click on Connectors, search for Dimension and select the Domo Dimensions connector and then choose calendar.csv from the list of files. You would then add this dataset to your ETL. You will need…

You can do this in the ETL with a combination of the formula tile to get the first day of the month, a group by tile and a rank and window that uses the lag function. Here are screenshots of what I just did to compare counts to the same month of the previous year: The formula tile just has a field to get the first day of…

Ahh... I understand a little better what is going on. In Magic ETL, you will want to use the Group By tile and then choose Add Formula and try pasting the formula into that. If that doesn't work, I would try breaking things out into separate steps where your formula tile creates the individual components without any…

@Pierce13 when you say Available Inventory is returning nothing, is that through the preview tabs when you are creating the ETL? Or is it after you Save & Run the ETL and the ETL fully runs? The preview window can be a little misleading when testing since it doesn't ingest all of your data if you have a large dataset and…

@Rvannoy the reason it is not calculating all of the numbers is because you are using SUM(DISTINCT()). Just use SUM, so it would look like this: SUM(CASE WHEN `CustomerName` LIKE'%VICTUS%' THEN .08 WHEN `CustomerName` LIKE'%WENPHIL%' THEN .15 WHEN `CustomerName` LIKE'%WISYNCO GROUP LIMITED%' THEN .20 WHEN `CustomerName`…