Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a table which would show me the top 20 customers based on sales who have made at least 5 purchases in a Straight Table. I have added a condition to the table loading that states:
Count(Sales.id) > 5
which stops the entire table from loading data if the total number of sales is less than 5. However, what I want is to stop the loading of a particular row in the table if the total number of sales is less than 5. I tried putting in the following expression into the dimension for the table, but I get an "Error in calculated dimension":
if(Count(Sales.id) > 5, Customer.name)
How do I go about doing this?
Thanks!
It's not so easy.
You have to explain to QV how this expression should be calculated:
=aggr(if(Count(Sales.id) > 5, Customer.name), Customer.name)
It's not so easy.
You have to explain to QV how this expression should be calculated:
=aggr(if(Count(Sales.id) > 5, Customer.name), Customer.name)
Dear Elie,
Please see the attached QV File.
Regards
Mhatim