dear all,
got stuck doing a dashboard to describe the level of customer base utilization. The trick is that customer base was increasing every quarter.
I made a graph in excel to show the final view I want to build, I d like to build it on the region and territory levels as well.
Any help is appreciated - u guys a so helpful. do not feel I am on an island anymore
Serge
Hi Serge
"do not feel I am on an island anymore"
Yes, we are always here to support you
To handle two different dates. you can start with pivoting data.
From edit Data source, pivot data, then follow the instructions.
[Date Converted]
if [Pivot Field Names]="date" then
IF INT(MID([Pivot Field Values],2,1 ))=1 THEN DATE("1/1/" + RIGHT([Pivot Field Values],4))
ELSEIF
INT(MID([Pivot Field Values],2,1 ))=2 THEN DATE("4/1/" + RIGHT([Pivot Field Values],4))
ELSEIF
INT(MID([Pivot Field Values],2,1 ))=3 THEN DATE("7/1/" + RIGHT([Pivot Field Values],4))
ELSEIF
INT(MID([Pivot Field Values],2,1 ))=4 THEN DATE("10/1/" + RIGHT([Pivot Field Values],4))
END
else date([Pivot Field Values]) end
[Count Hospital Purchase]
countd(if [Pivot Field Names]="date" then [Hospital Number] end)
[Countd Hospital Approved]
countd(if [Approved Date calc]<=[Date Converted] then [Hospital Number] end)
[Percentage]
[Count Hospital Purchase]/RUNNING_sum([Countd Hospital Approved])
Thanks,
Shin
