Any help on how your data is formatted on the Data Source. I have a Sheet with Weeks 1-52 across the columns and product numbers down the rows. i would ideally like to have a control allowing only one product number and then a timescale graph for unit sales per week. I would grow from that with total stock bars and more but for now a sales timescale would be sufficient. When I try use this sheet its not reading it correctly. Thank you.
Dont use weeks in column headings. Use two columns, one for product number and one for week number. Instead of 52 columns for weeks, you need one column. Product number should repeat 52 times for every product. Now use the week column to draw chart, and the product column to filter the chart.
That would entirely depend upon the customer. How are they recording the transactions. If it is online, they can directly link looker studio to their database service, in which case, data will be updated live without any additional cost. If they keep it on a local computer but use a proper software, they can extract a csv and upload it to google docs. Now labor is involved and data will update on same frequency it is being uploaded. If none of the above, customer must enter data in google sheets which very costly, time taking, erroneous etc. On developer's end, the cost also depends upon customers setup and their requirement.
@@KashfiaAhmed-o7h No. It is just randomly created data for our tutorials. You can download here: docs.google.com/spreadsheets/d/1fQCL-lQ1Ql7QbLhBRvNs0tJAQebZ4MF7tXLL_P5wnpc/edit?usp=sharing
The video surely deserves an applaude. Great work done, several aspects covered in one video 👏👏
Thanks dear.
Great job. Well done!!!
Thanks for your kind words.
Any help on how your data is formatted on the Data Source. I have a Sheet with Weeks 1-52 across the columns and product numbers down the rows. i would ideally like to have a control allowing only one product number and then a timescale graph for unit sales per week. I would grow from that with total stock bars and more but for now a sales timescale would be sufficient. When I try use this sheet its not reading it correctly. Thank you.
Dont use weeks in column headings. Use two columns, one for product number and one for week number. Instead of 52 columns for weeks, you need one column. Product number should repeat 52 times for every product. Now use the week column to draw chart, and the product column to filter the chart.
Do you want me to do a video on this?
Well Done!!!
Thaks for appreciation.
If you would sell this as a service, what would be the average building costs and monthly costs for your customer to keep the data recent.
That would entirely depend upon the customer. How are they recording the transactions. If it is online, they can directly link looker studio to their database service, in which case, data will be updated live without any additional cost. If they keep it on a local computer but use a proper software, they can extract a csv and upload it to google docs. Now labor is involved and data will update on same frequency it is being uploaded. If none of the above, customer must enter data in google sheets which very costly, time taking, erroneous etc. On developer's end, the cost also depends upon customers setup and their requirement.
Can you make a video on how to link directly to looker studio,
Sure. Please mention data source. sql?
Super!
Thanks
can provide that google data sheet
Sure: docs.google.com/spreadsheets/d/1fQCL-lQ1Ql7QbLhBRvNs0tJAQebZ4MF7tXLL_P5wnpc/edit?usp=sharing
Hi@@virtual_school is this dataset derived from any source? Link?
@@KashfiaAhmed-o7h No. It is just randomly created data for our tutorials. You can download here: docs.google.com/spreadsheets/d/1fQCL-lQ1Ql7QbLhBRvNs0tJAQebZ4MF7tXLL_P5wnpc/edit?usp=sharing