-
Domo beastmode and pivot question
Hello, I'm trying to automate a file to run calculation in DOMO on a card. In the attached I added a sample data and a pivot table to show what I'm trying to get to. I was able to get the pivot completed in DOMO, but the additional column Collection Total, I cannot figure out how to create a beast mode for this, I'm trying…
-
Create a summary number as calculation aggregate sum expense minus aggregate sum reimbursements
Hello, I am trying to create a beast mode calculation to show balance remaining after (sum of all expenditure) - (sum of all reimbursements). here is my current calculation. (case when `Expense Type` = 'Expenditure' then sum(`Account Balance`) else 0 end) - (case when `Expense Type` = 'Reimbursement' then sum(`Account…
-
ServiceNow connector and reporting
Has anyone in the community been able to successfully connect and utilize the ServiceNow connector for the purposes of reporting Incidents and Request? I am trying to setup a dashboard to report SNow tickets being opened and resolved on a weekly basis but I am finding thet I am able to report on Created accurately but…
-
Getting beast mode to calculate 10% value of a column
Hello Domo masters, Help Needed. I am trying to build a card that would display projects in a table when the following criteria is met: 1. Approaching budget (Actuals >90% of Budget) 2. Over Budget (Actuals > Budget) I tried the following calculation in testing: Case When `Project Actuals YTD` >= ((`New Budget`+`Rollover…
-
SharePoint Data pull updating the last modified by with account being used for connection
Hi, Is anyone else experiencing this: our documents in SharePoint are showing last modied by the account that we are using for Domo to access the file. Is this supposed to be like this? The user in our instance has not even visited the documents in SharePoint but we have an hourly or daily pull setup using this users…
-
Can a column have both percent and whole number line items and be reflected as is on a table card?
I have yearend groups data that I am trying to combine using Sharepoint Excel spreadsheets. There are columns that has line items for annual target of Percent and others as Numbers. The input data looks alright on the load, but the Table card does not display the whole number values and just is diaplaying the percent as…
-
Connecting Okta - Single Sign on with Domo
Is the API token needed for this connection created from Okta? How do we get this token?
