-
Calculate price change from period to period
Hello all. I'm trying to show the change in price month over month. For example, I'm trying to show that the OpProgramPrice has changed $0.01 from AccountingMonth 19-01 to 19-06. Any ideas on how to do this? See the table below. I've already tried this case statement to have it focus on 19-06 and minus 19-01 but it isn't…
-
Awarding badges to User
I just created and awarded a badge to a user for the first time, but couldn't determine how the user would know they have it. Are they sent an email? Will other users know they were awarded a badge?
-
SEE Pardot Form Handler Information in DOMO?
I've connected Pardot to DOMO, and find right now only have the Forms information from Pardot, but exclude the information about Form Handler. Is there's a way to see the information about Form Handler Performance in DOMO? Thanks!
-
Link in Description
I have added hyperlinks in a card, like in the cells of my table, but is there a way to add hyperlinks in the descrition of a card? I tried applyign the same format but it did not work.
-
Month Name as Text
How can i format a date to Month Name as have it as Text not Date? Reason why I ask is because I am creating a table in Domo that is going to have a Grand Total Row, as per a previous topic of mine, the Grand Total Row will have a calulation for percentage. So what I need to do is convert the Month Name into a text field…
-
Use Filter to change ranges in chart properties
I have a situation where the consumer would like to use the face gauge to see their performance. The consumer of the card has several clients with different goals, and would like to be able to change clients using filters. I have not been able to find a way to have the minimum and maximum values of the chart properties…
-
Box Advanced Connector
In the Advanced Box connector is there a reason I can't put in a File Name and specify the match as "Exact" instead of "File Name Starts with the Specified String" or "File Name Contains the Specified String"? I want to be able to put in the exact file name like I can in the original Box connector but have access to the…
-
PDP based on multiple columns
Each row of my data can identify a type of transaction up to 6 different ways. Example shortened to 3 transaction type columns: cheeseburger15.25food t-shirt19.99retail combo pkg199giftcardretailfood I want to create a PDP policy that allows a group to view all food type transactions. The policy would need to say if…
-
limit decimals on comparative guage cards
Any one know if a way to limit the number of digits are displayed after the decimal on these guage cards?
-
Sum previous month traffic
I need to sum the latest month's and the previous month's traffic for each Name. I'm trying with beast mode. My data is like so: Name Date Traffic (desc) AAAA 2018/10/31 2,358,817 AAAA 2018/11/06 2,483,452 BBBB 2018/10/30 2,555,555 BBBB 2018/11/06 2,123,123 As the 'day' part varies from month to month I tried cutting off…
-
New to Domo - make sure you look here for some fun data to play with
I was browsing the Domo site and ran across this https://knowledge.domo.com/Domusement/Fun_Sample_Datasets , it looks like it was posted last month so it is pretty new but thought it could help with folks that are new and want some data to play with that they can't screw up. Enjoy. Also - if you have something at your…
-
Total Row
I am creating a table card. In the card I have 2 calculated fields to give percentages. I am then adding in a Total Row, but instead of using the same calculation in the Total Row, its Summing all of the percentages. How can I create a total row so the same calculation is used in the Total as with the other rows? See Image…
-
Navigate from a card to page
Is there a way to navigate from card in a page to a new page having another set of cards. Please help Thanks in advance
-
PDP and Publication Groups
I am very unclear when to use which. If I want to make restrictions so that each department sees something different, which is best to use?
-
How to setup SFTP Connection
Hello, I am trying to setup the SFTP connection, so one of the department can drop the file to the local DOMO server. But looks like it asks for the password. Which I am not sure how that works- is it the .Pem key/ Dataset id. It would be great if you could tell me how one you setup the SFTP Connection. Thanks,
-
Can you share a dataflow etl?
Was wondering if it's possible to collaborate on a dataflow ETL by multiple users.
-
DOMO Report
I need to extract entire dataset into excel and email to internal user as report weekly, I don’t see option to send excel output under scheduled report. I don’t need to create card etc. Just raw dataset into excel and email… how can I do that.
-
Append data issue using CSV upload
Hi All, I'm uploading CSV file via workbench and I have scheduled every four hours. I'm getting all the records without any update. My requirement is to get all the records which are not present and which are present those records to be updated. But, what is happening is records which are present are not updating but…
-
Insights Feed
According to the new release notes the Insisghts feed can be customized for "you". Exceprt from release notes - You can tailor your feed to show you the most meaningful Insights and NLG Analyses by rating each one using a "thumbs up" or "thumbs down" icon. My question is whether "you" is the user or the instance? Will each…
-
Adding Total Row and Column to Heat Map Cards
A request that we have been receiving on a few Heat Map cards is the ability to show row total #s and column total #s. We tried to use the Sumo card, but without the ability to fully format text, columns, etc, the view is pretty cumbersome. Any development currently in process on this?
-
I need some logic for this table please... guru needed!
I have a table with 3 fields in it: Order ID Gift Name Gift Quantity an Order ID can be an order for several gifts, or just 1. So you might have a table like Gb121 Gift Name 1 1 GB121 Gift Name 2 3 GB122 Gift Name 7 1 What I need is a logic statement that allows me the only display table items where the TOTAL number of…
-
Anyone know how the default Security Role is determined?
So I have Okta enabled. I create a user in Okta without them being in Domo and when they get pushed into Domo the default security role is PRIVILEGED. That also looks to be the default role when I create a new user manually in Domo. Any ideas on how to change that so Okta will bring them over as Participant or something…
-
Date range 2 days back , but on Monday 4 days back?
Hello, I'm making a daily scorecard based on looking @ 2 days back ( as that gives me yesterdays data in this data set
-
Report Scheduler - Select Which Cards
Say I have a page with 10 cards, but I only want to schedule 4 of them to go to one user. Any way to schedule just those 4 without creating a sub-page and copies of those same cards?
-
Is there a way to get a notification if a workbench job is taking more time than the set time limit?
Hi, We faced an issue in one of our workbench jobs. The job is scheduled to run every 5 min and if it fails, a notification is sent on my mail. But, in case there is an issue with workbench, and job enters into a state of non-termination i.e. runs continuously but never completes nor does fetching any data and neither…
-
Anyone else not get the NLG / Insights option in the October release?
Apparently it may have shown up last night and gotten removed today. But just curious if anyone still has it available in their instance.
-
Number of Facebook Leads Through Ads by Device, Gender, Time of Day
Hi all, I'm trying to create data sets that show the number of leads collected through each of my Facebook ads (showing the name of the ad in the data set) by Device, Gender, Time of Day, and Placement. Does anyone have a way to do this through the Facebook Ads Advanced connector? I've retrived data on ads with custom…
-
I want beast mode calcs verified by an admin before adding to a data
Is there a way to limit who has access to add beast mode calculations to a data set? I want anyone to be able to write them - but I do not want them added to the data set until they are verified by an admin.
-
Case Statement with calculation
I wanted to create a calculated field using case statement, but have a trouble to get what I want: I have a dataset looks like below, in this new calculated field, if Category is A( and many other categories) and Date is in last 7 days then SUM(Value) if Category is B or C (only these 2 categories) and Date is in last 7…
-
WorkBenchのLock Data Typeが外れる・ロックされない
WorkBench v4.26を利用しています。 自動判別で各項目の型が変換されてしまわないよう、Schemaの設定で Data Typeで型を指定し、Lock Data Typeにチェックを入れています。 この状態でData Typeは変更されない想定なのですが、以下2パータンの状態になってしまします。 ・Lock Data Typeのチェックが外れてしまう。 ・Lock Data Typeのチェックが入っているが、Data Typeが変わってしまう。 同様の事象が起きている方はいらっしゃいますでしょうか? 解消方法をお持ちの方がいましたらご教授頂けますと助かります。 よろしくお願いします。