6 Replies Latest reply: Jan 4, 2011 7:42 AM by martinohlson RSS

    Calculated dimension to only show a subset of a table

    martinohlson

      Hi,

      I want to add a table as a dimension for a graph, but I don't want the full table to be included in the graph, only a part of it.

      I think this is a problem solved with calculated dimensions (correct me if I'm wrong), but I don't know the syntax for it.

      I have a table Customers with customer ID 1, 2, 3, 4, 5. Instead of using the dimension "customerID" (which would result in 1-5) I only want to include the customer with the highest customer id. What is the syntax for this calculation? I'm guessing something like "=max(customerID)"?

      If I only want to add the customers who have made over 10 orders, count(orderid)>=10, how do I add this restriction to my dimension?