topic Re: SAS VA i want to have the sum of distinct value of a column in SAS Visual Analytics

SAS VA i want to have the sum of distinct value of a column

ajulio4 — Fri, 16 May 2025 11:23:59 GMT

In my reporting, i have some variables. i put table oject on my reporting with a column XX, and i wand to have anytime, the sum of the distinct value i have for my column in the table oject.

Can someone helpe me please ?

thks

Re: SAS VA i want to have the sum of distinct value of a column

Huzaifa_SAS — Mon, 19 May 2025 07:21:58 GMT

Hi @ajulio4,

We need a better understanding of what you want to do. Having sample data might help us to provide a better answer for you.

-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center

Re: SAS VA i want to have the sum of distinct value of a column

ajulio4 — Mon, 19 May 2025 08:13:57 GMT

Hello,

Thks you for the reply.

On my dashbord i have crosstable with columns and line like this :

And i would like to have in avariable, the sum of the distinct values of my columns Taille totale du FS(Go)

Re: SAS VA i want to have the sum of distinct value of a column

HunterT_SAS — Tue, 20 May 2025 11:20:06 GMT

I can't be certain without better understanding your data but I suspect you'll need to use the AggregateTable function and create something like this (this is from Visual Analytics 2025.04 so may look a little different if you are on Viya 3.5):

AggregateTable(_Sum_, Table(_CountDistinct_, Fixed('Dir'n), 'Taille totale du FS(Go)'n))

If that's not getting you what you are wanting, could you provide some sample data and what kind of results you are expecting?