Visualization support: Tracking incoming emails via Flow over time + aggregation date support

[kjenge]

Hello!

I'm new to Power BI and looking for support on how to set up a visualization showing the volume of incoming emails per day over time (X: date [labeled as 1/1/2018] vs. Y: volume of incoming emails per day). 

A Flow was set up to track the volume of incoming emails in a shared mailbox:

• Trigger: "When a new email arrives in a shared mailbox"
• Run: "Insert row"
• Each row is a new incoming email with the following data:
  • "From"
  • "CC"
  • "Subject"
  • "Date"
  • "Attachment"

The "Date" column appears as: 2017-08-28T18:58:09+00:00. Though I'm new to Power BI, I was able to figure out how to display this column as (mm/dd/yyyy) under "Modeling" > "Formatting." However, the missing piece is learning how to aggregate the data to count the sum each unique date in order to display the intended visualization correctly.

The final outcome for the intended visualization should appear as the attached picture. I pulled this picture from Flow analytics. To my understanding, Flow has basic analytics built in to show run data (see attached); however, I would like to display the actual volume of incoming emails vs. the number of "runs" as shown.

Please assist!

Thank you.

[v-chuncz-msft · Accepted solution]

@kjenge,

It seems that you may drag any data field to Values and select Count in the dropdown.