Question

How to show the total amount in a column chart with tooltip hover text

0

Hi all, I have an entity with an attribute "ProjectName" and another attribute "Amount". I need to show the total amount (sum of all amounts) as a tooltip doing hover in a column chart. For some reason, the text value showed is the amount of one of the entries, not the total although the column represents the total height in the Y axis. Could you help me? Thanks. Mario

asked 2024-12-05

Mario Escribano Estoquera

3 answers

Mohammad Saqib · Answer 1 · 2024-12-05

Hi Mario,

Just take a NPE & take an attribute(Int or decimal) totalValue -> go to your overview page or where you want to show the tooltip -> take a dataview select source as microflow -> go to your microflow retrieve your persistable entity data(ProjectName,Amount) -> take aggregate list actvity pass your retrieve list & select sum and select your amount attribute -> create your NPE object & pass the calculated sum value inside this & return the object.

Go to page -> inside data view take datagrid2 retrieve your data as you want -> take a custom column inside datagrid2 for amount attribute -> take tooltip inside this -> in the tooltip pass

Total Amount {1} & select TotalValue attribute from dataview.

Hope you like the answer.

Screenshot 2024-12-06 014830.png Screenshot 2024-12-06 014844.png Screenshot 2024-12-06 014857.png

Screenshot 2024-12-06 015345.png

Mario Escribano Estoquera · Answer 2 · 2024-12-20

Hi Mohammad,

thanks for your answer but it doesn't solve my problem. With you help, I have got to show the total amount but as you can see in the picture, it uses it for all columns not taking in account the year.

These are the entities I'm using.

Do you have any ideas on how to make it work?

Thanks in advance.

Mario Escribano Estoquera · Answer 3 · 2024-12-23

Hi Mohammad,

It finally works. It was a misunderstanding.

Thanks a lot.