Forum Discussion
Line and Clustered Column Chart - Points above Bars
Hi AhmedT001 ,
You do not need to copy three tables. All you need to do is convert the data to have a date column, a status column (which includes three statuses), and a value column. This is shown in the following figure:
You can convert directly in the original table. The reason I mentioned duplicating the tables is because I didn't want to affect the structure of your original tables, so I duplicated one table.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for the response. I still don't fully understand. Maybe I didn't explain myself properly, here are my tables:
- Transaction Header is the complete Transaction File
- Transaction Detail is the complete Transaction Detail file which holds product identifiers, price, etc.
- TodaysCountOfKHeader is a subset of the main transaction header but only orders in K Status.
- TodaysCountOfKDetail is the above header table, merged with the Transaction Detail, so we have the product information of the items ordered in K Status. Each line in this table has the total cost of the item on order, in a column called LineValue, i.e. if 10 of a £5.00 item is ordered, the LineValue column will say £50.
- TodaysCountOfDHeader is a subset of the main transaction header but only orders in D Status.
- TodaysCountOfDDetail is the above header table, merged with the Transaction Detail, so we have the product information of the items ordered in D Status. Each line in this table has the total cost of the item on order, in a column called LineValue, i.e. if 10 of a £5.00 item is ordered, the LineValue column will say £50.
- TodaysCountOfCHeader is a subset of the main transaction header but only orders in C Status.
- TodaysCountOfCDetail is the above header table, merged with the Transaction Detail, so we have the product information of the items ordered in C Status. Each line in this table has the total cost of the item on order, in a column called LineValue, i.e. if 10 of a £5.00 item is ordered, the LineValue column will say £50.
In my Visualisation:
- I have used the KTATSTS, DTATSTS and CTATSTS from the respective TodaysCountOfxHeader table as the Column Y-Axis, this is so that I can count the number of orders within each respective status. There are no counts or orders within any table, it's all done on the visual.
- I have used the KLineValue, DLineValue and CLineValue from the respective TodaysCountofxDetail table as the Line Y-Axis, this is so that I can get the values showing as points within each respective status.
- TADOCD is taken from the main Transcation Header Table.
In your reply, are you saying to merge the respective separate Detail tables together so that they're all stored on one table and then follow your instructions or have I gone around the whole problem completely wrong in the first instance and that's why I'm confused or over complicated it?