-
Scheduled job fails to run when DOMO dataset is deleted
I've set up a job in DOMO workbench to pull data from SQL Server and upload it to DOMO instance. Below are the details: Job Details Transport Type: MS SQL ODBC Data Provider Reader Type: Database Query DOMO Details Dataset Name: test_schedule Dataset Type: Workbench ODBC I'm just using a normal select * from <table> as…
-
Calculating percentage corresponding to blank cells
Hi all, I want to calculate percentage of the events count in my dataset like below Here, we can say for the month of August, there are 67 events with flag=true. Hence, we can see 100% displayed next to it. Similarly, for the month of September, there are 3 Outcome2 events with flag=true. And the percentage comes out to be…
-
Filling blank cells with 0
Hi Team, I've recently started domo to build reports and I'm trying to fill 0 in below blank cells in one of my reports. The thing is, in my dataset there's no data for August month for the highlighted rows. I believe that's why I see blank in Domo. Till here it's fine. Now, I'm trying to display 0 in these blank cells.…