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

[Surya_Ravindran]

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

[FredrikE]

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

[Surya_Ravindran]

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

[Sam_SAS]

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

[FredrikE]

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

//Fredrik

[Surya_Ravindran]

Thanks Sam and Fredrik

I'll look into it 🙂