Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I would like to know if it´s possible to show in a graph a value of a dimension wich is restricted in the set analysis.
For. Example:
I want to know the number of agents thath sold something in June
Count(${<Month={'June'}>}Agent)
But, even if an agent did 0 sales in June, I would like to show it in the table with a 0.
I tried checking the option in presentation os "Delete 0 values".
But my agent with 0 sales doens´t show.
Show all values in dimension should work, but here's another trick
Modify expression to multiply by avg(1)
= Count(${<Month={'June'}>}Agent) * AVG(1)
Is the data really 0 or is it missing?
If it is populated in the table as 0 then this should work (unchecking supress 0 values) but if there is no record for an agent in June then it won't show at all.
You should add this 'missing' data to the table as a 0 value to make it work
Assume, you have data like below
LOAD * Inline [
MonthName, Agent
Jan, AAG1
Feb, AAG2
Mar, AAG3
Apr, AAG4
May, AAG5
Feb, AAG6
Mar, AAG7
Jun, AAG8
Jun,
Jun, AAG10
Nov, AAG11
];
From Here, For JUN you want to see 2 / 3 ??
If it is 2 -- Count({<MonthName = {'Jun'}, Agent -= {''}>}Agent)
If it is 3 -- Count({<MonthName = {'Jun'}>}Agent)
uncheck, suppress zer values and in dimension tab, check show all values
Hi Guillermo
Maybe character $ after the brace?
Count({$<Month={'June'}>}Agent)
Regards,
Andrey
Show all values in dimension should work, but here's another trick
Modify expression to multiply by avg(1)
= Count(${<Month={'June'}>}Agent) * AVG(1)
Uooh! funny trick hahaha, it worcked very well!!
Thank you very much Vineeth.!!