I have a dataset that joins to a calendar table, in some dates we have no data, so all other columns shows as null.
I want to have a heatmap showing all dates on columns like a calendar, but for the rows if there is any null I want to exclude it from the view. The issue is If I do a filter to exclude the null on the row, it will exclude me the date as well.
So for example excluding the null, will hide the day 6 and 13
Hello @HUIL !
I think the easiest approach would be changing the underlying dataset so that instead of ānullā you get 0.
Do you have access to your underlying dataset?
Did this solution work for you? I am marking this reply as, āSolution,ā but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
I tried changing the null values as 0 for the other columns, however, I have same issue when excluding this 0 from the rows it exclude me the date as well from the column.
There are dates that we doesnāt have data, however, we want to show the date on this heatmap column.
The dataset is full joined to a calendar table that contains all dates, so in a calculated field I do something like: coalesce(date, Schedule Date)
Where ādateā is the field from the calendar table
and āSchedule Dateā are the date of records. So I am using this as the column and a field for countries for the rows.
So if i exclude ānullā countries, it will exclude me the ādateā as well.
Hi @HUIL, besides using SQL ā Iām out of ideas. Sorry, currently this is not possible but Iām marking this for feature request. 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.