Manasi_Panov Contributor

Hello @scpradhan, If it is not the SQUASH_WHITESPACE() function on the 'Category' column, then could the issue be related to keyboard or language settings affecting categories names when they were created? In a test I conducted, replacing some Latin letters with Cyrillic letters resulted in unexpected grouping behavior.

@scpradhan The same issue is also visible for other categories: Is there a Beast formula behind 'Store Visits'?

Hi @rupinderkaur87, First, you have to Unpivot in ETL. Then It should work with a simple COUNT. Here is the same table: Dynamic Unpivot in ETL: Result table: Bar chart:

Hello @scpradhan, Consider using the SQUASH_WHITESPACE() function in the ETL process to address potential discrepancies like "Backpacks/Bags" vs "Backpacks/Bags " with space at the end.

Hi @user060355, You can create a CASE statement in Beast mode (my 'date' colum name is 'submitted at'): CASE WHEN DAYOFWEEK(submitted at) = 1 OR DAYOFWEEK(submitted at) = 7 THEN 0 WHEN DAYOFWEEK(submitted at) = 2 THEN 0.5 WHEN DAYOFWEEK(submitted at) >2 AND DAYOFWEEK(submitted at) < 7 THEN 1 END Here are the results,…

Hi @ljb18, On the top right corner of the dashboard: then "Edit Dashboard": then your filter card should have this "Edit Content" button: Change Interaction button should be there:

Hello @Utz, In ETL, group by the maximum 'MailDate' and join on SKU to obtain the latest 'MailDate'. Use your CASE statement on this result. Here's a similar example of this approach:

Hello @ljb18, You can potentially disable filter interaction on this card, thereby preventing issues where applying a filter may cause your formula not to work. Change the setting from "Apply to all cards" to "Apply to selected cards." Deselect the card you don't want the filter to apply to:

Hi @gokul, Could you please share the formula you are using for "% for col total"? In general, you can use CASE logic like: (CASE WHEN QUARTER(Date) = 2 THEN "% for col total" ELSE 0 END) - (CASE WHEN QUARTER(Date) = 1 THEN "% for col total" ELSE 0 END)

Hi @ColemenWilson, Thank you!

Hello @michaelg25, You should be able to do it with HTML Build-in Summary number like: CONCAT('As of ', DATE_SUB(CURRENT_DATE(), INTERVAL (CASE WHEN DAYOFWEEK(CURRENT_DATE()) = 2 THEN 7 ELSE DAYOFWEEK(CURRENT_DATE()) - 2 END) DAY), ' Total amount is ', SUM(1)) Change SUM(1) with any calculation you want to see as a summary.

Hi @ColemenWilson, The admins who can create the social users have the option to disable the "Welcome to Domo" e-mail? Could you please share a screenshot of that function?

Hello @DeborahAnderson, I've encountered this as well. After clicking "Create Calculated Field" and then "Save Calculated Field," if I copy text from the formula or name, or switch tabs, I sometimes get a warning about unsaved changes. I typically just ignore it or save again before closing.

Hi @Josh_Evans20, I'm not certain, but there may be an issue with division by zero, or the values in the dataset could be Null rather than 0.

Hi @verytiredgirl, In this case, after performing the Dynamic Unpivot, you'll need to spend a bit more time creating a formula tile to convert 'FEB POINTS' to '01 Feb 2024', 'MARCH POINTS' to '01 Mar 2024', and so on. Then, change the format of the 'Date' column to Date using a Formula or Alter Column tile.

Hi @verytiredgirl, Could you please take a screenshot of your initial dataset columns? If you have other columns, then Add Constant is not needed. Just add all the columns you don't want to unpivot here:

Hello @verytiredgirl, Why don't you try Dynamic Unpivot instead of Unpivot? If your data initially includes columns for Jan 2024, Feb 2024, Mar 2024, and Apr 2024, start by Add Constant tile, then perform a dynamic unpivot. Here's an example: Initial Dataset: Magic ETL: Add Constant tile: Dynamic Unpivot tile: Result: Then…

Hi @gbrown, There is a nice tutorial on P&L topic from DataCrew: https://youtu.be/YgevJkjeFqw?si=9lZ0iz0ptyPHiIRz I hope this helps.

Hi @Josh_Evans20, Please review for any applied filters or sorting. Identify if there are columns displaying ### in red. Are you using any Beast Mode? If you provide a screenshot with a little more information it would be helpful.

Hello @verytiredgirl, Yes, Magic ETL is the easiest solution with a Formula tile using this formula: MONTHNAME(Date) - for extracting the months as text; or MONTH(Date) - for extracting the months as integer; If you have the Month as an integer you can use the same CASE statement in ETL. Instead of relying on Beast Mode…

Hi @verytiredgirl, I'm glad I could help. You can simply adjust the Beast mode subtracting 1 from the CURRENT_DATE() or use the SUBDATE() function: CASE WHEN Month = MONTH(CURRENT_DATE()) - 1 AND Year = YEAR(CURRENT_DATE()) THEN Actual ELSE 0 END

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…