Manasi_Panov

Hello @ggenovese, I wasn't aware that TIME_TO_SEC() functions with text format. I thought it only accepted a Timestamp format. I've verified that it does work. Thanks for the clarification. Yes, this is a much cleaner and easier solution!

in Convert time to decimal Comment by Manasi_Panov October 23

Hello @kim_barragan0126, If I understood correctly, this is your initial column, right? Either way, sure you can do it in various methods using CASE logic in Magic ETL. Here is one that I did for you with a Formula tile: Here are the results:

in Can I move a variable to one column from another? Comment by Manasi_Panov October 23

Hi @JBerr, Certainly! You can convert it using Magic ETL using various methods. Here's one example to convert recorded time into seconds with Formula tile: SUBSTRING(Time, 1, 2)*3600 + SUBSTRING(Time, 4, 2)*60 + SUBSTRING(Time, 7, 2) This is the result:

in Convert time to decimal Comment by Manasi_Panov October 23

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.

in Is there a way to include a series in a period over period chart type? Comment by Manasi_Panov October 17

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…

in Unpivot Comment by Manasi_Panov October 11

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.

in Changing the bar height and size for Spark Bar Charts Comment by Manasi_Panov October 8

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.

in Number of business days in the month Comment by Manasi_Panov October 8

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…

in Can I know why the data is not grouping into single column in the pivot table? Comment by Manasi_Panov October 8

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.

in Can I know why the data is not grouping into single column in the pivot table? Comment by Manasi_Panov October 8

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

in Can I know why the data is not grouping into single column in the pivot table? Comment by Manasi_Panov October 8

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:

in Extra 0 bar in bar chart with beast mode Comment by Manasi_Panov October 8

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.

in Can I know why the data is not grouping into single column in the pivot table? Comment by Manasi_Panov October 8

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,…

in Number of business days in the month Comment by Manasi_Panov October 7

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:

in How to compare to the entire dataset, and not just the filtered part of the card? Comment by Manasi_Panov October 7

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:

in One SKU has multiple mail date and trying to filter out all skus that have date greater than today Comment by Manasi_Panov October 6

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:

in How to compare to the entire dataset, and not just the filtered part of the card? Comment by Manasi_Panov October 6

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)

in I want to calculate the percentage difference between Qtrs in Pivot table Comment by Manasi_Panov September 25

Hi @ColemenWilson, Thank you!

in Sharing Alerts without Inviting to Domo Comment by Manasi_Panov September 24

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.

in Formula to calculate date of Monday of previous week Comment by Manasi_Panov September 23

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?

in Sharing Alerts without Inviting to Domo Comment by Manasi_Panov September 23

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.

in New Calculated Field isn't saving. Uncertain of next steps to save. Comment by Manasi_Panov September 22

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.

in Pivot Table More Months Comment by Manasi_Panov September 22

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.

in Alter Column: file to convert type String to Date Comment by Manasi_Panov September 22

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:

in Alter Column: file to convert type String to Date Comment by Manasi_Panov September 20

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…

in Alter Column: file to convert type String to Date Comment by Manasi_Panov September 20

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

in P&L Card - Pivot Table Comment by Manasi_Panov September 19

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.

in Pivot Table More Months Comment by Manasi_Panov September 18

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…

in Month filter not working on all cards in an App? Comment by Manasi_Panov September 18

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

in Beastmode to return current month value? And what's the best card type to show the variance? Comment by Manasi_Panov September 13

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?

in Beastmode to return current month value? And what's the best card type to show the variance? Comment by Manasi_Panov September 13

Manasi_Panov Contributor

Comments