Manasi_Panov Coach

Hello @Utz, Yes, there are some limitations. This is taken from the Domo support page for Pivot tables:

Hi @Shevy, For charts and graphs, use a separate Beast Mode with the Tooltip function to dynamically switch between %, $, or units.

Hi @Patricia_Zavisky, Yes, they are not recognized as other functions but are working.

Hello @DomoATX, Could you be a bit more specific or share a screenshot? Usually, sorting a dropdown from highest to lowest works fine, even when the data updates. If you change the dataset, as long as the new dataset has the same column name, the sort order sticks.

Hi @Winnie_1234, Yes, this video is the method with the LAG function. The Group and Append method should look like this but you have to adapt it to your needs with month, not year. There are other approaches as well. As far as I know, there is no way to do MoM/YoY in Beast mode if you want to use any Table chart AND you…

Hello @Winnie_1234, If you want to visualize the MoM bit not in a table, there is a convenient way to do it with the 'Variance Bar Line' chart: To display this in a table, you'll need to modify your dataset to include a 'Previous Month Sales' column. This can be achieved during the ETL process using a Lag function or by…

Hello @PJG, I can confirm that it also works with Dynamic Unpivot as well and the result is exactly what you need. The filter may apply to other cards using different datasets, provided they share a column with identical name and values. For example, if both datasets contain a 'City' column with the same name and values,…

Hello @joebenz, Check out this Hands-on video by Dan Hendriksen about Editable Data: Powering Work Lists, Annotations, Approvals, and More. I believe it is relevant to your request:

Hi @DashboardDude, The problem is that I want to see it also on the Dashboard filtering options, not only when the card details are opened.

Hi @jacobslatham, You can utilize the Trellis function in the Bar chart:

Hi @DashboardDude, On the dashboard, the following 4 card types are used: Variance bar line, Grouped bar, Bar, and Line + grouped bar.

Hello @kim_barragan0126, You have to play around with the General, Header Row, Header Column, Total, and Subtotals settings:

@_DanielB_ This should work. I'm using it on many occasions: Value Previous Month: SUM(CASE WHEN YEAR(CURRENT_DATE()) = YEAR(`SALES_DATE`) AND MONTH(CURRENT_DATE()) - 1 = MONTH(`SALES_DATE`) THEN `SALES_AMOUNT` ELSE 0 END) Value Last Fiscal Year Same Month: SUM(CASE WHEN YEAR(CURRENT_DATE())-1 = YEAR(`SALES_DATE`) AND…

Hi @jrtomici, Check this video from Jae Wilson. I think it answers your question:

Hello @verytiredgirl, You can try with nested CASE statements and first check if the current day is the last day of the month: CASE WHEN CURRENT_DATE() = LAST_DAY(CURRENT_DATE()) THEN CASE WHEN MONTH(CURRENT_DATE()) = MONTH(SHIP_DATE) AND YEAR(CURRENT_DATE()) = YEAR(SHIP_DATE) THEN 'sales_amount' ELSE 0 END ELSE [your CASE…

Hi @Chuqi_D, I also used the OpenCage API key, not Google Maps.

Hello @Chuqi_D, Yes, it is working with Domo Jupyter Notebook. Here is the result for some random addresses I picked from Google Maps:

Dear @Chuqi_D, As far as I know, you can't directly call APIs through Domo's Magic ETL. You may use Jupyter Notebook within the Domo environment for that purpose. I tested your code, but it doesn’t seem to be working correctly. I'm investigating the issue and will update you if I find a solution.

Hi @SamanthaC, Yes, this can be accomplished using a CASE statement in Beast Mode. However, the results will be displayed in a column rather than rows. If you provide additional details or a sample dataset, I’d be happy to assist further.

Hello @CRBrown, Providing a sample of your data would be helpful. Based on my understanding of your request, you can use the 'Group' tile to find the MAX('Citation Date') for each location and then join it back to the main dataset. For the second question, the following Beast Mode formula should meet your needs.…

Hi @_DanielB_, I would define a variable with two options: "Selected Customer" and "All Customers." When "Selected Customer" is chosen, the filter card will enable customer-specific filtering. If "All Customers" is selected, filter options will be removed. Calculations and filters will be adjusted accordingly based on the…

Hi @Saaisathish, The bug was related to something on their end. We just received a message that they fixed it without the need to change the app.

Hello @ColinHaze, As a reference, I'm sending the info regarding FIXED function: You can see from the link that FIXED function requires double parentheses. Could you please also try this: SUM(COUNT(DISTINCT DriverID) Fixed (BYMPP_TERMINAL_NAME))

Hi @andyRowan, I'm still trying to find a way to make the final calculation but this is what I got until now: Rank RANK() OVER (ORDER BY SUM(Sales) DESC) Total SUM(SUM(Sales) FIXED ()) isTop10 CASE WHEN RANK() OVER (ORDER BY SUM(Sales) DESC) < 11 THEN 'Top 10' ELSE 'Other' END I still can't find a way to calculate the…

Hello @ColinHaze, Handle cases where the denominator may be zero by using the NULLIF() function.

Hi @Saaisathish, We recently encountered similar behavior in one of our apps while using domo.onFiltersUpdate(). After failing to find a solution, we contacted the Domo Support team. I was informed that there were some related bugs that have since been fixed. You might want to reach out to Domo Support as well, it could be…

Hello @Katrina_Burns, First, check this video from Mark Snodgrass. You can use a Variable to showcase the Rolling Average for all customers or just a selected one. I went a step further and created three variables and now I can see the Rolling Average by country, product, or industry, whether I want the full picture or…

Hello @andyRowan, I believe this video from DataCrew can be helpful: https://youtu.be/-yJXArKUNFo?si=Y63nkca8DMZ_dCS8

Hi @austinisenhart, You can convert 3.36 into separate columns for Days, Hours, and Minutes (e.g., "3 days, 8 hours, 38 minutes"). However, representing the three numbers (3, 8, 38) in a single column without using a string doesn't make any sense. Consider averaging the DATEDIFF as the initial value (3.36) and then…

Hello @Anna_Otake, I believe this is not possible with Beast Mode. ETL should be used to calculate this and create the new columns.