How to PRE_FILTER only one visual row filter

Hi @rusu2k - If you want to include the date field in your visual, we will have to do the YTD and other period calculations differently. First thing is rather than using your date controls as regular filters (which are removing the other rows from the underlying query and breaking the YoY types of calcs), we need to make them ‘hide’ the time periods from the visual, not actually filter it out from teh query. There is a trick to do this you can read up on here: How do I superimpose a period over period in a visual without having the period that I'm comparing it to in the visual? - #4 by Jesse

Not exactly sure how your are doing the YTD calcs right now (feel free to share the formulas you are using), but try using the runningSum for YTD and periodOverPeriodPercentDifference for the % change formulas. periodOverPeriodPercentDifference - Amazon QuickSight

1 Like