11 Replies Latest reply: Nov 25, 2015 10:56 AM by daniesh shaikh

# add two dimension and expression in one graph

Hi ,

I want to create graph where in i want to show two dimensions and expressions.

Employee not completing 8 Hrs and Dept not completing 8 hrs with percentage.

Dept whose 8 hrs percentage will less than 20%, Must be in Red same way more than 20% will be in Yellow. and more than 50% in Green.

Can i show it is same graph.

I have attached the data.

DEPT_NO      DEPT_NAME

1                    Chairman

101                HR

102                IT

103                Inspector

120                Finance

121                Quality

Thanks and Regards,

• ###### Re: add two dimension and expression in one graph

When it comes to:

1 Expression and 2 dimension

or

2 Expression and 1 Dimension...

Scatter/Grid Chart are the best options..

• ###### Re: add two dimension and expression in one graph

Hi Balraj,

Thanks...

I am looking for the expression where employees are not completing 8 hrs. If the percentage is less than 20%, it should be in RED color and where above should be green please help me writing the expression for the same.

• ###### Re: add two dimension and expression in one graph

Hi Shaikh,

You have any idea to convert time into percentage.

how to find 20% of 8 hours

• ###### Re: add two dimension and expression in one graph

Hi raman,

It is same mathematical expression you need to do for 20% of 8

(20/100) * 8 = 1.6hrs...Hope this helps..

Thanks,
V.

• ###### Re: add two dimension and expression in one graph

Hi

You did not get my point here suppose every day employees are going to office, They have to complete 8 hrs. Sometime they go early. percentage i can find out by using below expression

Count(TOT_DUR)>='08:00'/Count (TOTAL TOT_DUR)*100

Now i am getting a percentage now i don't know how  to get get a different colour for different percentage.

I want to show dept and emp percentage with color on the same graph.

Hope this help.

• ###### Re: add two dimension and expression in one graph

Hi,

Can u clarify the following points,

1. do u want to present both the dimensions at a time?

2. if yes which type of graph u want to use in ur presentation

BR

SK

• ###### Re: add two dimension and expression in one graph

Hi,

i think this is hepfull for u

Expression:

=if(TOT_DUR<Interval(0.50 * Time('8', 'h')/24, 'hh:mm:ss'),red(),

if(Interval(0.50 * Time('8', 'h')/24, 'hh:mm:ss')>TOT_DUR,yellow(),Green()))

• ###### Re: add two dimension and expression in one graph

Hi

I am trying to show the employees whose percentage is less than 20% must be green colour.

I am using the below expression to get the count of employees completing completing 7 Hrs.

count({1<TOT_DUR={'>=07:00'}>} TOT_DUR)

for percentage, I have to divide by total(TOT_DUR)

count({1<TOT_DUR={'>=07:00'}>} TOT_DUR)/count(TOTAL TOT_DUR)

I have attached the screenshot. I am using Pivot table. But i want to show the same with percentage and with colour on other graph like grid graph one which is suggested by Balraj.

Thanks

• ###### Re: add two dimension and expression in one graph

Hi,

dimension

Departement

Employe

];

And then in you chart, you can use these two separated dimensions :

• ###### Re: add two dimension and expression in one graph

Hi

finally i have got the correct percentage to display on pivot table.

Please assist me how to display the same on graph where employees percentage is less than or equal to 20

should be display in RED and above 20% Yellow and 40% green in guage graph or any other graph with employees/

Thanks