I want to create a line chart that contains "closed cases", "new cases", "cases in process", which x and y axis should I choose? In x axis, I don't have choice that only means date, they are all "create date", "closed date"?
Should I create some new fields? OR use some formula to solve my problem?
Qrew Legendnp,
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！
Qrew Legend
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.
