Comments
-
Heatmap works! Doesn't look the greatest, but it does work well for building out drill down filters.
-
Yep, data structure is flat. The table is using a calculated field to create a column where all the sales amounts are aggregated by month/year. So there is a calculated field for Jan 2018, another for Feb 2018, etc. I agree that I can use a different visualization, but would it be possible to do from a table chart type?
-
Is it possible to have the calculations in a table drill down to the column and a row value? Example: Sales RepJan 2018Feb 2018Mar 2018Tom Cruise$400$300$100Don Johnson$500$100$400 If I clicked on the $300 table cell link for Tom Cruise, the drill down would apply the filters "Sales Rep = Tom Cruise" and "Date = Feb 2018".