How to get past two days account wise trend

We need past two days account wise trend that which account got increased or decreased.as we tried we got the sum of amount increased or decreased, not get that in which account the amount got increased or decreased.

Please reply ASAP with the filter and conditional Formatting in detail with step wise.

Can you do something like this?

replace the rows with your account. The columns with your date. And the values with your amount.

I’ve filtered for the past two days here.

1 Like

ok @max i will try thank u for your support.

Hi @Max

we want auto graph visual for this requirement is it possible to make ?

You can make this as a calculated field: difference(count({session_id}),[truncDate(‘DD’,{arrival_timestamp}) ASC],-1)

I am truncating my timestamp to a day and using a count of session ids so you can change that to meet your needs.

Then you can use this in your graph.

1 Like

Hi, @ajith_18. Did the response from @Max answer your question? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

1 Like