TimClayton
New Member
- Joined
- Oct 17, 2018
- Messages
- 11
Hi all
I have extracted sales data into 2 columns as below:
<colgroup><col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody>
</tbody>etc. (about 800 sales over 6 months)
I'd like to display this data (can be several charts/tables) to show the following information:
There's probably several ways of doing this, but I'm looking for the one that's most visually pleasing/easy to read.
Just to clarify, I'd like the DAY of the week from the date, not the busiest dates. i.e. 12-1pm on Wednesday was the busiest day of week 1, 3-4pm on Tuesday of week 2 etc... Thursday is the busiest day of the week on average in the last 6 months...
Basically as much information as possible in an easy to read format.
Thanks in advance!
I have extracted sales data into 2 columns as below:
15/06/2019 12:55 | £15.00 |
15/06/2019 13:03 | £105.00 |
16/06/2019 10:56 | £185.00 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody>
</tbody>
I'd like to display this data (can be several charts/tables) to show the following information:
- Busiest day of the week (no. of sales)
- Busiest day of the week (highest turnover)
- Busiest time of day (no. of sales)
- Busiest time of day (highest turnover)
There's probably several ways of doing this, but I'm looking for the one that's most visually pleasing/easy to read.
Just to clarify, I'd like the DAY of the week from the date, not the busiest dates. i.e. 12-1pm on Wednesday was the busiest day of week 1, 3-4pm on Tuesday of week 2 etc... Thursday is the busiest day of the week on average in the last 6 months...
Basically as much information as possible in an easy to read format.
Thanks in advance!