GrantSmith Coach

Seems like an issue with your CRM system itself in that it can't read information. Are you able to pull the data normally through the CRM UI and is this only an issue when attempting to pull the data via the API / JSON No Code connector?

I was hoping it mirrored the pydomo package but doesn't appear to be the case. What you could do is configure an ETL to do a recursive append every time your rdomo dataset is updated in Domo. Creating a Recursive/Snapshot DataFlow in the New Magic ETL

This is because of using a LEFT join on your dataset. What you're saying is give me all the records in my report table and then give me related information int the master list table if it exists. If you want to get all the data from your master list and supplement it with your report list then you'd need to use a RIGHT…

This is currently how Domo functions. You'd need to share all the pages with the admins (or dynamic group of admins) so they have access to all of the pages.

Have you tried passing in 'APPEND' as the update method parameter in your ds_update function?

In typical Windows fashion - have you tried restarting your workbench server?

You would utilize a Domo Web Form and update your data there and then use an ETL to join it to your original dataset but currently you can't do it within cards.

You'd bring in the dataset that's already in Domo, compare to the records you wish to update and filter out the ones you don't want. You'd only be importing the updated partitions into Domo and Domo would have the existing dataset already on hand The only way Domo can handle removed records is to do a full replace or a…

Have you looked into using a recursive dataflow to "partition" your data and filter out any old records and replace them with new records? https://domohelp.domo.com/hc/en-us/articles/360057087393-Creating-a-Recursive-Snapshot-DataFlow-in-the-New-Magic-ETL If you're using workbench have you looked into partitions?…

Hi @ozarkram What errors are you receiving? Have you use back ticks (`) in your beast mode? Case when `Plant` ='Celes' and dayofweek(`orderdate`) in (2,3,4,5) then '50' when `Plant` ='menes' and dayofweek(`orderdate`) in (2,3,4,5) then '90' end

Hi @shielmunroe, Reach measures how many unique people saw your content. This is calculated on Facebook's end. Whatever granularity you pass to Facebook (Month, Day etc) is what it uses to calculate the uniqueness. So if I happen to view your content twice in a month on two separate days I'd have 2 records of 1 for each…

Hi @thwartted You can't aggregate an aggregate in a normal beast mode. You'd need to utilize an ETL to aggregate your data with a count by whatever grouping you wish and then use that dataset to calculate the average in the beast mode in your card (or alternatively just calculate the average after your count aggregation in…

Hi @RSViju How is your data structured? The filter cards on your dashboard should apply both filters to your dataset.

Hi @ozarkram I'd recommend configuring a date dimension dataset to easier track YOY differences / comparisons. I've done a write up on this topic in the past which you can find here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest You can then utilize a beast mode to…

In workbench you define the upsert key in the job configuration. Are you wanting to enable upsert on a dataset which has duplicate upsert keys already? Each new job would need to have the upsert key defined as each dataset would have different keys.

Create a beast mode and just add your values together: `Field 1` + `Field 2` + `Field 3`

No as Domo would see them as two completely separate servers.

Ah, embeds are unique to the user who created it within Domo so you'd have two separate embed codes since you're using two separate accounts. Not sure why Domo did it that way but that's the current behavior.

Depending on how technical you are you could utilize a Python script and the pydomo package to upload your CSV data straight to Domo. If you have a computer in which you have Workbench installed but don't want to install it on your other computer you could utilize a shared drive which the server with Workbench could read…

Hi @Raymond You can now find the limit rows field under the Filter & Sort section.

Certification only applies to cards and datasets so changing the logic of a dataflow won’t affect anything unless you change the schema of the output dataset that is certified. There is no downstream decertification that occurs if an upstream dataset is decertified. I’d recommend suggesting the downstream certification in…

it seems like it should be the same embed ID if you’re logged in as the same user. I’d reach out to dojo support to see if it’s a bug

You can use a beast mode to add all three values together and plot that as your fourth value

Have you looked into the activity log dataset from DomoStats? That’ll tell you everything that happens in your instance.

I'd recommend looking into the Java CLI Domo offers. It contains a swap-owner command which allows you to change the ownership of alerts, cards, dataflows, datasets, groups, pages and reports. https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool

I just posted something for a similar question but you can use the calendar.csv dataset from the Domo Dimensions connector. Then you can use MySQL to get your desired output (MagicETL doesn't support conditional joins like this directly. You'd have to do a cartesian join [add constant column to both - say a value of 1 -…

@AJ2020 Because of how Domo interprets your data on a row by row basis you'd need to have a record for every day (or month depending on how granular you want to get with your data). You can do this in an ETL. MySQL would logically be simpler because you can do conditional joins but MagicETL may be quicker. To start you…

When you're filtering it's removing records from your dataset and so there's less values causing your percentage to increase. I'd recommend looking into segments to calculate the total across your dataset without having it be affected by filters. You can read more on them here:…

You can use HTML coding in a beast mode to accomplish this. I’ve written about this in the past here: https://dojo.domo.com/discussion/54552/dp22-using-beast-mode-to-build-data-storytelling-links-and-images/p1

I did. Apologies! If you could accept the answer so others can made easily find it out they have the same question I’d appreciate it.