forums

Use these forums to ask questions and discuss Tableau.

Data Calculation

Posted June 17th, 2008 by oruvan
in Count.. Dates & Times

I have an excel file with below metadata...

How would I create a tableau sheet which shows by month/year the number of cases open that month and closed that month.

The desired output is as follows

PERIOD || #ofOpen || #ofClose || Backlog

01/2008 10 8 2
02/2008 10 9 3
.
.
.

Add new comment

Comments

On June 20th, 2008 Erin Easter said:

Hi,

I'm not sure if I understand your example entirely. Does your excel file look like:

Period || #ofOpen || #ofClose || Backlog

01/2008 || 10 || 8 || 2
02/2008 || 10 || 9 || 3

If so you should be able to create that view pretty easily by placing the Period field onto the Rows shelf. You can drill down to the Month level by clicking the little plus sign on the field when it is on the shelf.

Then you want to drag the #ofOpen measure to the text shelf. And then you can drag the #ofClose measure and drop it right on the text table you just created. That will add both measures to the view.

However, I'm guessing that the "period" field doesn't include the month and year but rather some sort of representation of that. Can you be more specific about what your underlying data is like and what you want to do with it?

reply
On June 21st, 2008 Guest (same as oruvan) (not verified) said:

Source fields in Excel are as follows :-

How do I create a report that lists the number of cases opened and closed in the given month, I am able to do two reports one for count of open cases and one for closed cases, not able to do both the measures in the same report.

Desired output should be

<#ofCases Opened><#ofCases closed>

reply
Syndicate content Subscribe to the comments on "Data Calculation"