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

0
votes

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

1
tableau-apiaggregationsummarylevel-of-detail

1 Answers

1
votes

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.