-
Workbench job schedule - details
Hi, I investigated into Domostats, Domo Governance datasets to find if Workbench Job schedule is available. But I see none of them have the workbench schedule(manual, weekly, etc.,). Please suggest where can I find Workbench Job schedule? Thanks
-
Tracking turnaround times Quartiles month on month
Hi, We need to report by month the turnaround time (resolved time - created time) for each Quartile. The top 25% quartile is time for top 25% of the requests when arranged in ascending order of their turnaround time. Similarly top 50% quartile is the median i.e. 50th percentage mark when requests are arranged in ascending…
-
set custom start days of the week at a card-level
Hi All, I want to set custom start days of the week at a card-level, I referred the article(https://dojo.domo.com/discussion/47172/changing-a-day-week-start-to-friday) and created below beast mode. case when DAYOFWEEK(`Start Time (UTC)`) = 1 then 6 -- Sunday when DAYOFWEEK(`Start Time (UTC)`) = 2 then 7 -- Monday when…
-
Prior month metrics beast mode
Hi, I have a pivot table card which displays Last month projects, Projects 2 Months ago, Delta Projects. Below are the Beast mode calculations: Last Month Projects COUNT(DISTINCT CASE WHEN YEAR(`Date`) = YEAR(CURRENT_DATE) AND MONTH(`Date`) = MONTH(CURRENT_DATE)-1 THEN `ProjectNo` END) Projects 2 Months ago COUNT(DISTINCT…
-
Alternative to beast modes
Hi, We have a few beast modes with pretty lengthy list of our clients and we update it frequently, may I know if there is any alternative to a Beast Mode calculation to more easily manage those lists in various datasets. Thanks!
-
Exclude header row and Totals row from dataset
Hi, Is there a way to exclude main header row and Totals row from a dataset? I have connected a SharePoint file to domo, the dataset has main and sub header row, totals row. I want the sub header to be shown as a main header in the dataset when I build the cards. There is Totals row at the end I want to exclude this row as…
-
PDP - Social Users
Hi, We have a PDP enabled dataset and we want to send a scheduled report to our social users, the social users do receive an email but they are not able to view the card with data. Enclosed is the snapshot of the card received via scheduled report. Please advise. Thanks
-
Get unique records from datasets
Hi, I have two reports for last and current month which has size, folder name, date as fields. There are duplicates between last month's report and current month's report. When I combine both the reports, the output dataset should not double up - meaning if there are same folder name from previous month report, it should…
-
Add trend lines based on multiple series
Hi, I am trying to add trend lines based on multiple series and below is the snapshot how I do it in excel. Please advise how can I achieve the same in Domo. Thanks
-
Federated data solution - example
Hi Team, Please help me understand the Federated data feature available in domo, I did go through the article https://knowledge.domo.com/Administer/Other_Administrative_Tools/Using_the_Federated_Data_Solution. But, I would like to know the difference how it is useful to me when compared to workbench, currently I use domo…
-
Beast modes clean up
Hi Team, May I know the best way to clean up the beast mode calculations, the domo governance datasets[Beast Modes, Beast Modes with Fields, Card Fields and Beast Modes] have the details about Beast Mode ID, Beast Mode Name, Beast Mode Formula, Beast Mode Status, Beast Mode Saved to Dataset, Beast Mode Applied to Summary…
-
Number of rows updated
Hi, When I monitor the datasets and look at the history sometimes I see "-" or same number of rows as previous update or increment/decrement in the count if rows for the updated rows. In case, the updated rows is shown as "-", and in workbench the message for the job is "Zero rows returned from Dataset Job execution", how…
-
Deleted a job without exporting
Hi, I deleted a job without exporting, is there a way to recover the deleted job? Thanks
-
Merge two dates
Hi, Is it possible to merge two different date fields into one? I want to merge the Project_startdate and Project_upgradedate as one field. Below is an example: Project_startDate Project_upgradedate Projects 10/14/2020 10/14/202034 10/15/2020 10/20/2020 50 10/16/2020 60 10/17/2020 50 10/18/2020 50 10/19/2020 50 Thanks in…
-
Custom Connector dataset details
Hi, How can I get to know the details of custom connector datasets status (deactivated/activated)? Is there a dataset which shows these details? Thanks
-
Date range filter not working properly
Hi, I have a query on the date range filters in cards. I have a card and filtered date range to show last 12 months by month, and then if I just select the date range ‘this year, by month’, instead of reformatting the card to show those months only(inside the analyzer when I select This year, I am able to see this year…
-
Deleting and recreating jobs in Workbench
Hi, Some of the jobs in workbench were not running on schedule and when I checked the log viewer and it says “Local is past due. Queued for execution”. I went ahead and recreated the same job just to check if they run on schedule and they do as expected. My query is if I delete the old jobs(which weren’t running on…
-
SQL transform - Duration (mins) between two Datetime Columns
Hi, I am trying to get the difference between two Datetime Columns, I went through the below post to achieve the same using Beast mode. But, I want to get the difference in minutes and create a new column based on this condition.…
-
Top 10 with WOW(Week over Week) comparision
Hi, I have a card where I show previous week data by top 10 review projects by timekeeper. Now, want the format to be the same, but want current week bar next to previous week. I am aware that with period over period we need to change the chart type, and have the date on the x axis at least, but then we are not able to…
-
Extra spaces in between layouts on Dashboard
Hello, I have scheduled report for a page, the issue here is there are extra spaces in between layouts on dashboard. Is there a way to adjust the layout and remove the spaces? Thanks!
-
Campaign App functionality
Hello, I am doing a study on Campaigns app, when compared to alerts, may I know how is the app different in functionality? What I understand is Campaigns app and Alerts in domo both has scheduling, metric change alerts etc., is it just the filters that vary in functionality? Any guidance would be greatly appreciated!
-
Jobs are running constantly and ignoring their schedule on workbench
Hi Dojo Community, I have come across this issue were handful of jobs were running constantly and ignoring their schedule on workbench. Restarted the services but that had no effect, ended up changing the scheduler for each job from manual and back to its schedule run time and that worked. That tells me that most likely…
-
Domo Aggregator
Hello Team, I am looking for information on Domo Aggregator. Can anyone please provide the info on Domo Aggregator and few examples? Thanks in advance!
-
Alert when any item is empty compared to previous months
Hi everyone, Is there any way to configure a card alert with comparing a recent value with the previous ones(previous months)? For instance, I need to have alerts triggered when any item compared to previous month is empty in current month. Thanks in advance!
-
Layout types on dashboard
Hello Team, We can have different layout options on dashboard design page which leverages the editor to choose the tiled(single layout with number of cards to be added) or floating layout(no need to choose the number of cards). When the editor is not aware and the card is not added to the same layout and scheduled the…
