I'm looking to create a customer map where each customer would show as a pin on the map. Clicking on a pin would display customer info & YTD sales. New app?
I currently have a beast mode calculation for the hour DATE_FORMAT(`created_time`, '%l %p') I would like to subtract 6 hours from the UST time to arrive at CST