GrantSmith Coach

• Activity
• Posts111
• Comments3.5K

• Re: Text unique values - only count for each option

  GrantSmith

  September 2022
  Having one audience per record. Something like: C-Suite | 19 | Enterprise VP | 19 | Enterprise Director | 19 | Enterprise You could utilize Magic ETL 2.0 formula tiles to use the SPLIT_PART function …
  1

• Re: Count number of character occurrence in string

  GrantSmith

  September 2022
  You can calculate the length of the string, remove the character you want, recalculate the length and take the difference. LENGTH(`Color`) - LENGTH(REPLACE(`Color`, ',', '')) + 1
  5

• Re: Minimum reporting size?

  GrantSmith

  September 2022
  Can you apply an aggregated filter to have count of your metric be greater than or equal to 10? You can set the filter in each of your drill downs to be the minimum value you're looking at.
  1

• Re: Dashboards/Sub-Dashboards Management

  GrantSmith

  August 2022
  You'd have to have an Admin move the pages under the Admin - Pages section to change the parent page of the pages you wish to move.
  2

• Re: Multiple categories on X-axis - really not possible?

  GrantSmith

  August 2022
  It's been around for a while but can be easy to overlook. Glad I could help. If you could accept the answer so others can hopefully find this easier in the future I'd appreciate it.
  1

Next