calculation on X axis - qlik sense

[joeybird]

Hiya

I have already a bar chart that shows how long in weeks a customer waits for a meeting

with Customer on x Axis and Number of weeks on Y axis.

the number of days they wait between meetings is in another column on table.

I wish to calculate number of weeks along x axis of bar chart,

and percentage of people on Y axis

this possible in sense?

please help

[jonathandienst]

Its possible, but hard to give advice without knowledge of your data model. I suggest you provide more information and if possible, your app or a representative sample.

[joeybird]

Hiya

unable to provide example app.

all I can provide is

that current bar chart currently shows on X axis = CustomerID ...ON Y axis shows number of weeks wait

as Avg(DaysSinceMeeting)/ 7

but I wish to show on Y axis, the number of weeks and , percentage of customers on X axis

Please help

[brunobertels · Accepted solution]

Hi Joanna

May this help :

a little sample adding number of weeks wait as dimension

Then adding the number of customer per each number of week wait divided by all the customer to get %

Regards

Bruno

[joeybird]

Hiya

awesome thank you x

used too  (round("DaysSinceMeeting",7) / 7)