You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@superset.apache.org by GitBox <gi...@apache.org> on 2018/02/28 06:41:31 UTC

[GitHub] mcampana opened a new issue #4499: Grouping by day of week

mcampana opened a new issue #4499: Grouping by day of week
URL: https://github.com/apache/incubator-superset/issues/4499
 
 
   I have a time serie data set related to the occuppancy level of our library (almost two years,
   with a granularity of 15 min). I'm  trying to use superset for analyzing the data.
   I wonder if it is possible to make a slice chart showing aggregated metrics per day of week?
   In particular, I would like to display the typical occupancy level for a week, by averaging the
   the data collected during 108 weeks (almost two years).
   
   I have tried to add a new column to my datatable, defining a new column named wday as srtfttime('%',date), and try to group by that column... but with  no success.
   
   date is the timestamp column in my data set, in format YYYYMMDD, which I parsed as %Y%m%d
   
   Any help? Has anyone tried to display something similar?
   
   Best regards
   
   Manuel Alvarez-Campana

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services