Best Of
Re: Instance Hygiene
Cards aren't considered "viewed" by the DomoStats unless the detail view is looked at. When looking at a card on a page it doesn't count that as a card view. As @MichelleH mentioned you can utilize the Domo Governance or Domo Stats connectors for pull the last viewed information for pages and join each card on that page together to get the page last viewed and the card last viewed. Selecting the greatest of these will get you when the card was last viewed.
One caveat is that you may want to ignore page or card views done by Major Domos. You could utilize the Activity Log to see when cards or pages are actually being viewed and can filter out specific users.
Re: Month Over Month % Change of Total Number
@hunter_brown Are there any null values in the credits and debits columns? If one of them is null and the other is not then subtracting will return null, so you may need to replace the nulls with zeros in each individual column.
Re: Help Pivoting Data
@user14170 I don't know of a shortcut for naming the columns off hand. Do the pivoted columns need to be coded into the dataflow or are you able to use a pivot table card? If you have a large amount of charge codes you need to pivot, then having them listed as individual rows may give you more flexibility downstream.
Re: Help Pivoting Data
You can't do a dynamic pivot with Magic ETL however you can leverage prepared statements and SQL in a MySQL dataflow to do dynamic pivoting. You can follow the SQL with something like
Re: Help with a complex calculation that isn't working in Beast Mode.
@Trumpetbob What do your calculation and result look like when you try to combine all 5 lead types? When you say it doesn't work, is it returning an error or an incorrect result?
Re: Instance Hygiene
@soozalooz You can use the Domo Governance Cards and Pages dataset to join page views to the cards within a dataflow. Then group by Card ID to to find the maximum of Last View directly on the card or on an associated page.
Re: What does the CONTAINS operand do in pfilters?
Actually, no that's wrong. There's already an IN in pfilters. I'm not sure how contains functions.
Re: How can I add to a dataset previously created using the DOMO Python SDK?
Are you using ds_update? That allows you to update an existing dataset.
- Data sets - This set of functions is designed to transfer data in and out of Domo.
- ds_get - downloads data from Domo
- ds_create - creates a new data set
- ds_update - updates an existing data set, only data sets created by the API can be updated
- ds_meta - downloads meta data regarding a single data set
- ds_list - downloads a list of data sets in your Domo instance
- ds_delete - deletes a data set (be careful)
- ds_query - allows you to send a query to a data set, Domo will evaluate that query and sends the results back as a list or a tibble