I have data source which gives data for analytics but I need some more data which is not present in data source to design analytics , so I need to create it in Looker. The data I need to create by ETL has few sets of algorithm. I am mentioning the same below:
- I have some client which follow different date calendar like
Client 1: Week start from Monday and fiscal month start from the same date and year.
Client 2, Sunday and fiscal week and month and year start from the date we give for any sunday
So I want to make an calendar table where I just need to give one date lets say 4 Jan 2016 which is first monday of 2016 and first week will be 4 Jan to 10 Jan, fiscal year starts from 4 Jan 2016 and other date fields, like ytd, previous ytd etc will be calculated by using date functions.
So this kind of algorithm I want to write in look and generate the data which is not present in main data source but we create it in looker.
Please help me to know is it possible to do it if yes how.
I know it is is possible in Qlik which has its own ETL but I want to do the same things here