Hi everyone, has anyone experienced a similar problem before? before applying with a filter, everything is correct (red line). however, after filtering it, it shows a wrong num. I used avgOver(sum({total_cash}),[{3_mth_ago},{bank_exposure},{Region2[country_classifications_cash_flash_20211011.csv]}],POST_AGG_FILTER). is it related to post_agg_filter? I tried pre_filter or post_filter. it does not help
please see the attached sample example.
before filter, it is daily file (avg_cash is doin what I am asking to do).
after filter (just to get quarter end like 3/31/2024), the number is changed become a simple sum() so has the same num as total_cash
Hi @JLLLL – we have not experienced this issue. It maybe related to the post_agg_filter, please see if this link helps. Also, try using one of our pre-built functions from this list.
If you need further assistance, consider creating a sample dashboard with a sample dataset in Arena that illustrates your problem. Post it in a new thread for better visibility. You can find detailed instructions on how to use Arena here.
1 Like