Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to create a bar chart with month as the dimension, for that i hav values in diffrent fields lik jan month data,feb mnth data,etc.. based on different customers.in my chart i want to display for a particular mnth the 'value' for specific dealers.
Hi
Pls Load the script.Hope it will work.
RawData:LOAD customer,
customer_id,
Zone,
jan_value, Feb_value, Mar_value, April_value,
May_value
FROM[dummy data.xlsx](ooxml, embedded labels, table is Sheet1);
DataTemp:CrossTable(MonthID,Value,3)LOAD *
Resident RawData;
DROP Table RawData;
Data:
LOAD customer, customer_id, Zone,
Left(MonthID,3) As Month,
Value
Resident DataTemp; DROP Table DataTemp;
Regards-Bika
Hi
Pls Load the script.Hope it will work.
RawData:LOAD customer,
customer_id,
Zone,
jan_value, Feb_value, Mar_value, April_value,
May_value
FROM[dummy data.xlsx](ooxml, embedded labels, table is Sheet1);
DataTemp:CrossTable(MonthID,Value,3)LOAD *
Resident RawData;
DROP Table RawData;
Data:
LOAD customer, customer_id, Zone,
Left(MonthID,3) As Month,
Value
Resident DataTemp; DROP Table DataTemp;
Regards-Bika
Hi Reena,
You need to make cross table.
example:
load //your original table
customer ,
customer_id,
zone,
jan,
feb,
march
from abc;
new1:
crosstable(month,value,3)
customer ,
customer_id,
zone,
jan,
feb,
march
resident abc;
drop table abc;
now in new1 table
month field heaning (jan,feb,march) and value field heaving (that are in month field)
in your expression ,now you can take the dimention as month and calculation expression via value field.
Thanks
Narender
Thanks..it works...