topic Re: Is there a way to add serial number to a list table in SAS VIYA VA in SAS Visual Analytics

Is there a way to add serial number to a list table in SAS VIYA VA

Surya_Ravindran — Thu, 23 Jan 2020 17:53:28 GMT

Hi,

I am looking for a way to add serial numbers to a list table on SAS VA.

I couldn't find any option to do this. Could anyone suggest any solutions?

Basically i want to display the total number of categories as the count in the end of the list table where for measures we will be able to see sum values.

Thanks

Re: Is there a way to add serial number to a list table in SAS VIYA VA

FredrikE — Mon, 27 Jan 2020 13:19:51 GMT

Hi!

If you want to count each row you can add a measure with the value 1 to your data or if you want distinct values, right click on the category and create "Count distinct".

Will that help you?

//Fredrik

Re: Is there a way to add serial number to a list table in SAS VIYA VA

Surya_Ravindran — Mon, 27 Jan 2020 13:31:16 GMT

Hi Fredrik,

Thanks a mil for your response.

The solutions you have provided would help me get the total but I'm also looking to display the serial numbers in the list table.

Would you know if this is possible?

Many Thanks

Surya

Re: Is there a way to add serial number to a list table in SAS VIYA VA

Sam_SAS — Mon, 27 Jan 2020 14:16:01 GMT

Hello Surya,

In your data preparation (Visual Data Builder / Data Studio), I believe there should be a way to create a "unique identifier". Data Studio has this for sure.

This generated column should work as a serial number.

Let us know if that works.

Thanks,

Sam

Re: Is there a way to add serial number to a list table in SAS VIYA VA

FredrikE — Mon, 27 Jan 2020 16:34:20 GMT

I don't know a way to achieve that, think you need to do something like what @Sam_SAS says 🙂

//Fredrik

Re: Is there a way to add serial number to a list table in SAS VIYA VA

Surya_Ravindran — Mon, 27 Jan 2020 16:58:42 GMT

Thanks Sam and Fredrik

I'll look into it 🙂