Forum Discussion
This Should be Simple - Line Graph
I'm not sure why this is not working, hopinh someone here will be able to assist.
I am attempting to create a graph that will show 'Stock Levels' for certain products by date within a Line Graph.
I have created a "Stock Level" for each SKU and have assigned those values with a scale 0-3 - 'Stock Level Value'.
- Out of Stock = 0
- Low Stock = 1
- Nearing Low Stock = 2
- Stocked = 3
Everyday, as stock levels chance their stock level values ,ay change as well. I want to review this data within a line graph and then hopefully compliment a sales report. However, even though I have the table with accurate data, the line graph is not calculating the values as I would like. See the Below -
In the 'Value' field I have entered a measure that I created which is simply SUM (Stock Value).
I would expect to see a line graph that displays Out of Stock (Value 0) from 12/09/2019 - 12/10/2019, then 3 days of Low Stock indicated by a Value 1.
Why is this not working? 😥
Please help!
Hi AlexAlberga727 ,
If the Stock Value is a calculated column, we can just use it in the value field as following to meet your requirement:
Best regards,
7 Replies
Perhaps try changing your x-axis to be categorical instead of continuous.
This is something I did toggle, and saw no impact. I just attempted again to confirm, and no - unfortunately this doesn't solve the issue.
I'm not sure why I am seeing a value of 6 across all dates, when the table on the left indicates all the dates I have within my table, and the associated stock level.
I also have created a date table and have marked it as the 'Date table'. I would expect to only see results for the data that has been populated which is only from 12/9/2019 - present. Values range from 0-3, for this particular SKU only 2 values - 0 and 1. Yet the graph shows 6... for all dates. Fairly frustrating. I feel like this should be very simple.
I simply need a graph that looks like the following - Plotting values 0-3.
Anonymous Thanks for replying.
This was initially what I thought the issue was. However, the option to not summerize wasn't available. The only options were to SUM, MIN/MAX, AVG - but no option to not summerize. I then created a measure that was simply =SUM(Stock Value). Thinking this would SUM the date's stock value for the selected SKU, and not ask for a type of summerization.
Hi AlexAlberga727 ,
If the Stock Value is a calculated column, we can just use it in the value field as following to meet your requirement:
Best regards,
