NA Student Dashboard Challenge – SAP Crystal Dashboard Design Questions

[Former Member]

Students, post your SAP Crystal Dashboard Design questions for the North American Student Dashboard Challenge here.

Good luck with the challenge!

[Former Member]

Hi I have a small question. Of course competition is over, however I still have to comeout of the crystal hangover !

When I am using slider for increasing or decreasing no. of individuals, it is showing 10.5, 11.5 12.5 etc, logically an individual cannot be fraction. I verified the data input in excel and I marked the cell properties as numeric with out decimal, also in  dashboard I changed properties to numeric with out decimals. I wonder why slider is still showing as 10.5 , 11.5 etc. Interestingly the problem is with this one slider.  I could resolve much bigger logics but this simple problem is bothering me.

[Former Member]

Hi Kumar,

In the Behavior tab of the compenent, do you have the "Increment" set to a whole number?

Regards,

Pari

[Former Member]

Hello,

When using components such as sliders and spinners, you link that component's data to a cell on your spreadsheet. When I link it to a cell that contains a formula, dashboard design doesn't let me move the slider to change the value when I preview the dashboard. In fact, it automatically greys out the option to make the component interactive. Is there anyway around this?

Thanks,

Alex

[Former Member]

HI Alex,

When using items that write-back values to excel like sliders & spinners (and basically any other selector) you cannot insert the selected value into a cell that contains a formula. The labels, ranges, etc can all be linked to cells with formulas but the cell containing the value selected by the component should not have a formula in it.

If you explain the functionality you're attempting to get working and why you want the formula I can try and provide some suggestions on how to make it work.

Jeff

[Former Member]

Thanks for your response, Jeff.

We are attempting to create 2 combo boxes, one with 9 variables, and one with 5 different years. Based on the selection, a slider appears, allowing the user to edit these variables to input information about these variables in future years. The formula in the cells that we are trying to use happens to be a regression formula (specifically the FORECAST formula). We want to be able to set certain values for income and expense variables in future years and see how it affects the overall regression.

We've already devised a system to make the proper slider appear based on the selections in the combo boxes, so that's not the issue here.

Thanks,

Alex

[Former Member]

Alex: Wow that really a complex task. The kind of question that you asked reflects the intensity of competition. Wish you all the best!

Regards

Kumar Simhadri

[Former Member]

Hi Alexander,

When using selectors, bind the selected value to a cell (with no formulas in it). Then, in another cell that does have a formula, reference the bound cell. Excel should do the logic/formulas. What do you mean you have "a combo box with 9 variables"?
Regards,

Cuen

[Former Member]

KPI-4:  Average size gift:

We were asked to provide a "pick list" to select contributor.  Is there any criteria on the basis of which we are supposed to choose donors for this list? Or we can select donors for this list on a basis that we think is reasonable to show the trend.

Also, dashboard is NOT allowing us to take more than 8 or 10 customers for the pick list, can we pick just 8 donors of our choice?

[darren_louie]

Hi Kumar,

Another good question!

When I say pick list, its a generic term that I use to refer to a type of selector that would help you accomplish your goal of filtering out the data.  It could be an accordion menu, combo box, list box, list view etc...

Dashboard should allow you to take more than 8 to 10 contributors as well.

Regards,

Darren