Forum Discussion
Solved
Pareto Chart
Hi all, I have been ask to create a Pareto chart for incoming invoices. They want to see the amounts in categories: 0-50,50-100,100-250,250-500 ect. I have a table: Invoice number - Amo...
MRR , Have create a column like this
Switch ( True (),
[Amount] <= 50 ," 0 -50",
[Amount] <= 100 ," 50 -100",
// Add other
"Others" //default value
)If the amount is the measure then you need dynamic segmentation
refer: https://youtu.be/CuczXPj0N-k
amitchandak
Super User
Super UserMRR , Have create a column like this
Switch ( True (),
[Amount] <= 50 ," 0 -50",
[Amount] <= 100 ," 50 -100",
// Add other
"Others" //default value
)
If the amount is the measure then you need dynamic segmentation
refer: https://youtu.be/CuczXPj0N-k
Thank you!!
That did it!