Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
So i have multiple field (Field1, Field2, Field3,... ). Each fild contain the same data. ( Value1, Value2, Value3,... )
I need to count each values.
Like:
Data | Field1 | Field2 | Field3 |
---|---|---|---|
Value1 | Count(field1) | Count(field2) | Count(field3) |
Value2 | Count(field1) | Count(field2) | Count(field3) |
Value3 | Count(field1) | Count(field2) | Count(field3) |
Value4 | Count(field1) | Count(field2) | Count(field3) |
Value5 | Count(field1) | Count(field2) | Count(field3) |
How can i archive that ? With aggr()?
Thanks a lot
Not sure I understand your data... you have expressions in the fields?
I am with sunny
OR
Create Straight Table
Dimension - Data
Expressions - Count(Field1), Count(Field2), Count(Field3) // Three expressions
OK i will try to explain better ^^
I want to have the frequency of each values in eaach field.
Field1: Field2:
sun 5 50% sun 11 55%
star 4 40% star 2 20%
Moon 1 10% Moon 7 35%
I don't want to have multi field.
I want one table with all the field with frequency and percent. To extract all in excel in one time.
It's the same value in each field ( sun, star, moon, ... )
Hi,
Right Click on list box > property> general > Show Frequency > (If required in percent then select %)
If you required all 3 then
list box > property > Expression >
Add expression
1: count(FieldName)
2: sum(FieldName)/Sum(Total FieldName)
Regards,