Missing Title

[MalvikaBhasin]

Hi,

Why is Details and Order section under DATA tab incomplete. I have added titles under Order section even then it just shows Column 1, Column 2 etc. Kindly guide and suggest.

Regards

Malvika

[MalvikaBhasin]

Also, what does this mean now?

[BIswajit_Das · Accepted solution]

Hello @MalvikaBhasin 

Follow these steps

Click on Transfer data then

you'll find your table then click on the table options as shown in the above shot then

Click on the marked option
Then save & apply and you'll get your table column names as defined
Thanks

[MalvikaBhasin]

Thanks a bunch for simplyfying things.

Also, I wanted to ask - why is my Details section incomplete (Under DATA section) while all tabs appear under Transform data. 

Regards

Malvika

[BIswajit_Das]

Hello @MalvikaBhasin 
If you're saying that you get complete table under Transform data
But after loading it when you check table on table view it's Incomplete
Then You should first check if there's any filter applied to any column or not If there's any filter applied then you simply just have to clear the filter from the table and you'll get the complete table; allthough it's not gonna impact your data visuals.
You can check & let me know if there's any issues.
Thanks & Regards..

[MalvikaBhasin]

Hi Blswajit,

There are no filters in detail section under Transform Tab. 

Also, when I change AMOUNT to number instead of existing text format - the source data doesn't change. 

Even now, DETAILS is incomplete: There is some error I am commiting. 

Regards

Malvika

[BIswajit_Das]

Let's do this from the begining

First

remove these steps by clicking the cross as marked except the source
then follow the above steps and click on "use first row as header"
then close & apply and check your table in report page table view and let me know..

[MalvikaBhasin]

Hi,

I tried - see the screenshots. 

After I apply and close:

Regards

Malvika

[BIswajit_Das]

Ok now let's check your data

by clicking the table view

[MalvikaBhasin]

When it seems that everything is fine, a repetitve query occurs:

The issue reoccurs. 

Error View

My learning source : https://www.youtube.com/watch?v=6cV3OwFrOkk&t=1138s

[BIswajit_Das]

I think you're missing the column when you're adding steps.
may i know what is the custom column you're creating here

and
if possibly select each steps and share Shots so that i can identify what you're missing.

Thanks & Regards..

[MalvikaBhasin]

I just added Group By option - Amount*Quantity, and that is how "Amount" bit is giving me issue. 

Regards

Malvika

[MalvikaBhasin]

Hi,

I am trying to add Group By option - Amount*Quantity

Screenshots of file are:

Regards

Malvika

[BIswajit_Das]

Hello @MalvikaBhasin 
Before group can you make duplicates of Amount and Quantity column
Than group them and later perfer your calculations with the duplicate columns
Try this out..