A simple metric would be a sales column with valid values.
Another would be weekly sales, wich in postgresql would be date_trunc(‘week’,sales).
Or another, monthly sales, etc.
Example of data_trunc usage:
select sum(sales),date_trunc( ‘month’, time_stamp ) from salestable group by
date_trunc( ‘month’, time_stamp );
Is it possible to create this kind of metric? Or using sql maybe?