marcel_luthi Coach

Working with dates can be tricky, and while TIMEDIFF can work, I've found using UNIX_TIMESTAMP to work best. UNIX_TIMESTAMP(Date1)-UNIX_TIMESTAMP(Date2) This will give you the time difference in seconds, if you want it to be minutes you just divide by 60, for hours by 3600 (60*60) or 86400 (60*60*24) for days. You might…

Thanks, I was talking about the functionality between the two products: Bricks and Variables, so thanks a lot for the clarification. The additional information will certainly come in handy for other use cases.

Hi, I'm new to DDX (started learning this morning) but it seems you can indicate the aggregation you want to use as part of the query. Here they talk about it in detail. But basically if you're using the Query notation, after adding your fields and group by, you can add each agregtion followed by the name of the field,like…

There are several way to approach this, depending on how your dataset looks like and how you're configuring your card. Here is where using the Graph By option in the card can come a long way. You could use the date range by the Commitment Date and Graph by Quarter, to know how many sales you happened on each quarter. Hope…

Thanks for the suggestions, for some reason when I try to use ORDER BY in the FIXED clause, it throws a syntax error. I tried just using the FILTER DENY applied to the same field as the Date Range, and compared it against the value of FILTER NONE when no other filters are applied, and the deny just gets me the value…

Hi @GrantSmith thanks for the answer. Unfortunately the Window function will only look at the items that exist in the time range, and I need to include the values preexisting dates. I could retrieve the grand total with something like: SUM(SUM(CASE WHEN `Milestone` = 'Created' THEN 1 WHEN `Milestone` = 'Done' THEN -1 END)…