Reply
Highlighted
Frequent Visitor
Posts: 8
Registered: ‎11-01-2018

Time field does not display the record count on hourly basis

[ Edited ]

 

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 

Super Contributor
Posts: 659
Registered: ‎07-25-2018

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