Skip to Content
avatar image
Former Member

Add columns in excel datasource - columns will not be displayed

Hello,

I have add two columns in the excel sheet. The excel sheet is the datasource for my Lumira reports.

When I push the Button "Reload" Lumira reloaded but it doesn't displayed the new columns.

When I push the Button "New Data" I can choose my excel sheet with the added columns but all my visualizations are empty. And I must create all visualizations new.

I use Lumira Version 1.15.

Have you got a workaround??

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 18, 2014 at 09:40 AM

    Sorry, this is not my experience!

    All i had to do was: Data > Edit > Select +2 columns (see screenshot)  - then Next

    everything stays fine afterwards, i didn't need to recreate my visualisations   😊 

    Regards,

    H

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 19, 2014 at 08:43 AM

    Hello,

    I have try the steps from Henry an Tammy. But it doesn't works.

    1. I had create Lumira Reports with different visualizations :

    2. Now I want to add the column "AE Nav" in my Excel sheet "Test_Vertrieb.xls".

    3. I save the excel sheet with the column "AE Nav" and I want to refresh my Lumira reports:

    But I don't see my new column.

    I try to refresh the connection , but it doesn't works.

    Susan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 18, 2014 at 11:35 AM

    Hello Tammy,

    Ok, I try to create a step by step description.

    In this excel sheet I have added two columns

    Then I choose my created Lumira Report. Then I reloaded the data but the columns are
    not displayed

    When I select “New Data”, the Data were displayed.

    But my visualizations are empty. Now I must create all visualization new.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 18, 2014 at 09:40 AM

    To clarify did you add these columns in Excel or add them in Lumira through calculations?

    Can you use the camera for screen shots to show more information?

    Add comment
    10|10000 characters needed characters exceeded