Manasi_Panov Contributor

Hello @verytiredgirl, Could you please try the following Python script: input1['Bill-To'] = input1['Bill-To'].map(lambda x: None if not x else x).fillna(method='ffill')

Hello @Data_Devon, I'm sorry, but I can't help you with your problem but I'm very interested in your idea and the solution you are developing. Would it be possible to share some details and screenshots?

Hello @Ankur, To disable filtering on the table, edit the dashboard, select "Edit Content" on the table, then choose "Change Filter Exceptions" to turn off filtering.

Hi @IgneP, It should also work with nested CASE statements (CASE inside a CASE), but definitely I agree that wrapping CASE in SUM(), as @ggenovese demonstrated, is the best approach. SUM(CASE WHEN…) *2.54

Hello @Chris_Phelan, I believe this is possible if you create an ETL that filters (reduces) your dataset the same way you filter your card and then use it for the PDP.

Hello @skylerh, You probably have to convert the image into vector shapes. This manual may assist you. Tracing an Image — Inkscape Beginners' Guide 1.0 documentation

Hi @M_Gonzalez, Your question involves multiple aspects. To control the information visible to each user, you must use PDP on your card, as this cannot be managed via Beast Mode. Activating PDP will filter rows based on the logged-in user, affecting the total sales formula. To address this, implement an ETL process to add…

Hello @calvert_schaefer, One approach, as suggested by John Le, involves using variables as a solution. However, is you want to compare Fiscal Years, this creates a huge challenge that requires a more complex Beast Mode formula. Another viable solution is utilizing ETL processes to create a column, such as 'Sales_Last_FY',…

Hello @JBerr, Maybe I didn't understand your question, but isn't it possible to just use a simple REPLACE function like this: CAST(REPLACE(Time 1, ':', '.') AS FLOAT)

Hello @Bishwa, Yes, Workbench includes a filtering function. Hover over the Job Name column to reveal the filter icon, then click it to access various filtering options.

Hello @art_in_sky, Is such a message currently displayed? If so, please apply sorting and Change Aggregation settings from here.

Hello @Justinp, Check the Developer Tools in your browser to review the message logged after clicking the Submit button. I encountered a similar issue caused by a minor naming error and this was visible from the recorded error in the Developer Tools.

Hello @ggenovese, It's super nice how a single problem can be approached in various ways. I'm sure we can think of a few more solutions. It's really about @0RNGL4DY and what will be done later with the Beast Mode and visualizations to determine the most suitable approach for his case.

Hi @0RNGL4DY, This straightforward Python method generates the participation sequence, enabling further data visualization or filtering. Here is the output: This was achieved with the following simple single line Python script: #Import the domomagic package into the script from domomagic import * import pandas as pd #read…

Hi @0RNGL4DY, @ColemenWilson, This method is effective only if all "Person" entries attended the A conference. If the first conference is B and you wish to check attendance for C, D, etc., an alternative approach is recommended. I suggest using a Pivot to transform rows into columns, enabling multiple strategies to achieve…

Hello @ColinHaze, Create a Search Variable like this: Create a CASE statement in Beast mode like this: CASE WHEN `Search Filter` = '' THEN 'TRUE' ELSE (CASE WHEN `Lane` LIKE CONCAT('%',`Search Filter`,'%') THEN 'TRUE' ELSE 'FALSE' END) END Add Beast mode formula to ‘Filter’ with the following settings:

Hi @ColinHaze, How about using variables for this with a search field? Would it be a viable solution? Here's an example.

Hello @ColinHaze, The issue likely arises because 'Shipper_City_State' and 'CitySelector' have identical values, causing the 'CitySelector' filter to also apply to this column and exclude all rows where 'Consignee_City_State' matches 'CitySelector'.

Hi @ColinHaze, Could you please show the values in 'shipperCity'?

Hi @alzwang99, You can do it with a simple Python tile and the following single line code (bold): #Import the domomagic package into the script from domomagic import * #read data from inputs into a data frame input1 = read_dataframe('your_previous_tile_name') #write your script here input1['ID'] = input1['ID'].map(lambda…

Hello @phesson, I’m not aware of a direct solution from Domo. It may be best to use Power Automate or a similar tool to download and unzip the file first, then upload it to Domo.

Hi @mcasey02, If I understand correctly, you require a variable filter for the progress bar. Here's an example applied to a bar chart. Here is in more details to visualize the implementation of the variables: Here is the variable: For the x-axis, I have the variable timeframe. In the case of a Progress Bar, I don't think…

Hello @Patricia_Zavisky, Join your dataset with Domo Dimensions Connector from the Appstore to add rows for each month/year, even if the value is 0. Replace nulls with 0 either in ETL or by using Domo Beast Mode with a formula like: CASE WHEN IFNULL('your_column', 0) = 0 THEN 0 ELSE 'your_column' END

Hello @ccccc4, It's a bit complicated and I'll try to explain in detail how I approached this. First, I've created a Variable for the Start Period as follows: I applied the same process for the CAGR end period, defining the start and end years for the calculation. Using these variables, I calculated the CAGR with the…

Hi @art_in_sky, Then you have to use the CONCAT function. Here is a simple example: and the formula:

Hi @verytiredgirl, Create a Radio Option Variable with values 0 and 1, then use a Beast Mode formula. You can then create additional filters if needed. Here is a simple example. This is the dataset: Then the Radio Option variable: The formula: And the result that displays the average values for rows flagged as 0 or 1. One…

Hello @Arthi Annadi, Could you show us the exact format of your numbers, including the placement of % or $ (e.g., before or after)?

Hello @Arthi Annadi, Why not use the Tooltips function to display % or $ on the cards? Here is more info on this topic: https://community-forums.domo.com/main/discussion/comment/97940#Comment_97940

Hi @b_rad Here you go: #Import the domomagic package into the script from domomagic import * import pandas as pd from urllib.parse import unquote #read data from inputs into a data frame input1 = read_dataframe('Domo Forum Answer 2') #write your script here input1['ID'] = input1['ID'].apply(unquote) #write a data frame so…

Hello @b_rad, You can achieve this with a simple Python script. Here's the input: The script: Replace 'Domo Forum Answer 2' with the name of the tile preceding the Python Script tile and 'ID' with the column name in your dataset. The result will be: