This content has been marked as final. Show 2 replies
I have 3 questions regarding data analytics and charts:
1) I would like to display on the chart data from the same day each month, e.g. if today is 23 Jan, I want to get on the chart bars for 23 december, 23 november, 23 october etc. How should i do that? Is there a formula that can make it happen?
2) I have sales representatives assigned to stores. I would like to display on chart to what % of the sales rep’s total stores base he sold in each month / week / day.
Any ideas on how to do that?
3) Based on point two I would like to generate list / table with stores least frequently visited by the sales rep out of his total base? E.g. display in table store not visited over last 2 weeks. How to do that?
Many thanks for your help