-
measuring cross-purchase with purchase category in both row and column
I'm trying to create a table that shows cross-purchase with customers, so what customers who purchased in one value of a dimension also purchased in a different value of the same dimension. Kind of like those old distance charts that have different cities plotted against each other on x and y axis, with the count of…
-
beast mode processing limitations
Our Domo instance is limited with federated data, but I noticed I can create case statements in beast mode to create a new field with associations with case statements. For example, I can map customers to an account manager with a statement, e.g. (CASE WHEN `Customer` = 'Joe Harris' THEN 'Mark Smith'), and I can use that…
-
Beast mode for rolling count of purchasing customers within a specified period month over month
I'm trying to develop a beast mode formula to help me derive count of customers who have purchased within the last 30, 60, and 90 days, which rolls month over month. For example, the count of patients who have purchased within 90 days prior to September, within 90 days prior to October, and within 90 days prior to…
