Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
In my initial load, I have evaluated a condition and set a flag for each record (0 or 1). Now I want to create a straight table from these results only showing records where the flag above is "1". Sounds easy but I can't get it.
Thanks.
Your set analysis should look like this:
{<YourFlagField={1}>}
So your expression should look like this (using whatever calculation you're using):
sum({<YourFlagField={1}>} SomeFieldToSum)
This does not need set analysis.
In your data load rather than setting the flag field to 1 or 0, set the flag to 1 or null.
if(value = x,1) as flag // the expression does not have an else value
Then you can add your flag field as a dimension and set the "Suppress When Value Is Null" option on the Dimension sheet.
Create a Calculated Dimension:
If(Flag = 1, YourDimensionName)
Your set analysis should look like this:
{<YourFlagField={1}>}
So your expression should look like this (using whatever calculation you're using):
sum({<YourFlagField={1}>} SomeFieldToSum)
Another option (again not using set analysis)
=sum(value * flag)