GrantSmith 🥷

Add a constant to your dataset and call it grouping column and set it to 1. Then feed that into a group by tile and group based on the grouping column. Select the MAX of the _BATCH_LAST_RUN_ field. Then use an inner join to group that result back to the original dataset where the two dates match.

What does your query and python code look like? It's easier to help debug if we have an example.

Interesting workaround. Thanks for sharing!

I’d log a ticket with Domo support to look into their connector as it should be expecting json and not xml

You’ll need to probably start over as it’s expecting cards that no longer exist

This sounds like an internal platform issue. I’d recommend logging a ticket with support for them to look into the issue on their end

You can utilize a beast mode and subtract the two: COUNT(CASE WHEN `Type` = 'List' THEN `Date` END) - COUNT(CASE WHEN `Type` = 'Completed' THEN `Date` END) Then also have a beast mode for the completed count: COUNT(CASE WHEN `Type` = 'Completed' THEN `Date` END) Use these two beast modes in your pie chart instead.

Hi @Puja_Tayade Domo Knowledge Base has some good articles on creating alerts for datasets and cards: DataSet Alerts: https://domo-support.domo.com/s/article/360042925994?language=en_US Card Alerts: https://domo-support.domo.com/s/article/360043430513?language=en_US

Hi @Natalia , This currently isn't an option but I'd suggest adding it to the Ideas exchange for a potential future enhancement.

According to their documentation Net Sales is Gross - Discounts - Returns + Taxes + Shipping so you should be able to back into Gross sales with: Gross = total_price + total_discounts + returns - total_tax - total_shipping_price_set_presentment_money_amount Refunds/Returns isn't included in the All Orders report in the…

Have you tried updating the dataset's schema before you upload the new dataset? https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py#L32

Currently this isn't possible within the pivot table. You'd have to do this within an ETL to process your data.

It should allow multiple columns with a comma. Is your code using back ticks ` or actual forward ticks´ and it's just a copy and paste issue? The documentation clearly outlines multiple columns are allowed: https://domo-support.domo.com/s/article/4408174643607?language=en_US

This will be much simpler to do within an ETL than attempting to do it within a beast mode. I'd recommend using a rand and window tile in Magic partitioned on the customer, sorted by the order time and calculate a Dense Rank to determine the order number / count for each specific user. You can also partition on the…

I'd recommend reformatting / pivoting your data into a structure such that you have a date and the type of date that it is. Respondent, Type, Date Respondent 1, List, 12/31/2022 Respondent 1, Complete, 1/3/2023 Respondent 2, List, 1/1/20223 Respondent 3, List, 1/2/2023 Respondent 3, Complete, 1/4/2023 Then do your grouping…

Do you want this to be affected by filtering the transaction type or is this to be across all transaction types?

this isn’t an option with the standard chart options. You can utilize a DDX brick and the Phoenix engine and some CSS to display the table without a border

Have you looked into using pfilters? https://domo-support.domo.com/s/article/4418999855639?language=en_US

Do you have any beast modes with window functions or aggregations? Any sorting being done on fields which aren’t being displayed in the chart?

What does your date range look like? Is it always the current month or is this changeable by the end user to display other months?

Think of a filter tile as trying to selected the rows that match a certain criteria. If you're using a filter formula you can invert the logic. So if you know the logic you want to remove add a NOT in front of everything encapsulated in parenthesis. NOT (`column 1` IS NOT NULL AND `column 2` IS NULL) If you take the…

In Analyzer you can select an aggregation for your Total field and select Sum, this will group all your other columns togethers.

What commands have you run to setup your app? Have you run domo init ?

You'd need to utilize a scripting language like Python and the Domo and Sharepoint SDKs to programmatically query your folder, pull and parse the data and then ingest it into your Domo instance. There isn't a tutorial on how to do this specific use case but you could reference the documentation for each of the different…

Right now no, this isn't possible because it can't store multiple values into a single variable. You can post this idea to the idea exchange to see if they can add it but might be difficult from a technical limitation standpoint.

Currently this isn't possible with the direct Share point connector. You'd need to script this yourself to automatically ingest all of the files.

You need to reverse the order of your SUM checks because if the sum is more than 111 it's already more than 35 so it will return Tier 2 first and quit as it executes the first case that matches. Check for Tier 4 then 3 then 2 then 1. Also with your tier 3 check you only need to check for 71 because by logic all prior when…

If you remove the Location and Location Number fields from your table and then in the column fields for your orders, line counts, quantity and sales amounts you can select SUM as the aggregation method. This will add all of the different locations together for each of your metrics.

Hi @[email protected]_Jolly This currently isn't an option to restrict individual filters on a card based on who is viewing it. You could post this to the Ideas Exchange as potential feature that others could vote on.

DATE_FORMAT function if your friend in this case. You can format the date as a specific string format. You can find more information on the codes used here: https://www.w3schools.com/sql/func_mysql_date_format.asp DATE_FORMAT(`Date`, '%Y-%m-%d %H:%i:%s')