Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I need to create a line chart that shows proportional percentages across the chart (i.e. the % should add up to 100)
The calculated dimension is:
=If([Duration]>Time('0:30:00','h:mm:ss'),
IF([Type]='Type1',Hour([Start Time])))
Expression (returns incorrect value):
count([PrimaryKey]) / count(TOTAL [PrimaryKey])
I tried using set analysis but only suceeded partly. The condition for [Type] works but not for [Duration]:
count([PrimaryKey]) / count(TOTAL {<Type={'Type1'}, [Duration]={">Time('0:15:00','h:mm:ss')"}>} [PrimaryKey])
Appreciate your responses, thanks!
Try it like
count([PrimaryKey])
/
count(TOTAL {<Type={'Type1'}, [Duration]={">$(=Time('0:15:00','h:mm:ss') )" }>} [PrimaryKey])
Regards
Anand
And another one is
count([PrimaryKey])
/
count(TOTAL {<Type={'Type1'}, [Duration]={'>$(=Time('0:15:00','h:mm:ss') )'}>} [PrimaryKey])
Regards
Anand
Hi Anand,
Thanks for your responses. I tried both methods and even assigned =Time('0:15:00','h:mm:ss') to a variable (hoping that might help). Unfortunately none of the options work. "No data to display" is the message shown on the chart.
Hi Neetha,
I'm using the TOTAL keyword but it doesn't work in my case because I have a calculated dimension. It looks like the person in the link you provided isn't using a calculated dimension.
Maybe I'm missing something?
Thanks.
Hi Aviral,
Please try by creating new expression in expression tab:
count([PrimaryKey])/count(TOTAL {<Type={'Type1'}, [Duration]={'>$(=Time('0:15:00','h:mm:ss') )'}>} [PrimaryKey])
Check relative button (or) Number Tab - Select fixed option and check show in percent option.
Regards
Neetha