Dashboard does not show data on preview

[Former Member]

Hello,

I have created a standalone dashboard chart wherein the data is just inside the excel file.

The formula i used for a certain group of cells is VLOOKUP.

When i link the chart to the cells, the chart shows data properly. But when i click on preview, there is no data.

Can anyone help me with this?

Thanks in advance,

Wynn

[Former Member · Accepted solution]

Hello SAurabh,

PLease see attached.

[former_member182541 · Accepted solution]

vlookup seems to perfect, can i have the "ALU MONTH COMPARATOR" tab screenshot all well.

[saurabh_sonawane · Accepted solution]

I think u have to do some changes in Vlookup

vlookup('Alu month comparator!

q1,'Alu month comparator!$A$1:$B$100,2,false)

press F4 in the the bold area

and make sure that

Alu month comparator!q1 = Alu month comparator!A1(showed have some format and some value also)

[Former Member · Accepted solution]

Hello Suman,

Raw Data ALU is where the actual data is.

[saurabh_sonawane · Accepted solution]

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

NOTE

lookup_value will be compared with the table_array 1st column

so we should always have some value in lookup_value and table_array 1st column

[saurabh_sonawane · Accepted solution]

hi

just do some change in your formula of Vlookup

vlookup('Alu month comparator!

q1,'Alu month comparator!$A$1:$B$100,2,false)

press F4 in the the bold area

[former_member182541 · Accepted solution]

Dear Wynn,

Its getting into loop, i hope you have used many tabs of data to achieve this, but at the Run time i am not sure whether the value is there in Q1 cell and subsequent cells, unless until you refer the snapshot data we cannot understand what happens in the background.

--SumanT

[Former Member · Accepted solution]

Hello Suman,

Q1 =CONCATENATE(O1,P1)

O1 =IF(MONTH(NOW())-1=0,12,MONTH(NOW())-1)

P1 =IF(O1=12,RIGHT(YEAR(NOW()),2)-1,RIGHT(YEAR(NOW()),2))

now for $A$1:$B$100

Column A is =IF('Raw Data ALU'!C2="","",CONCATENATE(MONTH(DATEVALUE('Raw Data ALU'!C2&" 1")),RIGHT('Raw Data ALU'!D2,2)))

Column B is =IF('Raw Data ALU'!E2="","",'Raw Data ALU'!E2)

All of the data are inside Raw Data ALU. They are just numbers, Month and year there.

Here is a sample of the first raw of data:

ID	Account	Month	Year	SOBR
1	ALU	November	2012	8.604346

[Former Member · Accepted solution]

Hello Saurabh,

Thanks. Did that already the chart still has no data

[arijit_das · Accepted solution]

The problem is with DATEVALUE function. Try to avoid it by some workaround (may be a lookup from hardcoded {month-name,month-number} data grid).

[former_member182541 · Accepted solution]

Hi wynn,

As arjit explained this could be due to date value function, if you could change the file extension from .xlf to .txt and you can attach it here. we can explore it in detail or can you mail the source file to my mail id.

--SumanT

[Former Member · Accepted solution]

Hello Arijit,

Thanks for this. THe data showed after removing the DATEVALUE() function. thank you!

[Former Member · Accepted solution]

Hello Suman,

I have removed the datevalue and it did work. Thanks

[saurabh_sonawane]

can you please attach the screenshot

[saurabh_sonawane]

can you send the screen shot of excel file

[former_member195446]

Hi Wynn,

are u using any flash variable connection?

if not you can try the below:

take excel snapshot in preview mode you will come to know whats happening in run time and test some values in excel sheet.

if values are coming in excel snapshot,then try to remap the chart.

[Former Member]

Hello Prasad,

By snapshot do you mean remove the formula and replace it with the value?

I've tried remapping it as well at creating a new chart and mapped it there but it does not seem to work.

The chart is still not showing data when in preview mode.

[former_member182541]

while previewing the dashboard do the below mentioned method to take the snapshot of data in background. which gives you idea what happens in spreadsheet.

[former_member195446]

Hi Wynn,

Can you share the screen shot after taking snapshot in Preview Mode.

and also please check the excel cells that u have written for VLOOKUP are used for any Destination cells of any component.

[Former Member]

Hello Prasad,

Actually i see no difference in the snapshot and the actual excel file.

[former_member182541]

Not sure about the vlookup and logic you applied, can you please attach the screenshot or if you can attach the source file, it will be helpful to explain in clear.

change the source file extension from .xlf to .txt and attach it.

[Former Member]

Hello,

I would not be able to upload the file but here is a screenshot. This is the chart when it's in design (not preview) the data is showing correctly.

Here is the chart when on preview:

You will see that the bar chart is not showing the data anymore. The difference between the bar chart and the line graph is that the line (blue) is hard coded. And that the chart is using a formula. The formula used is VLOOKUP. When i replace the formula with hardcode (number) the data can be seen. Other functions used were CONCATENATE and MONTH and DATE.

All of which are supported by Dashboard Design. By the way the version is 6.0.

[former_member182541]

for sure your lookup is not happening well, take the snapshot of the excel and check what happens in background.

[arijit_das]

Are you using any type of connection ?

[Former Member]

No. All of the data are inside the excel file. No external connections