Jump to content


  • Content Count

  • Joined

  • Last visited

  1. Much appreciated @Hastur. This script worked perfectly! Sorry I took so long getting back to this.
  2. I am sure this is something easy I am missing, but I can't figure it out. I would like to display somewhere in the pie chart the total number of records In all categories. I do see that I can convert the individual slice values to percentages, but I can't figure out how to display a total number represented in the chart. Is this possible?
  3. Using the CONVERT function to data type Datetime was exactly the solution. I had tried initially but couldn't find any detailed documentation on available data type keywords. Do you know if there is something better that the functions reference on the support site? It seems to be lacking in very many specific details. Thanks for solving my problem. Randy
  4. I have a table updated by a scheduled task from an outside source. Its endDate field (type date/time) is only populated on a few records, with all the others importing empty. I can't change this behavior. I need to be able to filter a data view for records NOT having endDates before a user supplied value, for instance, 1/29/2020. I can't use the imported endDate because most records have no value.... So, I have added a formula field, exitedDate that looks at the end date and copies it to the exitedDate field when not null. If null it writes the VARCHAR '6/11/2020' as a placeholder. I ha
  • Create New...