Hi all -
We’re trying to vet out whether or not QuickSight can replace our current Power BI solution. My current hang up is in creating a flexible dataset that allows me to aggregate multiple date columns across a single date dimension.
In a Power BI environment, you can create a calendar table and relate all your date fields within your dataset to that table and use that table in conjunction with calculated fields to aggregate/filter as much as you want. I can’t find a comparable strategy in quicksight.
For example - our data has this basic structure:
Ideally we’d be able to summarize it into a table like this - that can be sliced by other columns (merchant, state, product, etc.)
When I’m in the Dataset Editor, I can bring in a calendar table but I can’t connect more than 1 date to the calendar without running into joining issues. I can create this summary table in sql but then we miss out on all the benefits from filtering by the other columns.
This is a 10 minute task for the team in our current environment and I’m nervous I’m thinking about this all wrong because it seems like I’m making it far more complicated than it needs to be in QuickSight. Every demo I find only addresses data with a single date column so I’ve been stuck here for longer than I care to admit.