I have a table/graph with Dates within Market in Rows, my "Delivered" metric on the primary axis and my "Booked" metric on the secondary axis. I also have the data split by Daily data and Cumulative data.
Each date is relevant for SOME market(s), but not EVERY market. This results in large blank areas in the table. I would like to remove these empty/null rows, but as you can see from the screenshot, "Show Missing Values" is NOT selected.
Does anybody know how I can clean out these blanks please? I have created a dummy data workbook to illustrate. NB, I have the "Date" as a context filter due to some other charts where I'm filtering to Top 10/Bottom 10 and the Date filter is universal, so ideally, I'd like the Date filter to remain as a context filter (don't know if that affects things). Thank you team! Appreciate your support.
Hi @Tonia Perretta ,
Please refer to the images and twbx file attached.
You can solve this by placing another continuos date field next to it.
But check where to compute after placing it.
Hope this helps.
