Neeti Member

Hi @user14700 , Please read below, it may help you: https://dojo.domo.com/t5/Domo-Developer/Domo-alerts-to-Slack-using-Tray-io/m-p/47245#M1447 **Say "Thanks" by clicking the "heart" in the post that helped you. **Please mark the post that solves your problem by clicking on "Accept as Solution" Regards, Neeti

If this solves your problem: **Please mark the post that solves your problem by clicking on "Accept as Solution" Regards, Neeti

Hi @Khan_Naziya , Even I had faced the same issue in past, after my investigation I have found that it was once because of code issue in sql procedure. Second time DOMO was not responding, because the server was down. I have to close the workbench instance and again ran the job. I would suggest you to just debug the source…

Hi @DaniBoy Thanks for the reply. I have completed : Domo Accreditation, Professional Services Certification, Technical Certification These are the badget I have received so far. Thanks,Neeti

Hi @avataraang , I have tried and its not cutting from workbench side, you can even try with some dummy data and dummy string. **Say "Thanks" by clicking the "heart" in the post that helped you. **Please mark the post that solves your problem by clicking on "Accept as Solution" Thanks, Neeti

HI, You can try color rules also, which will either change cell color or row color, based on your selection in color rule window. I have tried this on both pivot and normal table. Also, SUmo table will have more effective color rule implementation. Did you try sumo tables? Thanks, Neeti

Hi, Thanks for the response. I have already tried and that is working, but my expectation is dynamically if it is possible, may be while interactive with other cards? Thanks, Neeti

Hi, In my knowledge, write to a dataset or preparing a dataset is up to the conditions you have mentioned while creating it. If its from workbench, and you have given code in source tab, coming from some SQL statement(using views or procedure) you can add condition to pull one record at time and schedule it every minute or…

You can also try: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns

Hi, It also happens sometimes when you publish to the web link. Try checking if all the colums are enabled and visible not hidden. Alternative solution is you can get all rows in a table by exporting to PowerPoint. If you only have less columns(say 4) to display on the scheduled report, try… Font Size -> Smallest Allow…

Hi, You can create beast mode as below which works row wise, beast mode is nothing but creating a calculated filed: 'Current Week' - 'Previous Week' Drag the calculated filed in your pivot table to see the result. **Say "Thanks" by clicking the "heart" in the post that helped you. **Please mark the post that solves your…

Hi All, Is there any confirmation on this quite old thread? Thanks, Neeti

Hi, May be you can lock your datatype in workbench or can use ROUND function to get the desired output. You can try below option in ETL or beast mode as well : https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Formatting-Multiple-Summary-Numbers-with-Commas/m-p/32344#M4834…

Hi, I have read below articles/queries on dataset connectivity, and federated data solution. Please check if this helps you. https://dojo.domo.com/t5/Domo-Developer/How-to-extract-a-certain-dataset-directly-into-MS-Power-BI-tools/m-p/42931…

Hi, I have read something related to limit rows, please check if this helps you. https://dojo.domo.com/t5/Domo-Developer/Configure-tab-is-missing-in-preview-dataflow/m-p/45246#M1382 https://dojo.domo.com/t5/Domo-Developer/How-we-can-limit-the-number-of-rows-in-api-call/m-p/39392#M1094 **Say "Thanks" by clicking the heart…

Hi, I have found something on case-sensitivity. Check if you can do this way? https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Return-Capitalized-UPPER-or-CamelCase-Characters-in-Column-Names/td-p/34418 Please linke if it gives you any help. **Say "Thanks" by clicking the heart in the post that helped you. **Please mark…

Hi @user11590 I dint understand the statement and the condition provided by you in below case. I could see `Total Retail Change $` is same in both the condition. please repharase is cleary, so that I can try to help you on this. Below case for you refrence: SUM(CASE WHEN `transaction_type` = 'Actuals' AND ( (…

@MichelleH Allrite!!! May be you can have check with your network firewall team as well, It might be blocked from them. Also, do reach to DOMO admin if above doesnt work. Regards, Neeti

@DaniBoy Thanks for your reply. Learning history, in the sense, what I have watched as a knowledge sharing video or what all I have read in DOJO or knowledge based article. Its over all my browing/learning history in DOMO. Thanks, Neeti

Hi, I have read one article on left join on SQL Data flow, I am not sure if you are looking for the same. Do read below article, see if this helps you: https://knowledge.domo.com/Prepare/Magic_Transforms/SQL_DataFlows/Optimizing_an_SQL_DataFlow Do give a like if this helps you. Thanks, Neeti

Hi, Try reading below article https://knowledge.domo.com/Engage/Sharing_Content_in_Domo/03Exporting_KPI_Cards hope this will help. Do give a like if this helps you. Regards, Neeti

Hi, Read below article this will help you to build pivot table: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Pivot_Table_-_BETA Do give me a like if the above is useful. Thanks, Neeti

Hi, You can either use BEAST mode CASE statement or even MAGIC ETL(if applies to)-> REPLACE TEXT. CASE statement as below: ( CASE WHEN 'ID' IS NULL THEN 'ANY OTHER VALUE' ELSE 'ID' END ) Hope this helps!!! Thanks, Neeti