Add Weighting to Data Values

[prees959]

Hi ,

I have a dataset that comprises of :

• Office Area (eg, floor1, floor2, floor3, floor4, etc)
• Staff Role (eg, Supervisor, Telephone Operator, Receptionist, Floor Manager etc)
• Shift (eg, Morning, Late, Night, All Day, All Night etc)

I also have a measure of 'Total Absences'

What I would like to be able to do is historically portray which Office Area, Staff Role and Shift had the most absences - so going forward this can be monitored.

I realise I can do this in a pivot and produce a heatmap, but is there way I can score this data during the load process to add a score to this data?

Many thanks for any advice / help.

Phil 

[YoussefBelloum · Accepted solution]

Hi,

Find attached

[qliksus]

You can take the Officeafrea, StaffRole , Shift in the dimension and use something like the rank function to get who fared better

rank( sum('Total Absences') )

[prees959]

Thanks for this it is perfect.

Phil

[prees959]

Hi Youssef,

Is there anyway to achieve this rank within the script load?  I would like to create a resident table and then export this to CSV.

Thanks,

Phil

[YoussefBelloum]

Hi Phil,

in the app attached, the rank was already done in the script, take a look !

you can also add a: STORE TABLE into TABLENAME.csv(txt); to directly export your table