How do I get the average quantity of food sold per day per hour. So for example what's the average quantity of food sold at 6 o'clock on a Sunday.

Question

I'd like it in either the tooltip or as another column. I understand it's a level of detail calculation but have not had any success yet.

Tableau Community Forums Member (Inactive) · Accepted Answer

Hello Gage,

In general, a LOD calculation like AVG({INCLUDE [Dimension]: SUM([Quantity])}) might work.

It seems that a published datasource is used in your workbook.

Could you please follow the instructions in "Create a .twbx with Tableau Server data sources" section of this link and re-attach the workbook?

Regards

Lei

Tableau Desktop & Web Authoring