I am trying to calculate the avg of a value within a dimension so I can visualise to outputs.
actual sum of current selection vs AVG of the entire dimension
I am trying to calculate the percentage of emails opened and then compare it against the avg number of emails opened within a particular dimension.
By this I mean that I have a one to many relationship - a list contains many mailings. List is a dimension within my data model.
Therefore I want to calculate the avg no. Opens for the selected list vs the actual select mailing value.
Just to add... the Avg calculation should not update if I then select a mailing record, as it should reflect the avg of the previous dimension.
I hope that makes sense?
So if you take for example the list = TestData_abandoned_basket, this will have a number of mailings which I also have as a dimension. Hierarchy is List > Mailing.
The average number of TotalClicks for all mailings in the list on 01/12/2014 is 12, but the actual number of TotalClicks for the mailing named 00824_Trigger_AdandonedBasket is 5.
I want to display in a textbox/KPI the average number for the selected list.
If I select a mailing after that, then the average number should remain for the list and not change once I click on the mailing.