cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vishnuragas Frequent Visitor
Frequent Visitor

Time field does not display the record count on hourly basis

 

I would want to display the number of tweets for each hour and below is the table. Below is the structure of the table. 

 

 

tweet_power bi.PNG

 

 

 

 

 

Below is how the graph should look.

 

axis.PNG

 

 

 

But in Power BI, the number of records (S.No gets automatically aggregated as SUM of RECORDS). I split the date time field into a date, hour fields. But I don't get tweets by an hour but an aggregate of hours. Below is how the plot looks in POWER BI.

 

 

 

 

 

twee by time.PNG

 

 

The fields in the pane are:

 

fields.PNG 

1 REPLY 1
Community Support Team
Community Support Team

Re: Time field does not display the record count on hourly basis

Hi @vishnuragas

 

It seems you may check the aggregation of RECORDS as below. If it is not your case, please share your data sample or more details for us to check. You can upload it to OneDrive or Dropbox and post the link here or send me via private message.

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.