np,
make three formula fields which calculate to a 1 or null like this
iF([Status] ="Open", 1)
Repeat for the other two Statuses.
Then make a Line Chart report. Select the first calculated field as the Y axix. Then hover beside that report element to get the green plus to add another Y axis line.
Repeat for the third calculated Status count.
Thanks Mark, but my problem is not solved, I still have some questions.
1. What do I choose for the X-axis？
2. Should I create these three fields or modify them?
3. What should I do if I don't have the field I want when I choose the Y-axis?
4. What if I select Create date on the X-axis and I want to show a line graph of the closed case?
I'd appreciate it if you could help me out！
1. What do I choose for the X-axis？Typically a date field or a date /time field.
2. Should I create these three fields or modify them? Create three new fields.
3. What should I do if I don't have the field I want when I choose the Y-axis? Create the three new fields.
4. What if I select Create date on the X-axis and I want to show a line graph of the closed case? Select the Y axis to be the closed case formula field.
Thank you very much Mark, I will try to solve my problem first！
