12 Replies Latest reply on Nov 21, 2018 10:28 AM by Hari Ankem

# Calculate average per category

Hello,

Need assistance on finding a formula to get the average per "CategoryLevel2ID".  I know that i will need a LOC formula but have been having problems to run correctly.

Current formula: {INCLUDE [CategoryLevel2ID]:AVG([Total Time Open Display])}

• ###### 1. Re: Calculate average per category

{FIXED [Priority1],[CategoryLevel1ID],[CategoryLevel2ID]:AVG([Total Time Open Display])}

• ###### 2. Re: Calculate average per category

Getting "calculation contains errors" message. "AVG is being call with (string), did you mean (Float)?"

• ###### 3. Re: Calculate average per category

OK. Can you convert the time into minutes/seconds and then try again? You may again need to convert the number back to the hours and minutes. Please provide your data file and/or packaged workbook if you need help doing it.

• ###### 4. Re: Calculate average per category

Hi Hari,

So I was able to convert the hours and minutes to all minutes, but the

average is not correct.

Thanks,

Alex Monteiro

ITIL, BCSS

888-219-9228

Alex.Monteiro@noaa.gov

“Logic will get you from A to B. Imagination will take you everywhere.

Albert Einstein

From: Hari Ankem <tableaucommunity@tableau.com>

Sent: Friday, November 9, 2018 2:38 PM

To: Alex Monteiro <alex.monteiro@noaa.gov>

Subject: Re:  - Calculate average per category

Tableau Community Forums

Calculate average per category

in Forums - View the full discussion

• ###### 6. Re: Calculate average per category

Can you please share your data file and/or the packaged workbook (.twbx) with data extracted in it? Unless I see and work on it, I may not be able to suggest the right solution.

• ###### 7. Re: Calculate average per category

Hari,

Attached is my test workbook.

Alex Monteiro

ITIL, BCSS

888-219-9228

Alex.Monteiro@noaa.gov

“Logic will get you from A to B. Imagination will take you everywhere.

Albert Einstein

From: Hari Ankem <tableaucommunity@tableau.com>

Sent: Thursday, November 15, 2018 12:15 PM

To: Alex Monteiro <alex.monteiro@noaa.gov>

Subject: Re:  - Calculate average per category

Tableau Community Forums

Calculate average per category

in Forums - View the full discussion

• ###### 8. Re: Calculate average per category

You nee to provide the packaged workbook (.twbx) with data extracted in it.

• ###### 9. Re: Calculate average per category

Hari,

Please see attached packaged workbook and extracted data.

Thanks,

Alex Monteiro

ITIL, BCSS

888-219-9228

Alex.Monteiro@noaa.gov

“Logic will get you from A to B. Imagination will take you everywhere.

Albert Einstein

From: Hari Ankem <tableaucommunity@tableau.com>

Sent: Friday, November 16, 2018 4:28 PM

To: Alex Monteiro <alex.monteiro@noaa.gov>

Subject: Re:  - Calculate average per category

Tableau Community Forums

Calculate average per category

in Forums - View the full discussion

• ###### 10. Re: Calculate average per category

Do the averages look right to you?

• ###### 11. Re: Calculate average per category

Yes, they do.  How did you get it to work correctly?

Alex Monteiro

ITIL, BCSS

888-219-9228

Alex.Monteiro@noaa.gov

“Logic will get you from A to B. Imagination will take you everywhere.

Albert Einstein

From: Hari Ankem <tableaucommunity@tableau.com>

Sent: Tuesday, November 20, 2018 4:58 PM

To: Alex Monteiro <alex.monteiro@noaa.gov>

Subject: Re:  - Calculate average per category

Tableau Community Forums

Calculate average per category