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?
+22np,
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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
