tableau-apiaggregationsummarylevel-of-detail

how to combine all of the results of count for every max, min, median, average


this is the continous from my question from here how to display max, min, median, and average from tableau

i have data like this enter image description here

on that picture, that is user_id and the right side are the frequency of transaction for each users

so based on the solution, i've used window function, and used min with this

WINDOW_MIN(COUNTD([Order Id]), FIRST(), LAST())

max with this

WINDOW_MAX(COUNTD([Order Id]), FIRST(), LAST())

median with this

WINDOW_MEDIAN(COUNTD([Order Id]), FIRST(), LAST())

how to combine the results so the results can become like this (this is on my dashboard made with another software) on my worksheet, is it possible?

EXPECTED RESULTS


Solution

  • If you want to show all these on your dashboard as a reference, why not show these in annotation. Include all four in details mark card. Right click on chart area -> include annotation -> include all four as desired.

    EDIT:

    Another method: In your view wherein a 'frequency' (COUNTD(USER_ID)) field has been added to sheet/view, right click in sheet area and check summary . Your desired calculations will be added automatically.

    enter image description here

    You can also change 'stats' to be displayed here by clicking on summary card.