Every record in my dataset has a Created Date and Resolved Date. I need to create a graph showing the total number of records that were still open at the end of each month. So, looking at the whole data set, count those records that were created before the end of that month and are either still open (Resolved Date null) or were resolved after the end of that month. I have experimented with scaffolding my data and various LOD expressions but can't quite get there. I need the month end total to always look at the entire data set, regardless of what date filters might be applied to the visualisation
Thanks in advance for any pointers
scaffolding is the way it is done - you said you have not been successful -- we need to see your workbook to see where it went wrong - please post your twbx - btw you can review this https://jimdehner.com/2025/01/27/say-goodbye-to-cartesian-joins/ the 2nd and 3rd example - the advantage with this method is you do not explode the data set with a cartesian join
