How to remove Total field in chart, for example I added data like completed, pending and overall here I am also getting total(by default added by chart- waterfall) which is invalid. Issue is over all = completed and pending hence Total added by chart is Completed,pending,overall which is not required/invalid.
Tried other chart which does not suite the requirement because in this data cut i do not have x axis or y axis value.
Thank you for the detail instruction. In my waterfall chart I clicked on pencil edit and found only Y axis - under that there is no option called sort to select or unselect. Available options are :- 1.Show labels 2. Show grid lines 3.Axis step.
Wierd! Can you please share a expanded snapshot of the same? Quicksight being a cloud native service, we all should be seeing the same interface I believe. I hope you have values under “category” and “value” field wells .
Thanks @nandu for sharing. I see that instead of breaking down a single metric by “Category” you are putting multiple measures under “Value” field well. If you see that’s why you don’t have anything under “Category” field well and 4 measures under “Value” field well. Hence, I believe in your case the sorting will be controlled by in which order you are organizing those measures in the “Value” field well. See the below snapshot for more detail.
When you say, data get updated, if there’s a new measure that means your dataset metadata is getting changed (i.e. addition of column). In that case, you have to manually add and adjust its position. However, if underlying data is getting refreshed and you still end up having those 3 or 4 measures (that you projected in Waterfall chart), then there’s no need to do any manual tweaking. Hope, this makes sense! Thank you!
You are welcome! I am glad that I could help you. It would be awesome if you can close the other thread (which is similar in nature) as well marking the suggestion as solution to ensure that we don’t have any unresolved orphan thread. Thank you!