Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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.

closed

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

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.2k users

Browse Categories

...