entrouvert
/
publik-bi
Archived
17
0
Fork 0
Code Issues Pull Requests Releases Activity

bijoe: generate isoweek dimension for date dimension

This commit is contained in:
Benjamin Dauvergne 2016-05-25 10:33:57 +02:00
parent 36f350cc01
commit 0522eacaf4
1 changed files with 12 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

12
bijoe/schemas.py
View File

@ -169,6 +169,18 @@ class Dimension(Base):
value='EXTRACT(dow from %s)' % self.value,
value_label='to_char(date_trunc(\'week\', current_date)::date '
'+ EXTRACT(dow from %s)::integer, \'TMday\')' % self.value,
filter=False),
Dimension(
label=u'semaine (%s)' % self.label,
name=self.name + '__isoweek',
type='integer',
join=self.join,
value='EXTRACT(isoyear from %s) || \'S\' || EXTRACT(week from %s)'
% (self.value, self.value),
group_by='EXTRACT(isoyear from %s), EXTRACT(week from %s)' % (self.value,
self.value),
order_by='EXTRACT(isoyear from %s), EXTRACT(week from %s)' % (self.value,
self.value),
filter=False)
]
return [self]