コメント
-
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:
-
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!
-
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:
-
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:
-
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.