How to show Million (M) or Thousand (K) in Y axis in iDempiere Billboard .js

[Tanmoy Prosun Dey]

Dear All,

I am trying to find a solution to show Million (M) or Thousand (K) in the Y axis in iDempiere Billboard .js, but I failed. Would anyone be able to help me with this?

Thanks in advance,

Tanmoy

[Deepak Pansheriya (Logilite.com)]

In your query, you can use a multifilcaiton factor on amount.

[Tanmoy Prosun Dey]

Thanks for your reply. Would you please guide me on where I have to make the changes? Because I do not know from where the Y-axis values come. 

Regards,

Tanmoy

[Tanmoy Prosun Dey]

Dear All,

Please help me how to show Million (M) and the comma after thousands like Metabase in iDempiere billboard.js. Please see the attached image also. Please assist me with a solution.

Regards,

Tanmoy

[Tanmoy Prosun Dey]

Hi Hengsin,

Please help me regarding this long-awaited issue.

Regards,

Tanmoy

[Norbert Bede]

hi,

What you want, need to change the model of chart tables and implementation, not easy. (i suppose the solution add chart "attribute" per "dimension" and "measure" where you can define attributes like suffix -M and multiplier/divider (similar eg. to klipfolio or other bi tools). However as Deepak suggest above you can do the trick - divide value by million in the chart source, then add to the title Amt (Mill.)

Our changes for charts and dashboards, you can find here:

https://wiki.idempiere.org/w-en/images/1/13/Bahrain-2023_norbertbedeux-2.pdf

We plan to commit multi-dashboard, first then later commit chart improvements.

Norbert