-
Looking to use Regex in Value Mapper
We have a column with the following example string: holiday home insurance_E We need to search for any string with the _E at the end and update a Match Type column using Value Mapper with 'Exact' We have tried using RegEx ^[\w|\s]+_E$ which correctly identifies the string but the value mapper is not updating the column or…
-
How do I change the bar chart color to a custom RGB or HEX code?
I am trying to change the bar chart color to a custom RGB or HEX code that adheres to our corporate brand guidelines. It looks like there are only 48 colors to choose from in the domo color rainbow. Please let me know if there is a way to do this.
-
Can I change the legend labels in a YoY chart?
Can I change the legend labels to something besides "Last 12 months" and "12 months ago"? I'd like it to be something more user-friendly like "April 2017 - March 2018" and "April 2016 - March 2017". Thanks in advance!
-
Group months into Year range
HI there is have x axis as months which i would like to categorise as 0-12Mnths, 13-24Mnths etc in the xaxis. Is there a beast mode to do this? I already have a beast mode calculation to compbine two columns to get the months (`Year` * 12) + `Month`, however i would now like the x-axis to be grouped as above. Any…
-
Has anyone connected MYOB (Version AccountRight 2017.2) to Domo?
We are trying to connect our finance system - MYOB version is AccountRight 2017.2 to Domo. There is no connector as such - any ideas?
-
Two Tables Side-By-Side?
Hi, Hopefully this is the right place to ask this question. When I'm looking at a card's visualization it would be helpful for me if I could see the underlying data powering the card. I don't mean just hitting the table button in the top right corner either. Ideally, I would like to see the visualization on top and then…
-
Beastmode syntax for the following condition help
I am trying to do calculate a rate called Coverage Rate Columns are Coverage and Dollar Amount Values in Coverage column are either "Covered" or "Not Covered". I want to know the total dollars for WHERE Coverage = Covered that is easy, but if i wan to devide those total dollars where coverage = covered by total dollars,…
-
I need to integrate with Shopify for my data but I do not have "access" to do so.
I get the following error Oauth error invalid_request: You do not have permission to access the requested scopes
-
Error Viewing Scheduled Report
We have several scheduled reports that are sent out to users. When a user clicks the link in the email to view the card, it opens a new window in our Domo instance, but they get an error message every time. I've attached a screenshot of the error. The card will show up just fine if they click "CLOSE REPORT" in the upper…
-
How to set filter with scheduled reporting
I have a master domo card that has information pertaining to every single employee. I want to set up an automated schedule report that gets sent to each employee on a daily basis. How do I set the scheduled report so that when an employee receive it the filter is already applied? I do not want to create a seperate card for…
-
How to create a YoY Aging report
Hello, Our company is looking to create a comparison of our A/R aging this year to last. As of now, we have the following beast mode to show this year, current. Is there a way to get another column in the report for comparison to last year? (CASE WHEN (DATEDIFF(CURRENT_DATE(),`Due Date`) <= 0) THEN '*Current' WHEN…
-
possible to have 2 date ranges?
I have a card I'm trying to build where there is a hire_date for an employee and a termination_date for an employee, where we are trying to determine the retention which would be the number of employees who left divided by the number hired. Problem I'm coming across is how to have two different dates on the card to 1)…
-
Redshift Cast as VARCHAR changing last character
I am testing out Redshift and noticing that when casting a column as VARCHAR in Redshift, the final character in some rows is being altered. After checking and rechecking the input, the data source is correct and the only change we are making is to cast as VARCHAR type. We are unsure of why this would be occuring, and…
-
How do I merge data into single row?
I'm working on creating a card that feeds from our data set of activities. Each activity has a status (1,2,3,4,5) and is tied to an individual client. The table produces a result similiar to this: Activity 1Activity 2Activity 3Activity 4Activity 5Client ACompleted Client A Completed Client A Not Completed Client A Not…
-
What are the meanings of the USER roles in DOMO
Could someone please define the various User roles. I have no clue what Privileged, Editor, Particpant mean??
-
Alert Not Showing Same as Card is built
My card is a heatmap card with a row for different accounts and columns for the last 12 months of data grouped by month. I have an alert set on it so that if any accounts most recent month of data = 0 to alert on that. However somehow when the alert triggers I get results from the same account multiple times. Example (What…
-
Comparing 2 Points on a Line Chart
Is there a way to easily compare the data behind 2 points of a line chart? When clicking on any point of a line chart I get the tabular data for that point. To see the differences in data of 2 points on the same line I have to click on each one independently and export the tables to then compare the data using the created…
-
MySQL using different timezone to workplace setting
I've just discovered that cards will use the workplace setting for a timezone, [e.g. AEST] whereas MySQL Dataflows will use GMT. I'm trying to sum total sales by month, to then apply a monthly commission formula. This sort of structure: |Month | Sales | Commission| |2017-09|10,000|3,000| |2017-10|12,000|4,000| Where Month…
-
Social Media Connector guides?
Is there any kind of guide, legend, or glossary of some kind for Facebook / Instagram / Twitter / LinkedIn connectors? While there is a "?" next to Reports that gives a brief snippet about what is included in the report, I don't know how I can find what columns are exactly included in each report. And there's a lot of…
-
Help with Formulas and Count when <=
Hi all, I am working on building a card that displays a count of cases that are less than 1, 2 and 7 days old from creation date. Currently using this formula for case age: SUM(UNIX_TIMESTAMP(CAST(NOW() AS DATETIME)) - UNIX_TIMESTAMP(CAST(`Created Date` AS DATETIME))) / 86400 This returns a decimal form in days which is…
-
Magento Integration and best apps
Hi All, Recently got onto domo, we use Magento and i would like to integrate this properly into the domo cards I have connected the MySQL properly so there is not issues there My issue is what apps are compatible with the data from MYSQL, are there prebuilt ones that i can simply used and plug n play Any help would be…
-
Error when using API to create a new user
Hello, I am trying to automate creating new users in DOMO by leveraging our active directory. I have it build to grab the user information when they are created in Active Directory and put it into JSON format and pass it through the API to create the user. It worked fine 3-4 weeks ago when tested and now that I am trying…
-
Analyzer vs Edit in Analyzer
Should be easy to find the answer to this, but I don't seem to be able to. Is there a difference in clicking the Analyzer Alchemy Bottle button vs clicking the wrench and going to Edit in Analyzer? The reason I ask, I recall reading somewhere that users can edit/filter any given page and it will save for them, but not…
-
Zip to Fips SQL Cheat
Though there is option to have domo build a custom fips dataset for your instance and it may seem easy to do a seperate table for joining - it has arisen that sometimes joining does not provide all table rows to be assigned appropirate fips. Sometimes, conversely you are looking for specific counties or to bucket (numeric)…
-
DOMO + Google AdWords Connector?
Following this page https://www.domo.com/connectors/google-adwords it seems like there should be a in-built way to see my Google Adwords data on Domo. However looking at the forums I've only encountered an user-provided-script to pull the data into a google sheet. Is there a way to connect my adwords data to Domo?
-
Pulling Data From an API Using a Hashed Signature for Auth
I'm trying to pull data from an API into DOMO. The API is using an apiSignature for Auth. The apiSignature is created using using an HMAC_SHA256 hash of a date string using a private key. A new apiSignature is created for each request using a current date string. The apiSignature, date string, and public key are then sent…
-
Standardizing Naming Conventions - Can we change Redshift columns to proper format?
We're attempting to standardize our naming conventions and would prefer to use a Proper format. However I can't find a way to modify the column headers with Redshift datasets as they automatically get convered into lower case format. Is there a way to do this? I've attempted using Alter Table in Redshift with no luck so…
-
Is it possible to use beast mode functions to set maximum values on gauge cards?
Hello, I am building a filled gauge card where I would like to show as a maximum value the total number of members in a gym and, as the current value, the number of those members who are using a training plan. The problem is that I also need to include a few filters (to exclude employees and inactive members for example),…
-
Turnover Calculation/ Beast Mode Help
I've got employee data coming in through our HRIS, and we've got a table that we link to, that provides our location hierarchy. I'd like to add a dynamic column to the merged data that gives me the current turnover for that location. The turnover formula we use is total number of terminations divided by the average number…
-
Need Help With Beast Mode| Percentage Change From Previous Quarter
I need help in fixing below code. Current code is getting the value of totals of both quarters: CONCAT( -- This portion can be updated to include whatever text or formulas needed 'Totals: Q1 ' ,SUM(CASE WHEN (MONTH(`Date`) IN (11,12) AND YEAR(`Date`) = 2016) OR (MONTH(`Date`) = 1 AND YEAR(`Date`) = 2017) THEN `Unique…