LIne chart using running SUM USING DATE (WITH DUPLICATE DATE)

[ukantkumar]

Hi All,

I have

1 date column

2 bill no column

Now I want to draw a line chart using Running sum( i have taken running sum using bill number, but when I m going to draw line chart and x-axis is the date ,  the problem is I have 3 bills on the same date. so its getting add 3 bills at one but I need to segregate the value)

note:- I can't include even time with date

[v-piga-msft · Accepted solution]

Hi @ukantkumar ,

By my tests, if you want to get your desired output, I'm afraid that we need use Bill_type as the X _axis.

If you use date column as X_axis, it always  be aggregated in the line chart.

More details, please refer to my attachment.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @ukantkumar ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @ukantkumar ,

By my tests, if you want to get your desired output, I'm afraid that we need use Bill_type as the X _axis.

If you use date column as X_axis, it always  be aggregated in the line chart.

More details, please refer to my attachment.

Best  Regards,

Cherry