Forum Discussion

Copper Contributor

Apr 19, 2022

Excel tables or formulas for data analysis

I have a data set of all our inbound calls from last week and what times the calls came in. To be able to monitor when our peak periods were, I want to create a pivot or table that tells me how many ...

excel

Lorenzo

Silver Contributor

Apr 20, 2022

loljay

With Power Query

Sample attached

PQ_CallsInTimeFrame_loljay.xlsx28 KB

loljay
Copper Contributor
Apr 26, 2022
Lorenzo
hey thanks
its just not letting me see any formulas in that sample sheet... would you be able to send the formula you used in column D of the sample please?

Tysm
- SergeiBaklan
  Diamond Contributor
  Apr 26, 2022
  loljay
  Here are couple of more variants
  
  - PivotTable (if you work with data model)
  
  - formula (if you work with dynamic arrays, i.e. Excel 365 or 2021)
  PQ_CallsInTimeFrame_loljay.xlsx227 KB
- Lorenzo
  Silver Contributor
  Apr 26, 2022
  loljay
  There's no Excel formula as this is done with https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a?msclkid=0f98e684c52611eca5ad1cd31ee5db93