• @jaeW_at_Onyx Ohh ok gotcha. Thanks again.
  • @jaeW_at_Onyx Thanks for the info. If I could access such a feature, it would probably improve and simplify a lot of the gymnastics I currently have to use. What does 'GA' stand for?
  • @jaeW_at_Onyx Yeah if I could use the ETL view I wouldn't be having so many issues. The dataset is very, very large. In the billions. Yes it has been partitioned as well.
  • @MichelleH The people that will be using the data are not very technical, and rarely use the filter view header. That is why I am trying to built a button they can press that will toggle the filter.
  • @MichelleH There is currently 3 calculated field I have added to the view to try and filter the data. Each is based on the above case statement just with 15, 30, or 60 days. If the data is within 15 days, the output row in the column is 'X', 30 is 'Y' and 60 is 'Z', if else its 'N. I've tried creating a separate beast mode…
  • @MichelleH I totally forgot to mention it, but that won't work. The data is a based on a VIEW, and it cant be used in MagicETL because of its monstrous size.