this is the continous from my question from here how to display max, min, median, and average from tableau
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?
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.
You can also change 'stats' to be displayed here by clicking on summary card.