I’m left joining that to my other table, via the Date column:
I’m looking to display, by calendar day of the month, activity from one month to the next. So far, so good. The amount is just the amount measure from the second table (so not a calculated field). The problem I am trying to solve is when I filter this data set by one of the other dimensions in the second table not all business days show any longer. I want to always show the business days through the date filtered range, regardless of if the additional filtering exposes matches or not. See example below. I want to still show days 4-8, 11-15, 18-22, etc. for example: If I remove the OrgName filter then I’ll see all those rows too.
When you add a filter to visuals all the NULL rows are omitted automatically. In your case when you add org_name filter, dates with null org names are excluded. you need to replace null values with some string first.
Thans, though that didn’t seem to have the desired effect. Here’s a slightly updated screenshot that hopefully provides more context. From my fact table I have amount and organization. Organization is the top level on rows and amount is just in the value field well. From my calendar dimension I have dayofmonth as the second level on rows and monthofyear on columns. In this particular example the from/to are filtering the relevant date field from the calendar table, which is joined to my fact table. No surprise there are entries in my fact table where there is no activity for a given date. So, when I filtered this by just one of the many organizations you can see the days of the month (in both) where there was no activity (6th, 7th, 12th-16th). Days where there is activity in at least one of the months show up as you can see.
I want to always show all daysofthemonth rows, regardless of whether there are corresponding facts. Following your suggestion I populated the null values behavior for organization. I did so as well for dayofmonth, monthofyear and amount.
Hi @stefan, currently QuickSight doesn’t support this feature – another post! A workaround would require some SQL changes and for you to make a calendar and join all of your data onto that calendar. At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request. More features are being added on a regular basis, so please keep an eye on the What’s New / Blog . You can set up a Watching Alert by clicking on the bell icon.
