Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

I have a table where I get the status of the employee's tasks day by day.

As in the below image, I get the values(Confidential, so just entered dummy data).

Then I unpivoted the dates column and made a copy of that and split with space so that I can get the date value.

Here I would like to show the last 3 commented values in a table visualization for each task.

Like as in the above image, if the 5/31/2017 value is not available, then it should get the values of 5/29/2017 plan, 5/29/2017 actual, 5/30/2017 plan values i.e nothing but the last 3 non-blank values.

Any suggestions, please.


1 Answer

0 votes
by (47.2k points)
selected by
Best answer

We can make use of TOP N filtering of the visual  level filter of fields

Browse Categories