Forum Discussion
Line and Clustered column chart
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
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
4 Replies
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Great, thanks much ALLUREAN , that worked! 🙂