GrantSmith Coach

Because of the limitations of the PoP when you're filtering the data it removes the historical data you're comparing against. Because of the limitations of PoP I tend to use my own date dimension offset with my own defined periods. You can read more about it here:

Your logic is a bit different between the two On your card filter you are checking for the explicit value of AAA but in your ETL you’re checking Contains AAA so if there are other records, which are not explicitly AAA it will be included in the card BAAA works be included in the card but not your ETL. You need to either…

I'd recommend reviewing as it outlines how to deploy custom apps

You won't be able to change the owner but you can add another user as an Admin on the asset if you go under Admin > Asset Library and select the app you have published to your instance. You can also download the code used to build the app by using the wrench icon in the upper right and selecting "Download Assets". You can…

Depending on your technical skills I'd look into utilizing Python to write a script to extract and upload all of the files into Domo. They provide a pydomo package.

batch_id and batch_last_run get added automatically. Before you do what I assume to be a pivot, drop those two columns with an alter column tile.

try putting g your case inside your SUM statement: sum(case when DATEDIFF(`Select Columns.Date`,`Date`) >0 then `Select Columns.Totaalprijs` ELSE 0 END) /COUNT(DISTINCT Email) You're evaluating each row one at a time with the case statement outside of your aggregation which is why you're getting multiple records.

The cleanest option would be to set up child instances for each client to have complete separation between the users lists and data.

Thanks @DanHendriksen - good to know!

Domo provides an R package you can leverage to extract data from Domo using R: It outlines how to connect within the README

Are you currently utilizing the "Line + Grouped and stacked" chart? You'll also need to make sure you have your projections included in your dataset as well. You can leverage a Metric field with the type of metric which would have "Prior Year", "Current Year" or "Projected" as the values and use that as your category. Are…

Use IN instead of = SUM(CASE WHEN Product Code Number IN ('10','11','12','13','14','15','16','20','21','30','40','50','60','61','70') THEN Quantity ELSE 0) - SUM(CASE WHEN Product Code Number = '83' AND Unit = 'SF' THEN Quantity ELSE 0) / SUM(CASE WHEN Product Code Number IN…

@HowDoIDomo - Domo's Google Ads connector works for me now and I've had success utilizing it.

You should be able to use your code function to extract the email address out of the JSON with some javascript and then send your email.

Are you able to monitor the network traffic in an effort to sniff which APIs it might be calling and then use those APIs? The cleanest option you have with your excel file would be the ctrl+v paste option into a local excel file that you upload then you can use Magic ETL to convert the data types and clean the data.

How isn't the color rule working properly? How are you calculating the Average - is that stored in a separate column?

Try and pass the attributes in the correct format: "attributes": [ {"key": "customTestAttribute", "values": ["test value"]} ] You may need to save a user manually and monitor the network traffic to make sure you're using the correct field ID as it won't always be what's displayed.

Alternatively, you can create your own custom connector using the connector framework if you want to get more technical:

There isn't a native Microsoft Sentinel connector however Domo does provide a JSON No Code OAuth connector you can attempt to utilize and point to specific URLs I'd recommend looking into. https://[INSTANCE].domo.com/appstore/connectors/com.domo.connector.json.customparsing.oauth

Does your data have July-Sept in the Current YTD YTD_Period field? Are you using Domo's Fiscal calendar?

What API are you attempting to connect to? Do you have the appropriate APIs enabled in your Google Console?

Are you wanting to view the code and make changes to it or are you just looking for the URL to deploy it again? If you need to make code changes you need to unpublish it and then make changes and re-publish your connector.

Because the AppStudio is sandboxed you won't be able to use a button to bring up the print dialog box. You can log an idea in the idea exchange to allow that functionality.

There isn't an option to increase or decrease the ratio between the bars and the data table. You could leverage two separate cards (bars only and table only) to enable you to resize them to the desired ratio.

If you add the account back with the same email address it should restore the user's account with the same ID and metadata.

Domo won't track your current filters automatically across the different dashboards. I'd recommend adding this to the idea exchange.

Domo has a good KB article on setting up partitioning in Workbench you can follow here: . It's for 5.1 but should be the same for 5.2

Currently, this isn't an option; however, you could leverage a custom app to set the background yourself.

You could configure the card interaction in the dashboard to go to another card where it wouldn’t apply the drill path filters. Are there some filters you need to keep?

you can possibly leverage the activity log dataset to count the view events