art_in_sky Contributor

@andyhicken Apart from using text classifier, below one could also help "Under Admin > Toolkit, there's a scheme management capability to modify a dataset's field types. But I use it as a last resort; when I can't seem to get Domo to accept my field types on import."

@B_arnett_1_9_8_8 Is there any date column that distinguishes the tags as empty or most recent, If so, apply the date column as filter and select the most recent date that has the most recent current tag. Correct me if I am wrong.

Noted, Thank you!

@DanHendriksen Thank you!

@B_arnett_1_9_8_8 Add a filter to show only lines that have the currently assigned tags ( most recent) to your datagrid.

@ArborRose This worked when I created separate formulas instead of aggregating at Dataset level and applied the aggregation in beast mode.

@ArborRose I tried creating 'total rating' calculation at Dataset level in Magic ETL, However , it throws the below error 'Aggregate functions are not allowed in this context'

@Manasi_Panov Not that, I am using the below calculation total rating= SUM( CASE WHEN Leverage Ratio values >= 61.00 THEN 1 WHEN Leverage Ratio values >= 40.00 and Leverage Ratio values<= 60.00 THEN 2 WHEN Leverage Ratio values >= 0.00 and Leverage Ratio values<= 39.00 THEN 3 ELSE 0 END + CASE WHEN Cash on hand values <=…

Do I need to create multiple cards/apps based on the filters to embed? Or , Is there a way to do this all at once and share the separate URLs based on the filters?

@Jones01 Thank you!

@Jones01 Yes I did observe that, However I am not embedding my card and want to have the export button within the app/dashboard instead of making users navigate to find the export option.

@Jones01 Do you have the source code for HTML brick, to enable this export function for cards with Export button?

@ArborRose How would I be able to achieve it through custom card/ App?

@MarkSnodgrass Thank you! This one is hopefully resolved.

@MarkSnodgrass I created individual risk indicators (Beast Modes) for 'Low,' 'Medium,' and 'High' using OR conditions and added separate slicer cards for each risk. However, when filtered, the slicers display 'Null values' with the 'selected values' language. Is there a way to remove this language and display the slicer…

@MarkSnodgrass 5 COLUMNS- IF ANY COLUMN HAS LOW RISK THEN DISPLAY UNDER LOW RISK MEDIUM RISK- IF ANY COLUMN HAS ATLEAST ONE MEDIUM RISK, THEN DISPLAY UNDER MEDIUM RISK SAME FOR HIGH RISK Rows displayed under high risk can be displayed under low risk and medium risk as well if they have atleast one such indicator

@MarkSnodgrass When I reorder them by low risk, high risk. Wouldn't the low risk rows stop getting evaluated when checking for high risk? For instance my condition is to check if it evaluation meets true for any of the conditions among five columns.

@Manasi_Panov Thank you!

@ColemenWilson @Data_Devon I wanted to pivot a column's values as columns and use text values from a Beast Mode calculation in the cells. Since Pivot Tables 'values' require aggregation, I applied MAX to my Beast Mode and it worked for me. Thank you so much for your assistance, and I apologize if my question was not…

@ggenovese yes, the color rules are limited though.

@ggenovese This worked, thank you so much! Is there any way to color-code the cells based on the calculation or display the values when hovering over a cell in the Pivot Table? I can now show the text in the cell, but I also want to display the actual value and the range it falls under when hovered over.

However, it will only let me use the numeric values as values and not the text values.

@ColemenWilson @Data_Devon The reason I want to use text as values is because I have set up a column values as columns in pivot table, and i want to show color risk indicators that are based on the formula to see how they are spread across each row.

@Manasi_Panov I used the tool tips and variables and it worked. However, If I have to use it together for a table chart as a column ( how can i achieve to show the units next to the my column values)?

@Manasi_Panov @GrantSmith This has been fixed, I used replace text, string operations and regex formula, cast and it worked. Thank you all for your help.

@Manasi_Panov It worked. Thank you so much!!

@ColemenWilson I am using a text column that indicates everything in the data set such as xx%, $xx. However, it only indicates the numeric numbers in the charts, i tried using beastmode to concatenate the text with $ or % , it throws me a syntax error

@ColemenWilson Here you go , I have set the bar width as 100 and this is how it looks s

@ColemenWilson This one I tried, however it adjusts the width of the bar but not the space between the grouped bars.

@Anna_Otake Is this live yet?