Aggregate data in information link

[Anthony stark]

Hi Guys,

I have some data (attached in a spreadsheet)that i am trying to aggreate at the information link level so the dashboard doesnt end up with millions of rows and impact performance. The data is only one day worth of data, but it has millions of rows. I have attached a spreadsheet with an example of how the data looks, any input will be helpful, thanks in advance

[Anthony stark]

Any help with this

[Shashank Gurnalkar]

Can you try to use Pivot conditioning in Information Designer and see if it helps Refer to the documentation for more information.

Pivoting Data in Information Designer:

https://docs.tibco.com/pub/sfire-analyst/10.3.3/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_pivoting_data.htm

Pivot Conditioning in Information Designer:

https://docs.tibco.com/pub/sfire-analyst/10.3.3/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_details_on_pivot_conditioning.htm

If this does not help, do elaborate on your input data and the expected output.

[Anthony stark]

Hi Shashank, i the pivot conditioning doesnt reduce the rows.