Forum Discussion
TOP N with Maximum date
Hi,
i want to get Maximum date value based on topN selection , if i select top 2 in parameter there are 3 months data , out od 3 months data i need to show select maximum month , if all months selected in slicer only maximum month nedd to display.if i select Nov and Dec then we ned see only dec data in visual.
Hi! I have something similar here:
I have Max of Hour in a card visual and then from the filter pane you can see I have 11, 17 and 18 selected, however, only 18 shows up in the card because that is the max of the three selected.
If you want to show certain data for the most recent month you could do something like the following, here is some sample data I have entered:
In the card, we are showing total sales for the highest hour out of the three hours that were selected (you would base yours on month number):
So, in this example, 11 has the highest sales amount, but 17 is the highest hour so the value in the card corresponds to the highest hour selected.
1 Reply
Hi! I have something similar here:
I have Max of Hour in a card visual and then from the filter pane you can see I have 11, 17 and 18 selected, however, only 18 shows up in the card because that is the max of the three selected.
If you want to show certain data for the most recent month you could do something like the following, here is some sample data I have entered:
In the card, we are showing total sales for the highest hour out of the three hours that were selected (you would base yours on month number):
So, in this example, 11 has the highest sales amount, but 17 is the highest hour so the value in the card corresponds to the highest hour selected.