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
- ALLUREAN
Solution Sage
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/
- ALLUREAN
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! 🙂