Line and Clustered column chart

[Anonymous]

Hello

I am trying to create a line and clustered column chart.. I have 4 fields(field1,field2,field3,field4) that I want to use.. Field1, Field2 and Field4 are of type 'number', and Field 3 is a 'text'. Field 2 is a measure I had created

1) Legend(field3)

2) X axis(field1)

3) Y axis(field2)

4) Line(field4)

When i use the 3 fields as part of the legend, x axis and  y axis, I am getting what I want, but when i use the line in the 'line values' portion of the report, the field gets defaulted to count(field4). But I want it to display the absolute value of field 4. Am I using the wrong type of report/chart? Please help

[Anonymous]

Hi @ALLUREAN , I dont get an option to 'Sum' for some reason..

[ALLUREAN · Accepted solution]

Is this a text field? If contains numbers, you should change formatting from text to Number in order to have summarization options (on my screenshot, go to the left Data type)

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[Anonymous]

Great, thanks much @ALLUREAN , that worked! 🙂

[ALLUREAN]

Hi, @Anonymous 

Change the default summarization, go to field4 in your chart, right click and select Sum or if you want you can change it at all.

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/