Max of row count

[Nishant Arya]

Hi I am working on a project which I include to visualize the number of transaction happened in a day, i could do easily with row count but now i want to find on which day max transaction happened ie i need to do something like this max(count([col]) but for visualization, it won't let me do it. can anyone help.

creating a calculated column won't help since i need data to be dynamic it should react on the filter

[Eszter Kovacs]

Hi, what kind of visualisation do you want to use Do you just need to show the one day where the most transactions happened

You can use the show hide funktion to include only the max row count value (top 1).