I need to see AWS Cost data by hour. When I select hour as the aggregate, the pivot table is only showing by day. This is in the AWS CUDOS dashboard using the summary_view dataset. My goal is to list costs by hour and it’s currently listing by day. Any help is appreciated.
Hi @usmitra,
Confirming your dataset is setup with rows at the hour level so that this would be possible?
If so, could you please share a screenshot of your ‘usage_date’ example in the dataset so that we can try to figure out a work around?
Hi @usmitra
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @usmitra
I think you should extract the hour part from the usage_date as a separate calculated field in your dataset or analysis.
You can then use that for your visual; using your usage_date for filtering the date range for which you are analysing the data.
Regards,
Giri
I was able to use the hourly_view dataset to extract the information I needed. Thanks for all the help.