Selection set under Data Point not possible
Hi,
I was trying to make a formula in which I wanted to use a data point in order to select both a measure and a dimension. For the dimension I wanted to use a set made on that dimension, however it seems not possible to select this set (no sets are shown). When I use a standard list, the sets are visible under the same dimension. However using a standard list won't help me unfortuanately. Both examples are shown in the attached screenshots.
4 replies
-
Hi Maaike,
What is the formula you are trying to create?
A data point or Tuple or Record cannot have a list of members as an argument. If it did it would effectively represent a set of data points, not a single defined value.
Please provide details of the outcome you are looking for and we'll help you create the semantic calculation required.
Ian
-
Hi Ian,
I made a list of transactions above 250 euros, from this specific list I would like to make a measure that counts the amount of transactions above 250 euro. I tried doing this using "count" on the list I made but this doesn't seem to give me a measure. So therefore I was trying to use a data point where I wanted to combine a measure (amount of transactions) with the list of transactions above 250euros.
But maybe there is a much easier way to make a measure that shows the amount of transactions above 250 euro?
I hope this makes my question a bit clearer...?
-
Hi Maaike,
As the list you are counting is in the Transactions dimension, by default that is where the custom member will be placed.
If you want it to be a measure, on the right hand properties panel of your formulation, tick the box that allows you to change where the new custom member is to be stored. Select Measures from the drop down.
Bear in mind that the count(list) measure you create is calculated independently from the query context. You will see the same value repeated for each row (if the new measure is in the columns). Depending on what you need from your query there may be other tweeks required.
Hope that helps.
Ian
-
-
Hi Ian,
Thanks for your help. I get the measure in this way, however I can only use it for one team at the time, selecting more teams seems to generate a performance issue . I will go back to our data-engineers for this.
Thanks again,
Maaike