Column With Custom Fields to Reference in Beast Mode?

I would like to generate a custom column from a list of strings that I can then use to reference in Beast Mode.  I am basically trying to generate a view analogous to the one below in Domo.  Obviously, one can simply input values into a cell in Excel, but I need a workaround to generate those values as a column so that I can spit out an aggregation for the current and previous year based on the metric listed in column A.

Answers

  • @swadds Without knowing how your current data is structured, I would recommend creating a beast mode to represent each individual metric and adding each of those as columns to a table card along with a column to represent the fiscal year. You can then transpose the table using the General chart properties so that it is formatted like your screenshot above.