Anthony stark Posted April 16, 2020 Share Posted April 16, 2020 Hi Experts I have a column of data called "Colors" and a date column. There are only two values in the "colors" column (Red and BLUE). I am trying to ceate a LINE CHART that shows the percentage of RED only in the data table daily. How do i write the expression (formula) in the Value axis to achive this goal I have attached the sample data in a spreasheet to this question. Thanks in advance Link to comment Share on other sites More sharing options...
Ajinkya Gutti Posted April 16, 2020 Share Posted April 16, 2020 Using if/else or CASE to find the count of red should work. Example expression using 'CASE' for you example data Sum(case when ="RED" then 1 END) * 100 / Count() as [Percentage of Red] Link to comment Share on other sites More sharing options...
Anthony stark Posted April 17, 2020 Author Share Posted April 17, 2020 Thanks Agutti, this worked Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now