Formula for percentate on Y-Axis in a line chart

[Anthony stark]

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

[Ajinkya Gutti]

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]

[Anthony stark]

Thanks Agutti, this worked