Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I generate a report everyday about no of products from one place. I want to display the average number of products from those places in front of the days numbers. How to do that?
Eg. Let for today Place - A, B, C
Products - 2,6,4
Similarly for a month I generate this report everyday. I want to introduce a column with average products so that I have an idea.
Please help
Can you prepare a set of data?
Hi Akshay please elaborate more, it doesn't gives more clarification.
Upload some dummy data and expected output.
-- Regards,
Vishal Waghole
Although I admit that a sample data set would be useful in this case, have you tried doing something like:
avg(aggr(count(Products), Place))
Regards
Agis