I'm using Facebook public page data connector
I would like to see daily total reactions breakdown by day but now there is no date dimension. I have to use post create time instead.
1. Do you have date dimension? If yes, how can I use it?
2. Do you have any ways to convert create time dimension to date dimension?
#1 - Sadly not, the public data connector mostly works off of lifetime totals for the reaction metrics and aren't affected by date ranges, which is why it's not included. Note that the Facebook Insights connector has the same kind of problem - it only shows the reactions based on the publish date of the post and aggregates them over the lifetime of the post. It can't show what reaction was given on a certain day after that.
#2 - As noted above though, it only works off the published date of the post anyway so you can't use standard dates to gather the reactions on each day. Only over the post's lifetime.