art_in_sky Contributor

@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?

@ggenovese by default the dataset has PDP all data access to dataset owners and admins. Does that mean we cannot set the PDP filters to Admins?

@ColemenWilson @ggenovese Thank you for your responses. I came across PDP and Publication Groups. Which one would be a better option?

@ArborRose Thank you!

@ColemenWilson Thank you!

I am embedding the card

yes, attached screenshot for you

I am doing public embed if a dashboard app

@ArborRose Thank you for sharing!

@ArborRoseData gets collected via API. I restarted my system and checked , it got updated.

@kelly_tagtow You can change the name of the column by going to Admin-Governance-Toolkit and select your dataset to edit as shown below. you should be able to change the name of the column here.

@ArborRoseIt worked when I used appData= Salt+Lake+City as parameter

@ArborRose Would be able to join a quick call so that I can explain my issue? I have tried all ways to collect the query params and it returns null value everytime.

@ColemenWilson Thanks

@ArborRose I tried using text classifier before import and domo recognized it as text column. later I replaced the text and used it as text column. My issue is resolved now.

@ColemenWilson Thank you for joining the call and resolving it!!

@ColemenWilson I rejoined the meeting