@chetan_cricut There is an option to Transpose columns and rows for the Mega Table card. I like to build everything as a table first (be sure to add your date field as the first column), and then apply the heatmap settings I need. Lastly, transpose the columns to rows and you get an 'almost pivot table' You could also try…

I agree, it can be really hard to find what you want, especially if you have a lot of similarly named cards. My workaround is to first, go and find the card I want, navigate to the card details page, and then copy the card ID from the URL, then paste it into the search box to be sure you get the exact one you want. It…

@MarkSnodgrass , you are THE man! I think I would have got there eventually using your "Filling in date gaps" video, but this latest one shows a considerably more efficient method than where I was headed. Thanks again!

@MarkSnodgrass , I knew you'd come through! I was just combing through your Youtube videos trying to see if you had mentioned something like this previously. For some reason, I never considered using a window function like LAG for a non numerical value. All of that said, I am still a bit lost with this point: "Use the…

Thank you for your suggestion. I have updated my original question, which admittedly, was not detailed enough. 😀