D-Rab Member

The database reported a syntax error: [Amazon](500310) Invalid operation: Invalid datetime part in DATE_PART(). Details: ----------------------------------------------- error: Invalid datetime part in DATE_PART(). code: 8001 context: query: 8206522 location: datetime That's the error I'm getting. it's from the dayofyear…

select *, date_part(y,"date") as "year", (case when date_part(q,"date") <= 2 then 1 else 2 end) as "half year", date_part(q,"date") as "quarter", date_part(m,"date") as "month", date_part(dayofyear, "date") as "day of year" from "group_by" Date is a date field, not text. It wasn't throwing an error for any of the other…

Yea, I'm the admin so I remove licenses from people as they leave. I guess I can apply a filter to every card using a custom beastmode that just lists ex-employees.

Do you know if there is a way to get a list of active accounts from domo stats? If that's the case, I could simply overlay active accounts with historical data but I don't believe that's available.

How does that find the inactive licenses? I get inactive users as those that no longer log in but I'm referring to employees that once had a license but no longer are at the company and thus the license isn't active.

Totally understand those limitations. 1. we don't use PDP 2. since the base data set will be its own dataflow that can be repurposed I'm indifferent to the other limitation you speak of.

Just current. Historicals don't really matter to current analysis but I have logged historical and current in the past but moving to just current as no one has a need for past book of business.

I'm already appending the base data set on top of eachother. That data will never change. Using data fusion is what i think would make sense for attaching the descriptives that can change over time. Contractual terms, ownership of entity, who is working that account are all things that can change from day to day. 

Anyone have experience using Datafusion?

Just started back up for us about 5 minutes ago. Was crashing for about an hour this morning.

Actually I was able to use a when statement with hour(now()) < 9 since we are pacific time. There doesn't seem to be any other way to do this beyond this work around. 

Yea I was fearing that would be the only solution. It isn't optimal in the least as the column totals is a valuable piece of information