Dashboard Chart Value(amount) Showing Without Comma's

ERPNext
, , , ,
1

Hi Community,

I have created dashboard chart for opportunity doctype based on owner, and their sum of opportunity amount. But, its shows like 3092292.00 instead of 3,00,000.00. I attached image below. Please, suggest me a Solution.

img 1

img 2
img 21063×519 38.4 KB

2

PR already raised so please check it.

3

I Can’t able to Understand.

4

where i put the code? its from backend?

5

Please check the code changes in the Pull Request.

6

To be honest, I dont know what to do . will i use any client script?

7

If you don’t understand then wait for PR approval.

8

Brother, Can you please tell me how to achieve this in JSON?

9

It’s not a json code, it’s a js code. you have to update the code in the chart_widget.js file.

10

Is the below is correct?

frappe.ui.form.on('Dashboard Chart', {
    refresh: function(frm) {
        // Iterate through the charts in the dashboard
        frm.fields_dict.charts.grid.grid_rows.forEach(row => {
            if (row.chart.title === "BD Wise Enquiry Value") {
                // Update tooltip options for the specific chart
                row.chart.options.tooltipOptions = {
                    formatTooltipY: (value) => {
                        // Format the value to include commas and two decimal places
                        return frappe.format(
                            value,
                            { fieldtype: 'Currency', options: { precision: 2, always_show_decimals: true } },
                            { inline: true }
                        );
                    },
                };
                // Refresh the chart to apply changes
                row.chart.refresh();
            }
        });
    }
});
11

It’s does not worked in the client script, it’s a core code.

frappe/public/js/frappe/widgets/chart_widget.js

Open the chart_widget.js file and update the changes that i shared in the previous post.

1 Like
12

Ok. Thank you.