I am new to Yii2 Framework and I tend to end up in situations that i don’t get answers to… To blab about my current situation, I have a table with user_id , score and date column. I want to display a GridView report by pivoting the data with date between a given week as header, (unique) user in first column and score as the data corresponding to each user against the date. I wrote a query ActiveDataProvider query which does that and sends them to view.
The main challenge for me is to set up column in GridView Widget where the dates (7 day dates of given week) can be made header.
Is there any method for this I missed ?? some pointers would be appreciated immensely