Manasi_Panov Coach

Hi @verytiredgirl, The current month is 9. From what I can see from the table, there is no data for the month of September. Could you please check?

Hello @verytiredgirl, There are no issues visualizing the Current Month Target and Actual. If you have data spanning multiple years, please include the year in the Beast Mode formula. Examples are provided for reference: CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN Actual ELSE 0 END and CASE…

Hi @verytiredgirl, Create a new column from the 'Date' in Dataset 2 using the specified formula: MONTHNAME(Date) This will extract the full month name from the 'Date' column. To format it as a 3-letter abbreviation for example (e.g., Feb, Aug, Sep), use: SUBSTRING(MONTHNAME(Date), 1, 3) The format of the Month column…

Hi @kim_barragan0126, You can replace Null with 0 with the following formula: CASE WHEN Total Billed IS NULL THEN 0 ELSE Total Billed END An alternative approach is to use Value Mapper:

Thanks for the shoutout @anna.yardley I can’t believe I’ve been selected as Member of the Month! This is such a surprise! This summer, I visited Amami Oshima in Japan and also made a brief trip back home to Bulgaria.

Hi @Josh_Evans20, Here's an example of calculating the percentage difference in Beast Mode: (ZZ_VALUE_THIS_M-ZZ_VALUE_LAST_M)/((ZZ_VALUE_THIS_M+ZZ_VALUE_LAST_M)/2) This month's turnover (ZZ_VALUE_THIS_M): SUM(CASE WHEN YEAR(CURRENT_DATE()) = YEAR(Date) AND MONTH(CURRENT_DATE()) = MONTH(Date) THEN Parts Kits Value ELSE 0…

Hello @Josh_Evans20, I couldn't achieve this with the Flex table, but it's possible with other cards like the Mega table, Line graph, Bar chart, and so on. In all instances, you'll need to perform your Difference calculation in Beast Mode and then filter based on the created calculation field.

Hi @bradtk11, You can select the "Use transparent background" option, or alternatively, adjust the Width and Height of the card in the Advanced Image Settings to minimize the blank space.

Hello @Mansa_TCC, If the title in Portuguese or Spanish contains only standard English letters, this might be why you can't filter them. This can be done with Domo Jupyter if you have access to this function. Here is the script: pip install langdetect from langdetect import detect #Function to detect language def…

Hi @STEVE T, I used DDX Brick for a similar project. You might find this video useful, as it explains the implementation in detail: https://www.youtube.com/watch?v=eLfWHpQqwbA In the video, it's demonstrated as a comment field, but you can easily modify it to suit your needs. The key point is that it allows direct writing…

Hi @miguel_bustamante, What about using Tooltips? As shown in the screenshot, you can toggle between different currencies (in my case) and display the selected currency directly on the chart. I can also switch between Value and Quantity. You can adapt this in your scenario to switch between units and percentages. Please…

Hello @Jbrorby , I had a similar problem to solve in the past. I was able to do it with a Python script in ETL: Here is the result table: Copy and past this in your ETL to find the solution and the Python script: {"contentType":"domo/dataflow-actions","data":[{"icon":"python","name":"Python…

Hello @Kanokkarn , If the calculations are done in ETL, then you can do what you've described. However, I’ve never been able to do it when the calculations are in Beast Mode. Example when Turnover Type was calculated in ETL: Example when Turnover Types are done in Beast Mode:

Hi @Lu_zhang , If you are inquiring about the location of the Python/R tiles within ETL, it appears that based on the screenshot you provided, you do not have access to them. They should be located under the Scripting section.

Hello @calebtyrone , Instead of applying a filter, you can create a variable that displays the necessary supplier information on all cards. I believe there may be a workaround to highlight only the section from the selected supplier, but further investigation is required. I quickly put this together—it may not meet your…

Thank you, @GrantSmith, for your answer. My goal is to replicate a table that was previously used by management in Excel, so they can easily recognize it and transit to using Domo. In addition to the dashboard, I have included different visualizations, drill-downs, filters, and variables to make the information more…

@GrantSmith At the beginning, there was a syntax mistake. I attempted the suggestion provided by @ST_-Superman-_ which resolved the syntax error and the formula is working. Thanks!

@colemenwilson I appreciate the suggestion of utilizing ETL, but it isn't suitable for this particular situation. The primary objective is to analyze and compare the Skill Levels of technicians or groups of technicians across various regions, company branches, and countries, considering different products and product…

Hi @MichelleH , I found the problem. The "empty" cells were not exactly empty. There was " " in them. But now I'm facing another problem :) In cases like this one: I got:

Hi @MichelleH , Actually, I think I was able to do it your way, but I still, have some issues. Here is the result for one Order: I used the LAG function to create the "Previous Service Order" based on the "Service Order" and then used the LAG function again to generate the "Work Type Temp" from "WG Combi". Then, I used the…

Hi @MichelleH Thank you for your input, however, I have some concerns. Firstly, I think I require the LAG function instead of LEAD since I want to compare the Order of the previous row, correct? The second problem is that the Work Type column doesn't exist. The formula with the logic I shared in Excel is creating the Work…