topic Re: Sort by in a dashboard prompt - limitations? in Dashboards & Analytics Discussions

Sort by in a dashboard prompt - limitations?

RADSr — Fri, 19 Aug 2022 13:46:46 GMT

I'm adding a day of week prompt to a dashboard, which works fine, but I am not able to add the obvious sort column to put the days of the week in the correct calendar order. Both day of week name and number are coming from the same table on the same physical schema ( the latter of which seems to be the only limitation mentioned in the documentation ).

Friday is supposed to be a great day of the week - what am I missing?

Re: Sort by in a dashboard prompt - limitations?

KailaT — Mon, 29 Aug 2022 16:44:26 GMT

Hi @RADSr my apologies for the delay. I am still working on getting an answer for you. Thanks for your patience.

Re: Sort by in a dashboard prompt - limitations?

RADSr — Mon, 29 Aug 2022 16:55:27 GMT

Ha! No need for apologies, I've been busy and have put off my meeting w/ support on the issue. We'll get there eventually.

Re: Sort by in a dashboard prompt - limitations?

amit_kothari — Mon, 29 Aug 2022 17:53:18 GMT

@RADSr I tried it on 5.2.1 and I am able to drag the column to the Sort field but it is not sorting properly so it is a bug, can you log a ticket?

Re: Sort by in a dashboard prompt - limitations?

RADSr — Mon, 29 Aug 2022 17:32:52 GMT

@amit_kothari We recently updated to 2022.7.2

Re: Sort by in a dashboard prompt - limitations?

amit_kothari — Mon, 29 Aug 2022 17:58:21 GMT

@RADSr Pls log a ticket

Re: Sort by in a dashboard prompt - limitations?

dylanwan — Tue, 30 Aug 2022 06:48:54 GMT

I tried and I was not able to reproduce the issue. The prompt sort is working in 2022.7.

They are sorted correctly.

I also have a recording to show you the details.

https://incorta.zoom.us/rec/share/ggdZxljf8kwPryxZL_EtnrJzhdSGcjkMK6sHS-oCvmaapCvNsONafw2RJPV_0lxS.UKPWjQdVuuIMQVix
Passcode: Nbs!bD1B

Re: Sort by in a dashboard prompt - limitations?

RADSr — Tue, 30 Aug 2022 12:26:51 GMT

@dylanwan - Thanks - if you view the .gif in the original, that's what I tried to do, but am getting the red circle/slash when trying to add the sort column.

I'll post support's answer when I get it.

Re: Sort by in a dashboard prompt - limitations?

RADSr — Tue, 30 Aug 2022 13:52:42 GMT

I'm hopeful I'll be able to work with support today, but in the interim it gets weirder before it gets better.

*One* of the fields can be dropped on the sort field. It's nonsensical and doesn't resolve my issue, but it seems like the dialog will let *something* in that box. The field it will allow in is also on the same table and view ( physical and business schema respectively ). The other field I tried in this .gif was using a formula in the business schema. I've also tried dragging a formula directly into the prompt property w/ no luck.

Stay tuned!

Re: Sort by in a dashboard prompt - limitations?

RADSr — Thu, 01 Sep 2022 21:37:09 GMT

There is an episode of the HBO series Deadwood ( highly recommend - not for the kids though! ) entitled Advances, None Miraculous.

Given the similarities in vocabulary between my trying to figure this out and ... virtually all the vocabulary in Deadwood the reference seems appropriate. The episode title as well.

The good: I can sort my day names! Huzzah! Turns out if I manage the data set and pick the day number from the physical schema it will let me sort just fine.

The bad: 1) That's not documented anywhere I could find and 2) with that functionality I will need to allow any dashboard author who wants to sort day names by day number access to the physical schema.

So - the ticket is still open while support checks to see if this is expected behavior. I'm unstuck for the moment, and we are roaring towards a three-day weekend with the wind at our backs!

Re: Sort by in a dashboard prompt - limitations?

JoeM — Fri, 02 Sep 2022 19:22:46 GMT

I enjoyed that show! Thanks for sharing your findings Randy!

Re: Sort by in a dashboard prompt - limitations?

RADSr — Mon, 24 Oct 2022 16:46:22 GMT

Support tells me it's a product limitation and to use the physical schema column as the "sort by."