Best Of
Re: Beast Mode Fix?
COUNT(DISTINCT(CASE WHEN `credit score` < 660 THEN `loan id` END)) / COUNT(DISTINCT(`loan id`))
Keep date as x-axis and then drag this to y-axis.
Re: Beast Mode Fix?
Not sure if you'd already tried this, but you could just use the 100% stacked bar chart type.
Re: To be able to filter in the Webform while in edit mode.
I agree, having the ability to filter the rows when in edit mode would be very beneficial.
Ashleigh
Re: Fill empty columns based on values in other columns
This is best accomplished in a dataflow. Using magicETL you can use the group by tile and group by ID for the field Email and select the first non-null value option, then, with 1 email per id from the output of that tile, you can join that with you data on the ID field. Let me know if you have any questions!
Re: Beast Mode calculation
I would do it in a dataflow. In Magic you would use the formula tile to get the flag on rows with a 100 in them and then use the group by tile to group on SO # and then join on SO # back to your granular data. Then you'd have a flag for each SO # that has an order product in it with 100 as shown in my last screenshot above. See below and let me know if you need more details:
Re: Mass Dataset Name Changing
You'd need to write a script in something like Python to query all your datasets and then update the name / descriptions. There isn't an easy way within the UI. You can use the pydomo package to do this.
Re: Rank and Window? Lag?
The Lag function should be used to add a column to hold the prior quarter expenses. In your first screenshot, name your new column "Previous Quarter Expenses" (or something similar), change the function drop-down to "Lag", run the function on your current quarter expense column, with an offset of 1.
Once you've created this column, then I would add your variance calculation as a beast mode in your card like this:
(sum(`Current Quarter Expenses`) - sum(`Previous Quarter Expenses`))/sum(`Previous Quarter Expenses`)
