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.…
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 calenda…
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 …
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 Or…
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…
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 …
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…
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 sh…
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 …
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 fi…
