Hi,
I have the below pivot table where I compare each operators performance against an Avg benchmark but I don’t want the avg to be displayed besides every operator but just once in the end.
How to do so?
hi @pantelis
are you saying that you want to hide ‘daily avg’ on the dashboard for ad-hoc needs?
kin regards,
Wakana
Hi @Wakana
No, I want to to be shown once. So instead of the above picture I want to have in a pivot table the below columns.
The Daily Avg is a values column and I have in columns the Operator field.
So for each operator the Daily Avg is repeated where I want it once in the end.
Operator 1 | Operator 2 | Operator 3 | Daily Avg
Hi @pantelis,
It’s been awhile since last communication on this thread, are you still working through this or were you able to find a work around for your case?
If still working on this, could you share the calculated field you’re using to get the average? You may just have to switch up how you’re aggregating so that it only populates once per line.
Hi @pantelis,
Since we have not heard back in a while, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!