-
How to format month to show as "December" instead of "12/1/2017"??
I am pulling data from an excel file that needs to be formatted as "MM/DD/YYYY", however, when I display the data on a graph, I want the x axis to show, in this example, "December" instead of "12/1/2018". How can I make that happen?
-
FIPS codes?
Why do I need to provide FIPS codes for maps in Domo? Tableau doesn't make me do this.
-
YoY YTD Comparison
I am trying to build a chart that compares YoY growth across cities. X axis would be the city, primary Y axis would be revenue, secondary Y axis would be % change, and the series(grouped bar) would be YTD revenue, and Prior Year YTD revenue. I can't seem to do this in the YoY charts because I need to show the cities on the…
-
Facebook dataset importing stalled
Hello, I've been trying to import a dataset through the Facebook Advanced connector but for some reason it's stalled on the 'importing' status. Can someone please advise? Thanks!
-
error in documentation of weekday beast mode function
I think the documentation for weekday function in beast mode is not compatible with its behavior in the documentation. "WEEKDAY Returns the numerical day of the week for all values in a date/time column (e.g. '0' for 'Monday'). WEEKDAY('DateCol')" but when I created a card I get this result which shows number from 1 to 7,…
-
Pivot Table App In the App Store
Sometimes you just need a Pivot Table. At RXA, we often find ourselves trying to create very specific tables and it can be challenging to get the rows and columns just right, and sometimes it can be nearly impossible. So our team created a simple Pivot Table app to solve this problem, and it's live in the Appstore this…
-
Pivot table type view
Is there a way to have a pivot table-like view in Domo (that sums up columns and rows)? Our users predominantly use iPads and my understanding is that sumo cards don't work on the iOS app. We currently use heat maps to get our variances, but one drawback is that there is no total by category. Is there any other card type…
-
How should filter the last month data using Magic ETL?
I need to do some calculations using the last month data with Magic ETL but I not able to filter. For example the data between 01/01/2018 and 31/01/2018 inclusive. I was thinking to calculate the first day of the last month and the last day of the month but it is getting complicated. Is this possible using Magic ETL? Thanks
-
Attachments using report scheduler
Hello Team, Can we get output of a report schedulrer as an excel attachment? Thanks Bandla
-
Sharing what solved my issue - video included
I've been working through an issue with how best to build a dataset in Domo. I needed to move away from Data Fusion as an approach to allow for PDP. I tried using MySQL but that didn't provide a short enough run time to meet our needs. I was also looking into other software tools to do the ETL work outside of Domo, but…
-
Multiple Values Across Columns Compared Over Last Year
Hi everyone, I have two columns of data with similar values, e.g., Duck, Goose, Horse, etc. I am agnostic to which column it is in, I would like to know the net change over the previous year (preferably in a heat map table). Here is an example of what the data may look like:…
-
FIltering by percentile in Beast Mode/ETL
I recently had the need to filter a list of pages by pageviews. I only want pages with pageviews in the 80% percentile or higher. This had to be done on a weekly basis. And I don't want to use a fixed-number cutoff (e.g. filter when pageview is >1,000, which is a fixed number), since pageviews > 1,000 might be considered…
-
HTML conditional color format as percentage of goal
I have a a domo dashboard that is in the bullet format. the data I have is listed in into 3 categories: 'Current', 'Trending', and 'Goal'. I want to create conditional color formatting that turns the current section red when it is below the goal, yellow when it has reached the goal, and green when it has surpassed the…
-
Last month (when the data is uploaded on the 15th)
When I try to select show last month but because of the way my data is uploaded (e.g. January data is uploaded on 14th February, February data is uploade on 14th March etc) it doesnt load any data between the 1st and 14th of the month when you selct "last month". Is there perhaps a beastmode I could use to achieve this…
-
How can I view the credentials of a connector when I use it?
In the context of the credentials of a connector, I create an "account", then I want to see what I created, is it possible?
-
Box.com may be having problems today
I'm experiencing some issues with Box.com today. I have created some new connectors and they aren't finding the files. I went into box and used the search feature there and it couldn't find it either althogh the file could be seen on the same screen. So they may be having some technical issues. I've posted a support ticket…
-
Is there a function to track users and see who is logging in to the site?
Are there user statistics, similar to Google, that will tell us wo has been on our instance, how oftern, how long, how many times they have come back etc... I am trying to gauge how effective our marketing campaign is to our clients, and how we might be able to tell if they are using the site, and what we can do to get…
-
New Relic Quick Start
Hi everyone, Anyone knows what happened to New Relic Quick Start app? It shows error message: 'Sorry there was an error loading this App. Please try again later.' Regards, mylee
-
value mapper not working
I'm trying to use the value mapper to change the names of sales agents in a cloumn in an attempt to gather them under a general title. For example I want "Sales Agent - John Smith" changed to " Inside Sales Rep". The problem I'm having is that the Value Mapper is working for some, but not others. I've triple-checked the…
-
Is there a way to calculate the total days in the month we are in?
I want to calculate the % through the month. So (total days in month-current date)/total days in the month. Does anyone know the beastmode to do this?
-
Functionality to share a dataset without having to create and share a card sourced by that dataset
We would like the ability to explicitly share a dataset with another user or group of users without having to first create a "placeholder" card. Sharing the placeholder card powered by the specified dataset is our current workaround to obtain the functionality of sharing datasets. I found this idea that was submitted in…
-
Date filters in DOMO API
Hi, I am trying to apply date filter such as todate and last while fetching data through API from DOMO but the filter is not working for me. I am using the following syntax: GET /data/v1/:alias?createdAt last 3 months createdAt:- is the domo date field that is returned through the API. This syntax is not working for me.…
-
"This Month" date range on 1st of the month?
We pull almost all of our data in overnight or in the early morning hours for yesterday (or up to and including yesterday when replacing). When we use "This Month" or "MTD" date ranges, it works as expected until we get to the first of the month. At this point in time, most of our users are interested in reviewing the…
-
NetSuite SuiteAnalytics Timezone Issues
I am trying to pull in transaction data from NetSuite via the SuiteAnalytics connector. For whatever reason, DateTime values are stored in GMT/UTC (specifically a custom timestamp field) in NetSuite and the Date values (specifically the TRANDATE field) is stored in our local Pacific timezone. When I preview the dataset…
-
Can ownership of a dataset be shared by two or more people?
I found how to change the owner of a dataset (https://knowledge.domo.com/Connect/Managing_DataSets/03Changing_the_Owner_of_a_DataSet), but when I try to add a second owner to a dataset, the second name doesn't take. Is it even possible to share ownership of a dataset? Specific use case is to have a back-up owner for…
-
Ability to Group by a Logical Column across multiple dimensions
Hi, My use case is I want to build a card based on 3 Dimensions, 1- Account, 2- Solution Play (tagged to the Opportunity) 3-Logical grouping (Engagement Stages). Engagement Stages (Grouping)LogicConsideration (C)If an Opty exist in Stage 0, Stage 1, Stage 2Negotiation (N) If an Opty exist in Stage 3, Stage 4Vendor…
-
Transpose a card
Is it possible to transpose a domo card? I'm trying to create something like a profit and loss statement which has calculated fields (that needs to recompute on the fly, ETL doesn't help me do that as far as I know). I can use a table card to do this perfectly horizontally - with my metrics as columns and each line…
-
Do a "Sumif" using CASE that's independent of other CASEs
How do I create a beast mode calculation to "sumif" without letting other CASE affecting? Apologies for the vague description, I'm unsure on how to word this. This is my example dataset…
-
Solved: Error when connecting Design Studio in Illustrator
Illustrator Version: CC 2018 Trial I have successfully installed the Domo App Design Studio extension, and it opens when selected from the extension menu. When entering the connection url I am prompted with this message (standard Illustrator error reporting message): "Opps! We've encounted an error. Please take a moment to…
-
Is publication group going away (getting retired?)
Is publication group going away (getting retired?)