Aditya_Jain Contributor

@Zel - We can not take a value from Slicer and assign it to Variable control, but a value selected from a variable control can be used within a beast mode. Please see if this helps

Welcome to the community @scsincla !

For Yesterday's value, you can try the following - (assuming you always want to compare against the current date and not the date from the column) CASE WHEN YourDateColumn = DATE_SUB(CURDATE(),INTERVAL 1 DAY) THEN YourValue ColumnEND Let me know if this does not work!

Hi @MThebeau You may use the Domo Dimension. Go to connectors and type dimension, It should look like the following screenshot

@MThebeau You could try this- CASE WHEN CONCAT(YEAR('YourDateField'),MONTH('YourDateField')) = CONCAT(YEAR(CURDATE()),MONTH(CURDATE())) THEN DAYOFMONTH(CURDATE()) - 'holidaysforthatmonth' ELSE 'your working days in the month' END Try this logic out - this is just the logic part, the syntax would vary based on your dataset…

@Zel Can you do something like- SUM(CASE WHEN Project = 'Maya' THEN (CASE WHEN Action= 'disregard' THEN 1 ELSE 0 END) WHEN Project IN ('US','International','Mendel') THEN (CASE WHEN Action ='email resolved' THEN 1 ELSE 0 END) ELSE 0 END) This should work. Here Project could be variable control or column based on your…

@your_super_shawn https://developer.domo.com/portal/e947d87e17547-domo-js#domofiltercontainer domo.filterContainer() would add a filter on top of the page similar to what chart interactions do. This would then filter your other charts / cards/ apps if that same column is encountered in the dataset powering them. I wonder…

@jaymin_63 Solution offered by @jdorsch2 is cool. In case you do not want to use bricks and if you are okay with the user having to click multiple times, I think similar thing could be achieved using variables , beast mode and pfilter combination. It would have its own limitations as to what could be clickable. But if it's…

Hi @LauraSL , You can use Charts present under 'Gauges' chart types inside Analyser, I prefer progress bar, you could chose speedometers as well. Thanks

@Jones01 - "Manage All Cards and Pages" Will give blanket access to all the cards and pages on the instance. For limited access (access limited to where the person has access to the page/card and/or is the owner then you can try "Edit Pages" and "Edit Cards" option which would allow the users to share the pages/cards they…

Hi @faisalnjit , If you teammate who has created it, makes you the owner of the account, then only it's possible for you to make any changes there. Thanks

Hi @Greg_K I think you can use Pfilters - https://domo-support.domo.com/s/article/360042933114?language=en_US Combined with some logic on beast mode or create an app / brick for the case. Let me know if this works Thanks

Hey @Shahmir5_5_5 looks like you tagged the wrong person 😅 I have personally worked on scripts that hit the Domo servers too frequently but worked all good. I could not find any documentation, but I think writing to the support team could help. It would be interesting to learn if there's any such limit so kindly keep the…

Hi @Jessica Something like this - ["RecordType","TimeSeriesShort","MOLongName","Account Level 9","VAR P-A (A)"] You can try this. Also if this does not work, try removing the () parenthesis from the name, that could also be a possible reason for it to not work. Let me know how it goes. Thanks

Hi @amehdad I think you meant Left Outer Join instead of Inner Join. Rest the solution looks good. Another thing, the formula is a fraction, so I think calculating it on the front end might be a better solution. As the formula might resolve to sum(qty rejected) / sum(qty received) and trying to do it in the ETL might lead…

Hi @chookalien , I have an idea, you can probably use - ddx brick or custom app. Query the domostat / governance dataset to check if the user has access to the required page, if not found, then you can display your custom message. Thanks

Hi @Jones01 Sharing depends on the user's access level, you should be checking what access the user has to confirm if the user can share it further or not.

Hi @faisalnjit Please follow this link - https://knowledge.domo.com/Engage/Sharing_Content_Outside_of_Domo/Using_Pfilters_to_Apply_Filters_from_URL_Query_Parameters_to_Embedded_Dashboards What you need could be achieved using Pfilters, worth giving a try. Thanks

@Jessica Hi, Please try changing the single quotes or ticks with double quotes. This should work. Also, is it a view or a dataset you are trying to build this on? Is it a federated connection? Thanks

@Shahmir5_5_5 - not sure if the limits are mentioned on the documentation page but I have used it to very high frequencies with ease. Are you getting any specific error message while working with the API? Thanks

@Quyen Try creating a View on top of the federated query and join the excel / file upload there in the view. A federated query can not be brought to Magic ETL but for a snowflake, we can have a view ( I think it's still BETA) but it should work. Thanks

@lb1234 Hi, can you please provide a sample dataset with the mentioned columns so that I can test it and let you know a solution.

@Rak Please use the actual Date column as the beast mode that you have written has a concat() around your logic hence it would result in a String. So please form your date and do not put it under concat(). Also if you use Your date column, and try changing the format under general settings, X axis settings, it might work.…

Hi @Rak It seems that your calculated date field is not a 'Date' field yet, it's still a string field and hence won't work with YoY charts. Probably revisit the calculation for 'Date Week' Beast mode, or else put the formula here so that we could help you with it. Please ignore this comment Regards Aditya Jain

@lb1234 Apologies for late reply on this calculation, not going into the correctness of the formula, but trying to resolve divide by zero COUNT(DISTINCT `Task.ActivityID`) / (COUNT(DISTINCT (CASE WHEN SUM(`Is Setter`) = 0 THEN `Setter.FullName` END)) OVER (PARTITION BY `Setter.FullName`)) I assume this is part of a case…

(CASE WHEN YEAR(`firstorderdate`) = YEAR(TODAY()) THEN CONCAT('New Customer ',YEAR(`firstorderdate`)) WHEN YEAR(`firstorderdate` ) = YEAR(TODAY()) -1 THEN CONCAT('New Customer ',YEAR(`firstorderdate` )) ELSE 'OLD Customer' END ) Hi @zuchu - please try the above pasted code, this would be dynamic, so for current year, it…

Hi @lb1234 , Assumption - The 3 columns "Pull Date" (A), "Setter"(B) and "Total Sales Last 30 Days"(C) are coming from the ETL. What I understand from the example is, if the count of "Total Sales Last 30 Days" is greater than 0, it should not be counted. Which conversely means, if there was no sale in the past X many days,…

Hi @OlaBola , You can use https://api.domo.com/v1/datasets/{DATASET_ID} end point to get the schema of your existing Domo dataset. Once you get the schema, compare it with you new dataframe which you are trying to upload, if it does not match, execute the update statement which would reset / update the schema and load the…

Hi @Rohit , May be you can do this on HTML instead of Domo. Add an anchor tag on the HTML element where you are adding your Domo everywhere iFrame for card2, that would also help. Thanks Aditya Jain

Hi @Benjamin You can do this by going to the beast mode manager. Click on Data Center, on the left, lookout for Beas Mode manager On the Beast Mode manager page, on the left pane, just type in your beast mode name, select the beast mode, and on the right hand side wrench icon, select duplicate to dataset. Choose your…