You can create pre filter or post filter in calculated fields. Sum(if state=‘Ca’ then sales end) is row level filter or pre filter. If attr(state)=‘Ca’ then sum(sales) end is aggregation filter or post filter. In sql, where statement is pre filter. Having statement is post filter.
I want to get a value from calculated filed having filters status==active min_date==1/1/2021 then get profit By this calculated filed I get profit in this year... Overall I want to place profit for this year and other all years for a store at a time. How can I do it? Thanks in advance!
Thank you! This is exactly what I needed
Can i use filters in creating calculated fields. If Yes, how?
You can create pre filter or post filter in calculated fields. Sum(if state=‘Ca’ then sales end) is row level filter or pre filter. If attr(state)=‘Ca’ then sum(sales) end is aggregation filter or post filter. In sql, where statement is pre filter. Having statement is post filter.
I want to get a value from calculated filed having filters
status==active
min_date==1/1/2021
then get profit
By this calculated filed I get profit in this year...
Overall I want to place profit for this year and other all years for a store at a time. How can I do it?
Thanks in advance!
Can you turn AGG dimension into a measure?
Aggregated dimension? Not sure what that is.
As long as it’s a numeric value, yes.