sara93 Tracker

tables empty when loading data into LASR Analytics server via autoload from CSV files

sara93 — Mon, 22 Apr 2024 12:48:02 GMT

Hello,

When loading data into LASR Analytics server via autoload from CSV files, the loaded tables have the same size as the CSV file. However, when creating the report, we find that the loaded table contains no data. Could you please assist us in troubleshooting this issue and retrieving the data in SAS LASER?

Thank you,

Re: how to calculate total groub by column and percent

sara93 — Wed, 13 Mar 2024 11:12:00 GMT

Thank you for your response. Unfortunately, I am working with SAS VA 7.5 on SAS 9.4. Therefore, I will need to perform these calculations on my raw data before loading it into LASR/Visual Analytics.

Re: how to calculate total groub by column and percent

sara93 — Fri, 08 Mar 2024 19:52:31 GMT

thank you for your respond,

im using a cross tab with hierarchy column (epuipement + brand) and parc actif is my measure .

I have calculated Pourcentage by following these steps :

and adding subtotal to my crosstab.

is there any way to calculate the total of percent of the subtotal similar to the following crosstab

how to calculate total groub by column and percent

sara93 — Fri, 08 Mar 2024 19:07:39 GMT

hello,

I am attempting to create the same report in SAS. Could you assist me in calculating the total and percentage for each equipment, as illustrated in the image? I've tried in SAS, but the result doesn't appear to be accurate. I aim for the subtotal to be 100%.

Thank you