-
Pivot Table Coloring
I have a very simple question that is proving very tricky to work through. Given the following Pivot Table, I am just trying to highlight the "Actual" based on whether or not they hit their "Goal". Basic Color rules have not been working since you can't color a column based on another column. "Apply to Full Row" does not…
-
Pivot Table Grand Total
When I add the "Total Row" to a pivot table, it does not always show the "Grand Total". If the column has an aggregation applied, then the Grand Total shows the aggregation (Average, Maximum, Minimum, etc.) instead of a Total. Is there a way to show the actual "Grand Total" (aka the sum of the values) rather than the…
-
Preferred format of Datetime Column uploaded via Python (domojupyter)
Is there a Date Format that will allow Pandas to upload a date or datetime column and have Domo recognize it as such? I have tried ISO ('%Y-%m-%dT%H:%M:%SZ'), Datetime64 (timezone aware and unaware), etc. but all columns appear with Column Type as Text in the domo dataset. Any advice?
-
Waterfall/Retention Ratio in Beast Mode
Here’s the situation I’m in: Let’s say I’m trying to create a visualization for hiring positions for a team. The dataset I’m working with has each observation as an interview. So the columns of the dataset would be something like: Name, Gender, Location (State), Education Level, Interview Round. Interview Round is one of…
-
Beast Mode - Refer to Other Segments in Case Statement
Basically, what I'm looking to do is create a percentage column in the dataset. For example: Let's say I have some shapes: 'Rectangle', 'Square', 'Small Square' How would you go about creating a variable that shows the percentage of that shape as compared to the next largest category of shape? For example, the column would…
