-
Re: Calculating Average Time Between First/Last Login
Hi, If I correctly understood your problem, here's the approach I would take. It involves creating a MySql Dataflow like this (you can use this directly on the output if you do not have other transfo…1 -
Re: SQL dataflow help
Hi @wgechter, It's strange, the first approach runs for me. The following example table : Using the following query : Select * from tst_dj_clients_poc WHERE `Client Name` NOT IN (SELECT `Client Name`…1 -
Re: HTML in Summary Number
Beware of using concat's in summary numbers if you want them later to be imported by Powerpoint Plugin. It doesn't import summary numbers originated in concats.2 -
Re: Transform Saved Wrong
Hi, Great question @ST_-Superman-_. I do think that "generate output table" only applies in DQL (Data Query Language) commands. Being "CREATE" a DDL (Data Defenition Language) com…1 -
Re: Sort Table by Field Count
Ok , So, I think that in a datatable you will only have the aggregation enabled in the sorting section if there is at least one aggregated field (with a calculation other then no aggregation) (even t…1