Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a data set basic description:
Date,ID,Value
and a Mapping Table:
ID, Weight
I want to then create a table that has field called CALCCOUNT with integers 0-100
I want to then count the number of dates where sum of the round((Value*Weight),0) for that date equals CALCOUNT
Example Chart I would like:
CALCOUNT | Frequency of Dates |
---|---|
0 | 1 |
1 | 25 |
2 | 4 |
... | 45 |
99 | 55 |
100 | 23 |
Thank you for your help!
I don't have the data to test it, but you might need an Island table with all possible values... lets call it AllValues
Dimension
AllValues
Expression
Sum(Aggr(If(Sum(Value) = AllValues, 1, 0), Dates, AllValues)) + Sum({1} 0)
Now uncheck 'Suppress Zero Values' on the presentation tab...
May be this
Dimension
Aggr(round((Value*Weight),0), ID)\
Expression
Count(DISTINCT ID)
Thanks Sunny, I still need to show integers with 0 counts.
Uncheck 'Suppress Zero Values' on the presentation tab and see if that works
What's wrong with this one?
None of my suggestions worked for you? or what I said made so sense whatsoever?
They did not work, but I did bad job explaining. Here i simplified it a bit:
Date,ID,Values
I want to then create a table that has field called AGGRValue with integers 0-100
I want to then count the number of dates where the sum of values for each total date equals the AGGRValue
I did RecNo() as AGGRValue
Autogenerate (100);
So if 55 dates sum to 99 each then I want the frequency of dates to be 55 and where 25 dates equal the sum of 1 each it will show 25
Example Chart I would like:
AGGRValue | Count the number of dates that equal teh AGGRValue |
---|---|
0 | 1 |
1 | 25 |
2 | 4 |
... | 45 |
99 | 55 |
100 | 23 |
Thank you for your help!
Okay then try this
Dimension
Aggr(Sum(Values), Date)
Expression
Count(DISTINCT Date)
Thanks Sunny, this kind of worked. I need to show an array of values regardless if the values are present. IE: 1-100.
Whats happening now as an example, 2 is never a sum of values in the data set but i need the end user to see that 2 has 0 dates associated when they export the data. Right now it will show values in a table 0,1,3,4 etc...with appropriate counts.
I don't have the data to test it, but you might need an Island table with all possible values... lets call it AllValues
Dimension
AllValues
Expression
Sum(Aggr(If(Sum(Value) = AllValues, 1, 0), Dates, AllValues)) + Sum({1} 0)
Now uncheck 'Suppress Zero Values' on the presentation tab...