Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Please look at attached pic.
I would like to know how to make this happen in QV.
Best regards
/Mats
Hi,
Try this in QV
Create a chart with dimension as Month and expression as count(distinct Type)
Regards,
Kaushik Solanki
Hi,
Try this in QV
Create a chart with dimension as Month and expression as count(distinct Type)
Regards,
Kaushik Solanki
IN CHART ADD DIMENSION
MONTH
AND EXPRESSION
COUNT(DISTINCT(TYPE))
hOPE IT HELPS YOU
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
Hi,
Only include Env as dimension.
Regards,
Kaushik Solanki
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
Hi again
I got it!
I had to present the number as Percent and then everything fell in place!
Best regards
/Mats