Property_Ninja Contributor

The total row is just completing whichever calculation you give it on an aggregate level. So when you have sum(staffing_level) / count(distinct ifnull(empID,1)), your total row is doing 4+4+4+6+6+6+2 = 32 / 7 = 4.57.

Wait a second, Why are we trying to divide staffing level? Is it just supposed to be a sum of total employees needed? in this scenario, you can just do SUM(DISTINCT staffing_level) Thanks, Brian

Another alternative would be a window function. I have never actually tried to use this in beastmode but it would look something like ... CASE WHEN `EmpID` IS NULL THEN staffing_level ELSE SUM(distinct staffing_level) OVER (PARTITION BY department) /count(distinct `EmpID`) END Thanks, Brian

You could try this ... the only issue will be is if two department staffing levels are the same, then it will calculate incorrectly. sum(distinct `staffing_level`)/count(distinct `EmpID`) Thanks, Brian

Ahh, I see what is happening here. You have duplicates in your dataset because of the employee id. You won't be able to achieve the result using total row as that is going to either sum or count the fields you have inputted. You will need to create a row in your dataset where you do the aggregation for grand total using a…

Hello, I think you need to change your calculation to sum or count for staffing_level and no_employees by clicking the little pencil button when you hover. Hope this helps, Brian

Hmm ... the only thing I can think of that might work is downloading the file from Domo as a CSV and then using Domo Workbench to load the data back into Domo via CSV. You can upload it in chuncks using the "Ignore Starting Rows" and "Ignore Ending Rows" under "Source." Hopefully this helps, Brian

How are you importing the data into Domo? You will need to break up the data before you even import it into Domo. Thanks, Brian

Hi Summer, Can you just do something like ... CASE WHEN SentDate >= current_date - interval 28 day then 'Last Week' WHEN SentDate >= current_date - interval 56 day and SentDate < current_date - interval 28 day then 'Previous Week' WHEN SentDate >= DATE_SUB((DATE_SUB(current_date, INTERVAL 1 year)), INTERVAL 28 DAY) and…

Hello, You can use a beastmode in conjunction with a period over period chart. Below is an example of how the beastmode would look for percent of cases closed within seven days. Then I would use the Bar line period over period chart, select my time period to be CreatedDate and then my Y Axis to be the beastmode…

Without seeing the actual history of your dataflow, I am assuming the timeout is happening on the actual loading of the dataset, not on the query itself, correct? If this is the case you will need to break up the raw dataset before uploading it to Domo. You could also try creating a Domo support ticket and see if they have…

Hello, Have you tried using Redshift queries in Domo to produce your datasets? How much data are we talking about here? Thanks, Brian

Hello phongtruong, Domo is very good at ingesting information but currently does not support a way to send information out to google sheets. The only way to do this would be to use the domo package in R to ship data from Domo to R then use the google sheets package in R to send that data to google sheets.…

Hi Shane, I think you are just missing the THEN and ELSE part of the syntax (case when DATEDIFF(`Current Date`, `Date Last Updated`) >= 2 end) vs. (case when DATEDIFF(`Current Date`, `Date Last Updated`) >= 2 THEN 'true' ELSE 'false' end) Then you can filter on true. Hope this helps, Brian

Hello, If you are filtering to yesterday then you will not be able to do what you are looking for via beastmode. You will have to write some syntax in a MySQL flow for a cumulative sum. It's very easy to do and this article should help you. https://discourse.looker.com/t/cumulative-sum-in-mysql/807 Thanks, Brian

I agree with ST_-Superman-_ that you would not need a stored procedure for the example you gave but if you did it is important to understand the "CALL" statement just runs the syntax inside of your stored procedure. It doesn't actually output any tables. You would have to make a specific function call in the stored…

So there does not seem to be a way to just hide the card without removing and adding back permissions (seems like a good idea to put in the ideas exchange on the Dojo). Alternatively, if you are not worried about people searching for the card you could just move it to a new page and leave the same permissions tied to the…

How are you assigning permissions currently, at the page level or the card level?

Hi Alessia, If you click into the card then scroll to the bottom you can change which users have access to that specific card. Then once you make your adjustments you can re-share the card by following the same steps. I have an attached an image that will show what it looks like. Hope this helps, Brian **Please mark…

Okay, so Domo does not recognize filtering on NULL values, which is why your target is not showing. You should write a beastmode and filter on that. Something like ... case when `Deleted` is null then 'Goal' else `Deleted` end Then you can filter on 'Goal' and 'No' and your goal target should show. I just tried it and it…

Hi dtao, There is currently not a way to wrap a chart title in Domo. If you are not using the summary number you could potentially put part of the title in there by creating a beastmode as a workaround? This might be worth putting in the "Ideas Exchange" Hope this helps, Brian **Please mark "Accept as Solution" if this…

Hi Catherin, What I was implying is that when you filter it is removing the values of your goal, meaning the actual data of your goal exists in the rows you are filtering out. Is this the case? If you can send a snippet of what your raw data looks like it would help to figure out what the issue is. Thanks, Brian

This is a duplicate question, please see the suggestion here https://dojo.domo.com/t5/Data-Sources-and-Connectors/Automatically-export-data-from-Domo-to-CSV-on-a-daily-basis/m-p/36342

Hello, I don't know of anyway to push data to ftp from Domo but you can use the DomoR library in R to export the data on a daily basis and send it to an ftp server. This will be able to be done all in one R script. The below links are some info on both questions. https://github.com/domoinc-r/DomoR…

Hey drewfig, No worries. I moved some of the parentheses around so this should work for what you described above. ((SUM(CASE WHEN `8Q` = "POR" AND `Fiscal_Year` = "FY19" and `Week` = "1" THEN `8Q_Price`*`Tons` END) / SUM(CASE WHEN `8Q` = "POR" AND `Fiscal_Year` = "FY19" and `Week` = "1" THEN `Tons` END)) ----- (CASE when…

Hi tjlew, I believe the best way to do this would be in either a MySQL or Redshift flow. You can simply do something like select column1, column2, column3, `event date and time`, CASE WHEN `event date and time` < '2018-08-01' and customerID = 123 then 456 else customerID end as customerID from customertable Possibly a…

Hi Sean, One workaround would be to handle the JSON response in R and upload the resulting dataframe to Domo using the DomoR package. Hope this helps, Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Hello Drewfig, Based on the order of operations, you want your algorithm to divide a and b then divide c and d then multiply the results of c/d by e and then subtract the results of (a/b) and (c/d*e). (SUM(CASE WHEN `8Q` = "POR" AND `Fiscal_Year` = "FY19" and `Week` = "1" THEN `8Q_Price`*`Tons` END) / SUM(CASE WHEN `8Q` =…

Hi, Sorry I do not work for Domo so I am unable to delete your data. What I don't see in your screenshot is the three elipses, which are highlighted in my attached image. I believe you have to disable the report before you can delete it. If you do not see the three elipses then you must not have the permissions to delete…