-
Add rows based on Start and End Date
I have the following table within my output Cust_No Start_Date End_Date Comp_Val Monthly_Val 123 2023-01-01 2023-06-30 1100 55.95 123 2023-07-01 2024-02-05 1100 22.90 As you can see, the months between start_date and end_date for this example, is 13+ months. What I would like to see is a row for each Year_Month between…
-
Can you use workflows to automatically manage workbench?
Our workbench jobs have a habit of getting hung up when updating making our data fall behind and our end users annoyed. I've already reached out to domo support to help with this issue but in the meantime I have workbench open and I manually update the jobs that miss their scheduled updates. Seeing how this is pretty…
-
Cant sort on a specific column suing rank and custom function
when I create a calculated field using this formula and this is created as Ranking CASE WHEN RANK() OVER (PARTITION BY SUB_CATEGORY_TXT ORDER BY SUM(SALES_LC_AMT) DESC) >=6 THEN 1000 ELSE RANK() OVER (PARTITION BY SUB_CATEGORY_TXT ORDER BY SUM(SALES_LC_AMT) DESC) END now when I drag and drop Ranking to filtering, it says…
-
Creating a running SUM
Hi, I am trying to figure out what the best way to create a running sum would be. I know there's an option on a table, however, I am trying to create a line bar. Would the best way to go about this in an etl or a beastmode? For example 1-30-24 should be the sum of 47780 + 42874 instead of just the 1-30-24 revenue.
-
RANK Issues
Hi I'm trying to create a Rank, but sometimes it works others it doesn't don't know why, I have customers and I want to be able to filter by the top 5 customers based on Shipments I have tried multiple formulas and the validation works, sometimes the table works but the filter does not work: This are the formulas I have…
-
Need Column Header to show Day of week ie MONDAY, TUESDAY etc
I Need the Column STATUSDATE to show the day of week ie Monday, Tuesday Wed etc. instead of the DATE but can not figure out out to FORMAT.
-
How to automate DOMO report with Microsoft teams?
Hello, I want to automate DOMO report. I want DOMO to extract report and message the assignee name automatically over Microsoft Teams. How i can achieve this?
-
Chart Quick Filter to Change which Measure is pulled into Bar Chart
Is it possible to have a Quick Filter allowing user to select which type of measure is included as a value on a chart? For example I have Spend and Savings; if the user selects Spend the chart would pull in Spend and if Savings is selected the chart would pull in Savings only as the value.
-
Performance of private embedding
Hi, we are embedding using the flow described in this diagram but find it quite slow. 5-10 seconds to eventually render the board. Has anyone else found this or found a way to improve it?
-
Displaying a Blank chart
Hi, Is there a way to have a Chart display blank data until filtered. For example I have two charts one with products x,y,z and then the other being a blank chart. When I click on product X, I want the blank chart to display every customer. When no product is selected I want the chart to be blank. Hopefully that makes…
-
I am trying embed a dashboard and apply filters using the pfilter param and it is not working
Currently I am having issues getting the pfilter query param with the embed working in an iframe. I have followed many of the examples out there and have replaced every special character in the value with their ascii counter parts but nothing has seemed to work Here is an example of what I have been trying:…
-
Converting Dimension Column to Measures
one of the column in my dataset is $$$. However, it is in the Dimensions and will not calculate.
-
Dynamic comparison values
Hi Team, How to compare two dates values comparison in dynamics with examples coding Thanks, Raja Parthasarathy
-
Show portion total as % without showing other portions
I'd like to know how to take the percentage of a metric without showing other portions - for instance: I have footballs, basketballs, baseballs and lacross balls. If I sold 35 footballs, 25 basketballs, 20 baseballs and 20 lacrosse balls in Q1, in Q2 I sold x footballs, x basketballs etc. I want to see the percentage of…
-
Identify Null Roll-Ups in a Pivot Chart
Hi Folks, Question: How do I identify blank values in a pivot chart? I want to filter where all values are blank against any column in a pivot chart but no option. I can't do it in the ETL either because it needs to be dynamic based on a date selection. (dates are the columns) Context I have the fields 'People', 'Dates',…
-
Query code or Documentation for Domo Brick connection to Domo Magic Dataset
Can anyone share the piece of code you need or a document where I can find how to connect my domo data set to a domo brick? It's kinda frustrating as heck to see this documentation on how awesome the Domo bricks are, but nowhere does it tell you how to actually connect a dataset to it.
-
Flip Fields in Stacked Bar Chart
Not sure why I'm getting the below bar charts to show the 2 stacked values in a different order for each. Top graph shows Call + Slides (blue) on bottom of bar, Bottom graph shows Call + Slides (green) on the top of bar. I've not been able to find anything posted and have not seen any setting in the graph settings to…
-
How do I find the dataset alias?
Learning on the fly for DDX, and I can't even seem to understand how to find the dataset alias? Nor can I find documenation.
-
Creating Table Chart with Sales & Sales Last Year
I have a dataset where each dow represents a daily transaction 'date' for the 'productSKU', 'size', 'sales channe'l and also contains other columna where it sums the 'sales', 'stock on hand', 'units sold', etc I am trying to create a calculated field for 'sales last year' as a column for the 'sales' from a year ago for the…
-
Marking Duplicates So I Can Filter Them Out
Good afternoon, I am trying to mark rows that match up with each other as duplicates so that I can filter them out and only have the truly unique records left. Example So after I mark and filter the only record left will be the third one that doesn't have a match. What is the best way to do this? Thank you in advance
-
Storing Projected Values
I have a graph setup giving me daily data. (e.g. sales). I've used as part of the graph "Multi-Period Projection" and set it for 5 days out. What I want to know is how accurate this is to the actual. Today is 1/31/2023 and sales was $1M, and the prejection for 2/3/2024 is $1.3M, I want to know how close the projection was…
-
"Hide Insights for non-card owners"
Is there a way to 'Hide Insights for non-card owners' on all cards via workflow? If anyone know the API please share. Thanks, Kathy
-
Displaying DOMO Page Url in an iframe
Is it possible to render a page url within an iframe directly. For example, a DOMO page url: https://masschallenge.domo.com/page/212080366/ HTML: <iframe id="iframe" title="domo embed" src="https://yourcompany.domo.com/page/5675676/" />
-
Is it possible to load card data in google sheets using the DOMO Google Sheets extension?
Is it possible to load card data in google sheets using the DOMO Google Sheets extension?
-
Workbench 5 error message when uploading local Excel file...
Attempting to create a job uploading a local excel file using Workbench 5. Getting the error message depicted below… File looks clean to me. There are several formulas in the sheet returning #N/A errors. I've set the below error handling for this. Any ideas what is wrong with the excel file? (I've also tried to upload the…
-
Calculating a % based on multiple dates
I would like to create a beast mode that calculates the % of the way we are into a campaign. In Excel, I would calculate this as =(TODAY()-'Start Date') / ('End Date' - 'Start Date') Here's what I have so far (I want this to return a %): (SUM(IFNULL(CURDATE(), 0) - IFNULL(`Start Date`, 0)) / NULLIF(SUM(IFNULL(`End Date`,…
-
Uploading Excel - Data Type Issues
When uploading an Excel document, where all of the data in the columns are formatted as "text", DOMO will change the data type to number, every time I upload it. I know there is an option to change the data type using MAGIC ETL, but here is my problem. In our data we have account numbers with preceeding zeros, for example…
-
Embedded DOMO dashboard not loading on click
Hi experts, I do have a system in which I am showing my 4 domo dashboards on one page via tabs. Each dashboard is embedded and does visible when we click on them and then I change the src attribute of iframe to load that embedded link. Now what's happening is that, when I first load the page using hard refresh, the first…
-
Domo Embed - reporting with a date range issue
I have an embedded dashboard that has programmatic filtering which includes a date range. This functions fine although i am now hitting a challenge in testing for the following reasons. I have records in the db table for when a product is available and another date for when its not available. I want a count of records that…
-
Burndown chart
I am trying to create a card that shows a burndown representation of my data. My data has to do with Courses, estimated time to Complete (Duration), and Actual Hours to complete. I think to create a burndown I need a new column that gives total Duration per year of all courses due that year and then I want to be able to…