-
Delimiter issue
Hello Team, I am trying to do a ETL in domo but unable to get desired result please suggest. In my input, i have a few columns, the lowest grain in Employee id, I have a column called Value, In this values are given using delimiter "|". In my below example there are 2 instances on "|" but in my data it can come any no. of…
-
Get latest data from Ingestion in ETL grouped by month.
I have ingested a data which is regarding the Employee HC. Its per month. I have uploaded first 6 months of data in my ingestion dataset. In my dataset, I have used the append method to update. I have to prepare an ETL to power a new dataset. The dataset is supposed to have data for all months of all clients. The ingestion…
-
Apps Issue
In the domo app studio, I have created an app. But I am unable to change the landing page of the App, earlier i created a page and it was set as a default landing page in domo appp but then i created a new page and I have to change it. How i can do that, I am not finding any options in app, everything is greayed when it…
-
Getting value of previous quarter and comparison
Hello Team, I have a date column named 'Fiscal quarter start date' and another Beast mode with calculated value for 'Customer Survey' I want to create a beast mode in which I will compare the Customer survey of the Current Quarter with the second last quarter. I tried to create a Case statement but unable to get results…
-
Domo App and Group
I have an app created in the domo. I also have a Group created by my Org. I want to share the app to the group, but i am unable to search the group name. Is it possible to share the app to a group ?
-
Top 100 Values
In my data i have a 'client','quarter' and a Beast mode 'Score'. I have created a bar chart with quarter on x axis and Score on y axis. I have to create a card which shows scores for only top 100 clients quarter wise. How i can do that. I am not able to find a way at the moment. If we can do that in Beast modes it will be…
-
Magic ETL - Sum of values in a column
In my dataset i have a column "A" and there are numbers in that which represent spend. I want to create a new column in which i want sum of all values in A to be available in the new column in all rows. Eg. If sum of all values in column A is 125, and I have 10 rows, then in the new column "B" I want 125 in all 10 rows and…
-
Difference of values between 2 months
I have a value column named 'Value' and a month column named 'Month'. I want to create a beast mode to calculate the difference between values of the last two months. So if we have two months in the dataset - Nov 23 and Oct 23. I will want to calculate the difference in value between both months. It is a month-to-month…
-
Subtracting Hours from Date time values
I have a dataset in which i have two columns of date timestamp values in format YYYY-MM-DD HH:MM:SS 1- Date created 2- Date Closed I have subtracted this with a beast mode to get the days and hours minutes: Beast mode name : Test01 CONCAT( DATEDIFF(Date Closed,Date Created),' ','days',' ',TIMEDIFF(Date Closed,Date Created)…
-
Beast mode help with div codes
I have a existing beast mode - CASE WHEN `Actual` >= `Goal` THEN '<div style="text-align:center"><img height="30px" src="https://—-my.sharepoint.com/:i:/g/personal/ABC/EfUFaTLrpHdIvaH4PFDHXIMB0_xo9cIMKVAvSca9bxWQ8A?e=f8YHjw"></div>' Else '<div style="text-align:center"><img height="30px"…
-
Connecting Microsoft forms data into domo.
I have a Microsoft form. I usually download the result of the MS forms in excel form and then start working on it by uploading it to domo via file connector. If it is possible to directly have the Microsoft form data from a particular form available in domo. I have a limitation that I cannot give access to all users for…
-
Beast mode
How I can limit my percentage calculate to be capped at 100% only for those calculations where its exceeds 100%, if not then it should show the below 100% values?
-
Unable to save the card with this beast mode.
In my data, I have multiple months, A subcategory, a commitment column, goal, actual, and a format column. I want to replicate a table where all subcategories, commitment, actual, and goal are listed. My goals and Actuals are just numbers, their formats are discussed in a separate column, so if the format column says it is…
-
I want to create dashboard with a form in domo.
HI team, I want to create a dashboard in domo in which there will be a form. I have tried to create a form in the workflows>forms option but i am not able to find a way to add this kind of form in a dashboard. I need help.
-
Hi Team, Need help in converting a string value to date.
Hi Team, I have a column which is has string values. This column has data related to months and years. Example : Jan-23. The problem is when i am using this column in the chart, its not detected as a date and so i do not get options to filter month and year. I want a way by which i can convert these to a date value. And…
-
Getting no data in calculation in my beast mode.
I am trying to calculate the %age change in headcount with respect to the previous vs this month but by using below beast mode I am not getting any results in the trend line. It gives 0 as a value. ( (SUM(CASE WHEN MONTH(Date) = MONTH(CURDATE()) THEN Headcount END) / COUNT(DISTINCT(CASE WHEN MONTH(Date) = MONTH(CURDATE())…