I have an issue with headings that I want to appear on an X axis on the bar graphs in Qliksense.
A small sample of my dataset is below:
|Patient||Pharmacy Cost||Medical Cost||Radiology Cost||Therapy Cost||Ward Cost|
My actual dataset has about 30 columns and 90,000 rows of data and is not very easy to manipulate
Do you know if it is possible to have the Column headings (Pharmacy to Ward) on the x-axis and have it calculating the average cost using the values in the table?
Ideally I would have about 20 bars for each cost category and an average cost for each of those.
It would look a bit like the below: