Manasi_Panov Contributor

Hi @Kyle McMahon, I don't think this is possible with the available chart types. I'll follow this thread to see if a solution is provided.

Hello @verytiredgirl, You can do it in several steps. Here is the example data: First, make Dynamic unpivot: Split the unpivoted column into two columns: one for dates and one for types: Change the format of the 'Date' column into Date with the Alter Columns tile: And finally, pivot the 'Type' column: Here is the result: I…

Hello @art_in_sky, You'll have greater flexibility in your visualization by using a standard Bar Chart and placing a Multi Value/Single Value card next to it to display the change.

Hello @user060355 Yes, you can use the Domo Dimensions Connector and functions like CURRENT_DATE(), MONTHNAME(), and FIXED BY to calculate by month and identify the current month.

Hi @scpradhan, First, verify if this applies to your data. A quick test is to copy and paste both categories into MS Word or another tool to check for any replaced letters, as in my case. The underlined word is the issue, as the letter "a" was replaced with the Cyrillic "a". You can then create a CASE statement (I'll bold…

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: