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.

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

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.

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

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

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

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?

Thank you in advance!

Best regards,

Oscar

Dear Braj,

If removing the code does not restore the panel try to clear your profile data by going into the profile and choosing the "Restore default settings" option. 

Best regards,

Angela

Angela Reyes,

 Thank You for this info but as i tried it on my local instance and my client asked us to hide the communication panel so please suggest any work around to do and an easy way to restore it

Braj Raj singh Kushwaha,

It is now not clear what your task is. The panel must be hidden forever or on specific conditions?

Angela Reyes,

The panel should be hidden forever.

In case we need it again then we should be able to make it visible as it was before.

And by using the above article I was able to hide it but when I tried to make it visible it was still hidden

Braj Raj singh Kushwaha,

Can you send here the code you used to make it visible? 

Angela Reyes,

diff: /**SCHEMA_DIFF*/[

                {

                    "operation": "remove",

                    "name": "communicationPanelAll",

                    "propertyName": "items",

                    "values": {

                        "id": "communicationPanelAll",

                        "selectors": {"wrapEl": "#communicationPanelAll"},

                        "itemType": Terrasoft.ViewItemType.CONTAINER,

                        "wrapClass": ["all"],

                        "items": [],

                        "tips": [],

                        "markerValue": {"bindTo": "CommunicationPanelMarkerValue"}

                    }

                },

Above code to hide

This code to unhide it or make it visible

diff: /**SCHEMA_DIFF*/[

                {

                    "operation": "insert",

                    "name": "communicationPanelAll",

                    "propertyName": "items",

                    "values": {

                        "id": "communicationPanelAll",

                        "selectors": {"wrapEl": "#communicationPanelAll"},

                        "itemType": Terrasoft.ViewItemType.CONTAINER,

                        "wrapClass": ["all"],

                        "items": [],

                        "tips": [],

                        "markerValue": {"bindTo": "CommunicationPanelMarkerValue"}

                    }

                },

Just made changes to this part only

Braj Raj singh Kushwaha,

There is an easier way to hide the CTI panel. Please create a replacing view model for "Communication panel schema":

with the medhod like this one:

init: function() {
					return false;
					}

As a result once the changes are saved and the page is refreshed the communication panel won't be initialized:

To restore the panel please remove all your customizations related to CommunicationPanel and add them according to my instruction.

Best regards,

Oscar

Oscar Dylan,

Hi Oscar,

As I tried your approach it is working fine thank you very much 

But to restore the panel I removed all customization and refreshed the whole site, Restored the default setting from the user profile still panel was not restored.

Please let me know how to restore it.

Thank You

Hi,

You need to take a look at the SELECT query that is sent to the database when specifying a filter using this custom filtration by dates and see the SELECT query text. Try adding indexes (see the "Adding indexes to the object" paragraph) for the StartDate column and also for other columns that are used in the ESQ:

Also try parsing queries themeselves using SQL-server profiler and add indexes to the columns that are mentioned in the WHERE and OrderBy clauses. Indexes should help in optimizing SQL-queries (since the problem is definitely in them).

Best regards,

Oscar