-
Microsoft Planner + Power Automate
One of our directors is interested in generating reports based on Microsoft Planner data. I'm currently trying to find a way to transfer this data to Domo, but I'm having trouble using Power Automate. I came across a feature called "Export Microsoft Planner tasks to a SQL database" and was wondering if anyone has…
-
Domo Everywhere - Date
Is there a way to enabled Date in the embed card, when I get the card to the website it doesn't let me play with dates and just show all the data.
-
Forecast based on last month
Hi, I'm working on ETL created by someone else connecting 9 data sets. This is for a forecast, the March 29th, 30th and 31st are missing as the Feb only have 28 days. I'm able to join the Domo calendar and get the missing dates. For query we are using the date operator and adding the next month to it. I'm not sure how to…
-
trends ratio for last 4 months
Hi, I created this card last year and it was working fine but as the year has changed and I'm working with 4 months data so 2 are now in last year Nov & Dec and 2 Jan & Feb this year. I tried working with Rank & Window function but running into problem with ASC and DESC My second pic in Yellow is how I want the results.
-
Survey - Count the answers.
If I have a survey and user can choose multiple answers and also have the choice to write. How can I count every option that the user has selected. Results should be like this. Red 3 Blue 2 Green 1 Orange 1 Pink 1 Yellow 1
-
Average
I have created a Card for volume by hour. Now the department wants a card Average volume by hour. COUNT(`Case Number`) OVER (PARTITION BY HOUR(`Created Date`)) I'm not sure if I'm doing it right as it's creating duplicate Hours and Volume. I have done it in ETL and getting the result but then I cant do filters as It's a…
-
Last Month and Same Month Last Year
I'm working on ETL do get the last month data and same month last year. As it will be rolling so I don't want to do the calculation calling the Month November only in the data. (like if last month is Oct then the result will be Oct 2021 & Oct 20202 and if the last month is Nov then Nov 2021 & Nov 2020 and so on) Any Ideas,…
-
3+ Consecutive days
I'm creating a card where it shows the 3+ Consecutive days if the Delegate is No I only want to display 3+ consecutive N but right now its' displaying all the dates. (CASE WHEN `Delegate Y/N` ='N' AND DATE_SUB(`Date`, Interval 3 day) THEN 1 ELSE 0 END)
-
Percentage
Hi, I'm trying to create a card which tells when someone has marked all the documentation. I have created an ETL to count the Numerator & Denominator I also created a column for percentage which is showing correct see the picture below. The 1 is 100% and anything below it's shows 0.85 and so on. But when I use that column…
-
Beast Mode for Aging Bucket
Hi, I'm writing a beast mode to create the aging bucket, it's is showing results but it's has everything under < 15 days. Note sure what I'm doing wrong here. The 0.06% in 15-30 Days are the negative # (CASE WHEN ((DATEDIFF(CURRENT_DATE(), `Application Started`)) - (DATEDIFF(CURRENT_DATE(), `Date Assigned`))) <= 15 THEN…
-
Activation Time <10
I'm trying to get a percentage of less than 10 mints, in dataset I have values where start time is before the arrival time and instead of counting them as negative it displaying positive, how Can I fix this. SUM((CASE WHEN (TIME_TO_SEC(timeDIFF(`Start Time (UTC)`, `Arrival Time (UTC)`)) / 60) <=10 THEN 1 END)) / SUM((CASE…
