Calculation of vehicles types (or anything)

[#1]

Hi all.

Please look at attached pic.

I would like to know how to make this happen in QV.

Best regards

/Mats

[kaushiknsolanki · Accepted solution]

Hi,

     Try this in QV

     Create a chart with dimension as Month and expression as count(distinct Type)

Regards,

Kaushik Solanki

[fdelacal]

IN CHART ADD DIMENSION

MONTH

AND EXPRESSION

COUNT(DISTINCT(TYPE))

hOPE IT HELPS YOU

[#4]

Hi again and thanks for the quick answer!

I have to ask again, this time with a third column to concider:

Thanks in advance

/Mats

[kaushiknsolanki]

Hi,

     Only include Env as dimension.

Regards,

Kaushik Solanki

[#6]

Hi

Ok, now im getting there!

I have now a formula that is: if(Env='ground',count (distinct (Type)))

This is working fine and with the real table i get 3 as the answer.

Now i want to calculate it in percent where i have 25 different Type.

I set it up like this:

NUM(100-(if(Env='ground',count (distinct (Type)))/25)*100,0)&'%'

but then i don't get it right. The answer should be 88%

/Mats

[#7]

Hi again

I got it!

I had to present the number as Percent and then everything fell in place!

Best regards

/Mats