GrantSmith Coach

• Activity
• Posts111
• Comments3.5K

• Re: Add a column to capture percent of total value for adjacent column

  GrantSmith

  January 2023
  Fixed function is your friend here. SUM(`Visitors`) / SUM(SUM(`Visitors`) FIXED ()) https://domo-support.domo.com/s/article/4408174643607?language=en_US
  1

• Re: Year-over-year sales chart by month

  GrantSmith

  January 2023
  Try pivoting your data so that you have a year column, month column and a value column. Then you can use the Month as your x-axis and the year as your series with the value as your y axis.
  2

• Re: Dashboard on dashboards/cards

  GrantSmith

  September 2020
  Hi @nj-John-mirc I've created some inventory pages utilizing the Data Governance datasets. Specifically I have a list of all of the dataset within our instance, show their name, description and …
  1

• Re: Dataset View

  GrantSmith

  January 2023
  Views aren't scheduled to run, they're run when they're accessed. They're not materialized / saved in an actual dataset. If you're looking to materialize the view and store t…
  2

• Re: First Word Grouping

  GrantSmith

  January 2023
  You can use the SPLIT_PART function. SPLIT_PART(`Name`, ' | ', 1) This will get the first value in your string split by the ' | ' delimiter.
  2

Next