Custom Table Widget
Hi Folks,
I am creating a table widget where I want the columns to be all the Products and then the y axis to the be the Quarters. So it would show how many products where sold in each quarter with a total count at the very bottom. The relationships are in place where I should be able to pull in the data for sales per quarter Product->sales($quarter), but i cant figure out how to correctly pull in the columns as all the products and set the rows as q1, q2, q3, q4.
Is this do able with table builder or is there is a better way I should be achieving this kind of a layout? I figure this something people are often doing so it shouldn't be too hard, but maybe I'm overcomplicating it myself.
Thanks!
I am creating a table widget where I want the columns to be all the Products and then the y axis to the be the Quarters. So it would show how many products where sold in each quarter with a total count at the very bottom. The relationships are in place where I should be able to pull in the data for sales per quarter Product->sales($quarter), but i cant figure out how to correctly pull in the columns as all the products and set the rows as q1, q2, q3, q4.
Is this do able with table builder or is there is a better way I should be achieving this kind of a layout? I figure this something people are often doing so it shouldn't be too hard, but maybe I'm overcomplicating it myself.
Thanks!
Solution
Hmm, not really going to be able to do that out of the box since tables require eloquent queries. You could possible do it faking a model and using the sushi package.
