##dashboard | Community Creatio

Question

11:15 Feb 25, 2021

Hi Team,

Have a query regarding widget we design in the dashboard can be read filter from the dashboard to modify our output on the widget.

If it is possible please share a scenario with implementation

This will be really useful to meet some business requirement

Thank You in Advance

4 comments

Bogdan Spasibov

19:39 Mar 01, 2021

Hello Braj,

Unfortunately, I was not able to find an example you requested but you can always check all the needed parameters in the Academy Article that is related to Dashboard widgets and their customizations.

Best regards,

Bogdan S.

Braj Raj singh Kushwaha

06:22 Mar 02, 2021

Hi Bogdan,

we need to calculate the loss ratio from some data sets

ex. we have 100 records out of which 70 has profit field filled and 30 has loss field filled.

Based on filtration we performed on the dashboard/pivot report we get N records (N can be 10,20,30 or any number )

Now I want a loss ratio (loss/profit) of those N records only.

in this case loss ratio = sum of loss from filtered records /sum of profits from filtered records.

Hope you got the requirement if case any query please contact me.

Thank You

Bogdan Spasibov

11:17 Mar 08, 2021

Braj Raj singh Kushwaha,

Your business task is quite clear but still, there is no existing example of code that you can use. Please, check the article that I sent before and do all the required development.

Best regards,

Bogdan S.

Braj Raj singh Kushwaha

10:40 Mar 17, 2021

Bogdan Spasibov,

Thank You so much

your article was very useful It helped me to do some other requirement.

Even fund some app that was free to use and my task was completed using them.

Once again thank you so much

Show all comments

Question

Can be perform calculation on Dashboard Widgets

Braj Raj singh Kushwaha

14:27 Feb 22, 2021

Hi Team

I need to perform some calculations based on data in the dashboard we did some implementation in the pivot table. we are able to get sum 2 fields based on all filter but further using that calculation to display the ratio of that 2 calculation is where I am stuck.

I am using https://academy.creatio.com/documents/technic-sdk/7-16/adding-custom-da…

To come up with some approach but didn't succeed anyone please suggest a solution to this requirement

Any workaround will be appreciated

Thank You

3 comments

Oleg Drobina

19:44 Feb 22, 2021

Hello Braj,

Can you please provide more information on what task do you want to cover? We need some practical examples to think about the solution.

Also have you tried to use this marketplace addon and does it fit your business task?

Best regards,

Oscar

Braj Raj singh Kushwaha

06:02 Feb 23, 2021

Hi Oscar ,

we need to calculate loss ratio from some data sets

ex. we have 100 records out of which 70 has profit field filled and 30 has loss field filled .

Based on filtration we performed on dashboard/pivot report we gets N records (N can be 10,20,30 or any number )

Now I want an loss ratio (loss/profit) of those N records only .

innthis case loss ratio = sum of loss from filtered records /sum of profits from filtered records

Hope you got the requirement if case any query please contact.

Thank You

Oleg Drobina

17:46 Mar 04, 2021

Braj Raj singh Kushwaha,

Hello,

Unfortunately it's not quite clear what task do you want to achieve. Can you please add some screenshots of what is the desired result? Also can you please specify why the formula column type is not an option in our case?