Column With Custom Fields to Reference in Beast Mode?

swadds
swadds Member
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.

image-828f2bc3efab-6fe6.png

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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.

    image.png

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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.

    image.png

Categories