-
1. Re: Date over Date & time over time comparison
suresh.gooty Nov 13, 2018 3:01 AM (in response to manoj kumar)Very Simple,
you can do this in multiple methods out of which one i did specify below. first write formula to pull only November sales and then write formula same for september based on your time and date condition. and then place both in one graph. if you want comparision and percentage difference then write another formula as
SUM(NOVEMBER SALES)/SUM(SEPTEMBER SALES) AND change format for this formula as percentage.... find below screenshot...
-
2. Re: Date over Date & time over time comparison
manoj kumar Nov 13, 2018 4:21 AM (in response to suresh.gooty)Hi Suresh,
Thank you for getting back. Let me try it out at my end. Whether it solves the purpose.
Another question, say if i want to do a live comparison. Say the sale started by 13th 9:30 AM and still it is in progress. I wanted to compare the sales done on 10th Sep.
I wanted to do a live comparison, i wanted to fetch the date & time of present date and compare it with the sale done on 10th Sep with the same time frame how it can be accomplished.
Any suggestions.
Cheers
Manoj