Forum Discussion

sw1331's avatar
sw1331
Regular Visitor
2 years ago
Solved

How do I create a trending downward chart?

Hello,   I have a table with monthly data and would like to plot it in a bar chart reducing the last value by 500 starting in 2024 April.    e.g. Feb 24 = 5000 Mar 24 = 4000 Apr 24 = 4000-500 ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Do you have a calendar table for the X axis?

    and so on...

    until when?  Until it crosses the x axis?

     

sw1331's avatar
sw1331
Regular Visitor
2 years ago

Hello Ashish - I am still struggling.  Here is my data.

DateProductUnits
1/2/2024A100
1/10/2024B200
1/11/2024C300
2/22/2024A78
2/21/2024B163
2/26/2024C254
3/22/2024A32
3/21/2024B40
3/26/2024C165

 

I need to reduce the Units value by say 26 units (this will be a variable) starting April 1, 2024.  This needs to go on until May 31st.  I want to know the value on May 31st.  Since the reduction number is a variable, I can create a slider to see different scenarios.

 

Thank you again.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

the data that you have shared and explanation do not support each other.  You mention May in the body of the message but there is no data of that month in the raw data.  Share meaningful data and show the expected result.

  • sw1331's avatar
    sw1331
    Regular Visitor
    2 years ago

    Hello - There is no data for May 31 - remember, May is in the future.  Current data ends on 3/26.  The idea is to see the optimal number to reduce (hence the variable) to see what value is there for end of April and end of May.  Hope this helps.

     

    Thanks.