GrantSmith Coach 
-
Re: Is this doable? Seeing percent of total day sales by hour using Timestamp column.
Hi @DANIH Have you tried a window function with a case statement since you're attempting to only look at data from today? Last Year: SUM(SUM(CASE WHEN DATE(`Timestamp`) = CURRENT_DATE - INTERVAL…1 -
Re: Is this doable? Seeing percent of total day sales by hour using Timestamp column.
@DANIH Do you have some sample anonymized data I could play with?1 -
Re: Converting Time zone with day light saving
Hi @User2021 Instead of CST I'd recommend using the country/city name like this: CONVERT_TZ(`DateTimecolumn`, 'UTC', 'America/Chicago') You can use this in either a Beast Mod…3 -
Re: Converting Time zone with day light saving
How is it not working? What are you getting? What are you expecting? Domo will convert your TIMESTAMP fields when a card is displayed to whatever time zone your instance is configured to.1 -
Re: Historic Gas Price Datasets
I'm not aware of one that's broken out per state in a single dataset however some states websites may have this information. You could also search through data.gov which has some state leve…1
