Forum Discussion
Creating Quartile Labels as a Calculated Column
Hello,
I have a table with data that includes a column Total Visits. I want to create an additional calculated column referencing the Quartile that that row's visit number falls in. The end goal is to use the quartile as the legend on a bar chart.
Thank you,
Ashley
Hi Anonymous ,
What is your excepted output? I cannot catch the quartile labels here? Did you want to get the quater of a year like the formula as below.
Column = FORMAT('Sheet1'[Metric Date],"Q")
3 Replies
Hi Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.
Sample data here: https://drive.google.com/file/d/1NJ3jeTWdDOQvD6aldC1Bnk8Hjl9-Jf5l/view?usp=sharing
Thank you!
Hi Anonymous ,
What is your excepted output? I cannot catch the quartile labels here? Did you want to get the quater of a year like the formula as below.
Column = FORMAT('Sheet1'[Metric Date],"Q")