ColemenWilson Coach

Could you provide a bit more information? This is possible, and I have done this - but I want to better understand the type of content you have on your dashboard and how you plan to compare one year vs another visually. The approach I took was to build a dataflow that had comparison data self-joined to the data and then…

You can use the Domostats report called "Scheduled Report Recipients" to see who is receiving scheduled reports.

Hmm the only time that should happen is if, for example, the current time is 3:49 but there is no quote in your data with 49 as the number value. Could you screenshot your beastmode formula? It is still working for me so I am not sure what is going on.

Yep, you would do what @DavidChurchman said and set each of those 3 conditions as conditions in the filter with "Include rows that meet ALL of the following rules" set.

Can you search for the rows that don't match the current format in a dynamic way? If so you could just apply a filter tile to the ETL to remove the rows that don't match. How do you identify the bad rows?

Could you provide a bit more information as to what you are trying to do?

You could create a slideshow of quotes: Or you could do this: create a data table with 2 columns: Quotes, numbers 1-59. Use this case statement as a filter on the card with "In" selected: MAX(CASE WHEN Number = MINUTE(CURRENT_TIME()) THEN 'In' ELSE 'Out' END) Make the card a text card The card will display a new quote…

Are those two columns mutually exclusive? Is it ever the case that both columns will have values in the same row? If not, then you can use: IFNULL(`Maintenance`,`Disruption`) If there are cases where both columns could have a value on the same row, then I would suggest appending your data in ETL so that both columns are…

Can you use 2 criteria for your remove duplicates tile: 'Site Address' and 'Panel'? If not, you can use the Rank & Window tile and choose 'Latest Update' as the order and set 'Site Address' as the partition - here again you can use multiple fields if needed. Next use a filter tile to only keep rows with the rank value you…

Agreed on DATEDIFF(). Also, adding a *1 to a field will force it to a number: Field*1 or (CASE WHEN Field = 'Cat' THEN ID END)*1

@MarkSnodgrass THANK YOU! So helpful!

You can double click on the beast mode in the fields pane in the beast mode editor and it will populate in your beastmode - that way you don't have to re-write the logic again:

In addition to the above, you could also create a recursive dataflow using the DataSet Schemas Domo Governance dataset and see changes to schema for ALL datasets in your instance over time.

If you post this in the ideas exchange, other community members will have the ability to upvote the idea. The more upvotes it gets, the greater the chance it has of becoming a new feature.

Have you looked at the Split Column tile in Magic ETL?

@GrantStowell @AnnaYardley Could you loop in a technical resource from Domo to answer this?

Got it. So I believe it is the ELSE 0 part of your case statement that is causing there to be a 1 where you expect a 0. Because it will count either the ID's if flag =1 or it will count the 0. Either way you will get a 1. I think you're on the right track removing duplicates in ETL - especially if the only function of your…

Can you help us understand why the 3rd column is needed? It seems repetitive having the flag column and the Distinct count of ID (if Flag=1) column. Every row in the table card will have a single ID and the flag column is already populated so all you'd really need to do is use the flag column. The distinct count of ID…

Hmm just a guess but maybe try: CASE WHEN TRIM(LOWER(`Current Log`)) = 'true' AND TRIM(LOWER(`Website Status`)) = 'published' THEN `Log Completed Date` END

You can see activity of the API clients in the activity log. There is a field called `Client_ID`.

MORE > Admin > API Clients

You can filter out any value from being included in the pivot table that has a zero value like this:

Hi Tejal, Do you mean the lineage of a dataset within Domo? Or knowing the database/table external to Domo? If within Domo, you can see this in the lineage tab of the dataset or in the Domostats report: DataFlow Input DataSources

Make sure you have Aggregation set to Sum for the minutes_new field: Your screenshot cuts off but if any unique values show in the table other than date it won't aggregate by date. Also check the sorting section in analyzer. If there is a sort enabled there with a field that is a timestamp for example then it won't…

Yes filtered views is the way to create the default filtered views with the flexibility to add additional filters if needed. This is a great article that explains filter views: You can arrange dashboard/sub-dashboard order for all users in the company managed dashboards section of the dashboard pane: More > Admin > Company…

Hi Ajita, could you provide a bit more information? You can create personalized views of a dashboard using PDP and/or Filter Views. What do you mean by arranging the dashboard for all users? Do you mean its location on the dashboard page? Having the cards laid out or arranged differently for different users?

@TWill we have thought of using forwarding rules and setting up custom email addresses that just forward the content along to the Domo email address.

In a table card: Add the date field Add the downtime in minutes field Change the aggregation for the downtime in minutes field to SUM as shown below:

You can either use subtotals and totals on your table or remove the unique fields from the table and aggregate by Date by summing Downtime in Minutes. If you add unique fields the table expands (unaggregates) to show the unique values. So for the 14th of May, you have the start and end time fields, the Ticket ID, etc.. to…

どういたしまして、管理者権限が必要であるという点は正しいです。また、ガバナンス データセットの場合は、アクセス トークンを生成する必要があります。