I am trying to create a Table Card in DOMO which displays each Salesperson on the team in rows with Average Leads/Mo., Average Demos/Mo., and Average Sales/Mo. going across in the columns. What I'm trying to do is get each column to shade green when they are above the team average, and red when they are below the team average. Complicating matters is that at the page level I have a Date page filter which can be used to update the data to display MTD, YTD, etc. When this is changed the Average values for Leads, Demos, and Sales for the specified time period change and I'd like the shading of the table card to reflect that. This is where I am getting stuck. I have tried setting the Color Rules using above/below Average but the calculations are a) Static and always calculate off the full dataset, and b) includes values from "Old" Salespeople who I no longer wish to include. I don't think a Heatmap Table works either because that heatmaps off of all columns and not each individual columns. Any ideas on a BeastMode I can use to accomplish this or is something going to have to be done at the ETL/SQL level? I know DOMO tries to discourage the use of Table Cards, but the person this is being built for really likes them. Thanks!
