You need to sign in to do that
Don't have an account?
Ajay L
Complex report and dashboard in VF
Hi,
I have a complex requirement to build a report. Hoever I noticed that it is not possible with standard report. Can you help me the best way to create this complex report using VF page.
Left side colum has Field Labels. and we need to caluculate each field value Percentage based on the value selected on the total reocrds which users attened that specific field.
Thanks in advance.
Reagrds,
Ajay
I have a complex requirement to build a report. Hoever I noticed that it is not possible with standard report. Can you help me the best way to create this complex report using VF page.
Left side colum has Field Labels. and we need to caluculate each field value Percentage based on the value selected on the total reocrds which users attened that specific field.
Thanks in advance.
Reagrds,
Ajay
Are you looking for something like a field usage report?
This is not field usage report. For field usage I have already used Field trip. This is specific to data.
Example:
Record1:
Field1 = 0
Record2:
Field1 = 1
Record3:
Field1 = 2
Record4:
Field1 = 3
Record5:
Field1 = 4
Now I have to calculate the % of 0 , % of 1 and so on
Field 1 calculation:
%of 0 (Not all valuable): Total Records/ Total Field1 records with value 0
%of 1 (Slightly valuable): Total Records/Toal Field1 records with value 1
%of 2 (Moderately): Total Records/ Total Field1 records with value 2
%of 3 (Very valueable): Total Records/Toal Field1 records with value 3
%of 4 (Extremely): Total Records/ Total Field1 records with value 4
Field 2 calculation:
%of 0 (Not all valuable): Total Records/ Total Field1 records with value 0
%of 1 (Slightly valuable): Total Records/Toal Field1 records with value 1
%of 2 (Moderately): Total Records/ Total Field1 records with value 2
%of 3 (Very valueable): Total Records/Toal Field1 records with value 3
%of 4 (Extremely): Total Records/ Total Field1 records with value 4
Hope I did not confuse you.
Field 3 calculation:
%of 0 (Not all valuable): Total Records/ Total Field1 records with value 0
%of 1 (Slightly valuable): Total Records/Toal Field1 records with value 1
%of 2 (Moderately): Total Records/ Total Field1 records with value 2
%of 3 (Very valueable): Total Records/Toal Field1 records with value 3
%of 4 (Extremely): Total Records/ Total Field1 records with value 4
And so on...
Hope I did not confuse you.:)
Regards,
Ajay