Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
in my model i have a fact table with date, id and event types
in addition to that i have a field that calculates the day dif between min date and max date of every id in the fact.
this filed (day dif) is static and is showing the same value for all rows for each id.
in UI i want to calculate AVG of the day dif , but some id's have more sows then others in the fact .
what would be the best way to achieve this ?
Hi,
Just for the sake of curiosity what's the point of calculating AVG of static value?
@ilanbaruch wrote:this filed (day dif) is static and is showing the same value for all rows for each id.
In this case AVG will always be equal to this static value disregarding of number of occurrences of this value.
May be you wanted to calculate slightly different thing?
//Andrei