KVincent Member

I think what you are referencing can be found by clicking the + sign at the very top to the right of the search bar. Then you would click on page, then if you expand one of the subpages you are working with you have the option to add an additional subpage. Is this what you were looking for?

syntax is probably not correct, but would something like the below work? case when closeddate - opendate <=4 then countdistinct(accountid) end 

Hi There, If whenever I need to pre-aggregate especially on multiple columns I find writing it in the SQL dataflow option to be the most effective. When I use ETL to aggregate it seems like you can only get it to work on one field to aggregate, but SQL is pretty easy for multiple aggregations.

You can use the max function in best mode to return last date. Is there a little more information on what you are trying to do specifically?

Where are you thinking of hosting this? There is a google sheets connector that may be useful or if you wanted to have them enter it in domo there is a domo form card option.

Is that beast mode encompassing all possible month-year combinations? I am thinking that if it doesnt then the blanks by not having an else statement might be triggering the resulting fields to be blank and make it read as text which would not allow you to sort ascending or descending. You could test by adding an else 0 at…

Are you sorting on another field as well? I have noticed when I try to sort by two things that it does not work with domo. 

would an isnull help out the code at the end when (`nonclr_sls`/ `avg_nonclr_sls_qtr4`)*100 is null then '0' perhaps?

You should have a dataset that is provided by DOMOMetrics called Users by role. There is a dimension in there called call user role which should give you what you are looking for.

You can do a save as on one card and it will bring your drill path to the 'copy of card' then any changes make to the Top level view of the card will be encompassed in the drill down view.

I know you were looking for the first day ability, but that does not appear to be an option. If last day would be an option then I could help, but it will involve a MYSQL dataflow. Here is the syntax that you would use. Select last_day(Date) as 'Month End Date' This will create a new column that returns the last day of the…

Glad I could help!

You can control the aggregation in the the beast mode function itself. I would write a new beast mode that would be (CASE WHEN `Primary DNS` NOT LIKE '208.67.222.222' THEN 'Yes' END) I would then put this beastmode in your summary number and choose the count function under the field and function option. I would think that…

Here is the code that I would use let me know if this doesnt work (case when `SHIP_DATE` >= '06/01/2014' and ` SHIP_DATE` <= '05/31/2015' then 'FY15' when when `SHIP_DATE` >= '06/01/2015' and ` SHIP_DATE` <= '05/31/2016' then 'FY16' when when `SHIP_DATE` >= '06/01/2016' and ` SHIP_DATE` <= '05/31/2018' then 'FY17' when…

Could you describe the ETL or post a screenshot? Do you know for certain that this is where the ETL is failing? I am wondering if the failure is happening farther downt he line in the ETL.

My suggestion would use the datediff feature then have that be divided by the number of days in the specific month you want to reference. So I would begin with a beastmode to assign each month how many days are in it. (case when month= 4 then 30 when month =5 then 31 when month = 6 then 30 etc then you could write a…

Here is a link that may be able to help you with some calculations. There are some different options that you can choose from in here. Is this what you are looking for? https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/List_of_Beast_Mode_Comparison_Calculations

Update: Domo support got back to me and advised that they have patched the issue.

You could write a beast mode to bucket dates and would have one that was for previous dates and one for future dates then have them be different colors on your cards. Here is what a beastmode could potentially look like. (CASE when `Planned End Date`-CURRENT_DATE()<0 then 'Future' end) The have another beastmode with the…

Thats perfect thank you so much! I have been pondering over this one for weeks now!

Thanks for your reply. So case pick and order cases are individual fields and I am trying to get the average of each othem in beast mode calculation. So basically it would look like this. CONCAT( ROUND((SUM(case pick calculation) / SUM(order cases calculation))**when channel = 'RET')**100,2), '% | ', ROUND((SUM(case pick…

I am still new to domo so I did not know I could do a MySql with my uploaded data set. I got it figured out with mysql thank you so much for your help!

Thanks for your reply. These two data sets come from excel is there a way to use this function from datasets coming from excel? Thank you!