-
Microsoft Exchange (Email Attachment) Connector
Hey Dojo community, I've been using the below connector for some time to pull calender information, that powers a card showing prospect meeting's and their status. Domo | Domo Recently, the credentials for this connector have stopped working, and i'm unsure if it's to do with the URL it asks for, does anyone know what…
-
Make "Save and Comment" comments available within the DomoStats or Domo governance connector.
We allow certain individuals to do minor card edits on the fly to our production pages but require them to document their changes using the “Save and Comment” functionality. While this logs to the card history on the card, it would be very helpful to grab this as a dataset to track these changes over time in one location.
-
Why is a field not allowing me to exclude it?
I recently built a new field for my dataset in Excel that added certain employees into specific groups. Most employees are not in these groups, so when I joined that field to the rest of my dataset most of the fields are blank. This should be fine. However, when I add this field as a filter into any dashboards or charts,…
-
Date selector calendar autorefreshes
Is there a way to keep the calendar view on the Date Selector filter to keep from auto-refreshing to the present month when dates are selected? I would like to keep the selected month in view. I'm sharing below a gif of the issue I'm encountering. Thanks!
-
Heatmap Time Sorting Issue
I recently created a weekday and half-hour heatmap using Beast Mode functions to break timestamps down to half-hour increments. But for some reason, the chart is sometimes sorting the half hours into the wrong order. Notice how 3:30 PM appears before 3:00 PM in the chart below, as does 830 PM before 8 PM and 930 PM before…
-
Is it possible to show labels on "small" cards in dashboard?
It seems that no matter how big the actual graph element (e.g. pie chart), if you have more than 4 cards in a row the data labels will not show. Weirdly, the pie charts themselves in the 5 card row are considerably bigger than ones above in a 4 card row due to being tall cards…..for both rows, data label size is set to…
-
See descriptions/definitions of data on cards
When building dashboards, we can write text boxes and things that help explain what charts are telling us... but that's often only needed the first few times a dashboard is read, after that it becomes cluttered. It might be useful if we had an information icon that would bring up a pop up box explaining the chart. For…
-
UI/UX: Navigate to DataFlow input datasets directly from DataFlow overview screen
From the DataFlow Overview screen (<dataset>/details/overview), I want to be able to quickly access the overview pages for the input datasets of that DataFlow. I can get to them via the Lineage page, or the Direct Impact info, but I want to get direct, immediate access to each dataset's name and a direct link to it, so I…
-
How to remove duplicates without affecting the blank cells?
Hii Team, I have a dataset which is a join of a user name and phone number and their transactions ID however I need to remove duplicate transaction ID without removing the blank cells as if the user has no transaction ID against it. That means that user has not conducted any transactions. Eg: Dataset Sr No Name Transaction…
-
How to set up a min/max equation in a Beast Mode?
I would like to setup a beast mode to calculate a fill % for contracted values, however I would not like it to show any values that went above 100%. I know in Excel it would be as easy as =MIN(100,SUM()) How would I accomplish the same thing within Domo? The two columns being run against each other are as seen below. Total…
-
Add Distinct/Unique COUNT to Analyzer Dropdown Aggregations
Creating beastmodes just to count a distinct value adds additional clutter that could be minimized by adding distinct counts to the list of aggregations on a card.
-
Breakdown of Yes or No Values
I am looking to create a graph or table that shows a breakdown of who answered yes and who answered no in a specific state. E.x. in GA 100 people took the survey, 45 answered “Yes” and 55 answered “No” in FL 50 people took the survey, 20 answered “Yes” and 30 answered “No” What graph/table would you use to display this in…
-
Extended DataSet information on DOMOStats
Can we get DOMOStats to include some of the additional information available on cards like in the API or CLI? While DOMOStats is great, there are some key funcionalities it lacks that are already available through the API and CLI and that would be a huge help when it comes to managing the instance. Some of the top of mind…
-
Beastmode not recognising exisisting column
Hi All, Two columns that have been added are not being recognised in the beastmode I've written, Please let me know if I'm missing something or if it's a bug. Kind regards
-
Making a Field to Calculate 'Yes' or 'No' Sales for last quarter
I am attempting to build a beastmode that gives me a value of ‘Yes’ if there is a “sale” in last quarter or a "no' if there isn't. Here is my code so far: *‘End of Business Date’ acts as a current date function in our dataset. The issue with this is that it does count all the rows from last quarter as a ‘Yes’, but if there…
-
12 month rolling pivot table with filtering capabilities
Hi all, I have a customer that is looking for a way to create a pivot table where value for each month is a sum of current month + previous 11 months (so in total we have 12 rolling months). For example, value for Dec'22 = sum of values from Jan'22 to Dec'22. Below is the formula that they created for this but when there…
-
How to combine federated dataSet to another dataset?
I tried to combine 2 datasets using ETL but then realized that Federated dataset does not support ETL. So is there any other method to combine 2 datasets on this case? Thank you,
-
Combine date columns
Is the below logic possible? If appeal determination date is blank, insert determination date, if not insert application determination date?
-
Javascript field name has spaces
I have tried back ticks, brackets, everything I can think of The script below works correctly and provides the results that I expect, but I really need to put Account Level 9 in the var where Specifically Account Level 9 = Administrative expense but when I add the field I get nothing. I can see the record in the output…
-
Lineage of a field
Hi in domo can you find the lineage of a field , as in all the data flows or data sets a field appears in .
-
Formatting a table
I have a table which I would like to have sub-rows providing sub-total numbers for each month. It currently looks like this. How do I get it to look like this? Where the total rows are emboldened, the color coding applies to their respective columns, the “Count x/y” is replaced with Total in the Retailer field, and the…
-
beast mode calculation
I am trying to create a card that shows the percentage of data. I have a field from salesforce that is Target_Count__c and I need to show the how many targets actually have a date in the X12_Month_Review__c section (# of follow up reviews / percentage of target count). I tried to use this formula and filters but nothing is…
-
Number of Posts Published
Hello, Trying to figure out the best way to show posts published for x period of time. I believe I need to use some kind on minimum date so the post would only be counted once but have not had any luck. This would help understand the number of posts needed to see consistency and gain increase in engagement.
-
Count Distinct with Fixed?
Do the fixed functions actually work with Count Distinct? I'm trying to leverage them to ignore some filters, but they're not producing the right results (always significantly higher). The example below does not include the filter bit since I can't even get the base of the function to work correctly. The window function I…
-
Success Rate %
To work out the success rate I need to (a) count number of rows where 'Status' column has 'Application Granted' and divide this by (b) count number of rows where there is a value in 'Determination Date' column. A / B = Success rate Any help would be much appreciated, cheers
-
Disable slicers from being displayed as filters on top of the dashboard
Hi, I am using slicers in the dashboard but since the page is too long, I plan to duplicate these slicers and use them in the 2nd half of the page as well. However, I do not want to display these slicers on the top of the page as filters. Is there a way to disable the filtered view for slicers?
-
Converting Text column with fiscal periods to a date
Hello, I have a relatively simple dataset with one column that lists fiscal periods, another with some product types, and another with sums of those product types. I'd like to use this data to create a bar variance card, but Domo is currently looking at my fiscal periods column like they're 'text' instead of 'dates.' The…
-
Is there a way to create a filter for line charts
Is there a way to have a multi-line chart connected to a filter which can allow a user to select which metrics they want to see on the chart?
-
Ability to see/edit the process steps in a dataview
I've run into an issue where I need to update an older dataview or fix an error, but I can't get to the process step to fix it because it was done before a GroupBy aggregation step was done. When I tried to roll the dataflow history back to a point wher I should be able to see it I only get an error. Support wasn't able to…
-
Adjusting Axis values vs values on line chart
For line charts (or any type), is there a way to differentiate the value format on the axis and the values displayed on the lines? For example, below, I'd like the left axis to display percentages with no decimal (5%, 10%, etc. -- NOT 5.00%, 10.00%), but for the values displayed on the line nodes to have two decimals…