5 Replies Latest reply on Aug 7, 2018 12:07 PM by Shinichiro Murakami

# Window Average Calculation not Working with Table & Graph

Hi Everyone,

I'm trying to construct a view that contains both a table and a histogram, which I've been able to create, BUT when trying to apply a Window Average to the top of the table, it's giving me a range (e.g., 72.02% to 82.69%) instead of a single value (e.g., 78%). The Window Average worked just fine BEFORE I added the histogram to the view (when it was solely a table) and now it's showing the range instead of single value as it did before. I'd really like to compute the table average of "Tag Average" and place this as a large number at the top of the view. Keep in mind, Tags are also selected from a multiple drop-down filter - this is why I'd like the window average to adjust based on the select. How can I get it to calculate so that it show single average of the table (for Tag Average)?

Thanks!

Liz

• ###### 1. Re: Window Average Calculation not Working with Table & Graph

HI Liz,

Could you please attach sample data as twbx format.

Thanks,

Shin

• ###### 2. Re: Window Average Calculation not Working with Table & Graph

Hi,

Here is the attached workbook with anonymous, sample data. Please refer to the "Tag (3)" worksheet for what I am trying to accomplish.

Thanks!

Liz

• ###### 3. Re: Window Average Calculation not Working with Table & Graph

Hi Liz,

Probably the easiest way is to use another LOD.

or

Thanks,

Shin

• ###### 4. Re: Window Average Calculation not Working with Table & Graph

Thank you!

That worked! I didn't think a "fix" calculation would adjust with the table and filtering, but it does.

Thanks again!

• ###### 5. Re: Window Average Calculation not Working with Table & Graph

HI Liz,

You are welcome,

Yes, but it depends, which dimension is on your table and which dimension is in your LOD calculations.

Thanks,

Shin