Using hidden data items to sort a grid in B1UP Dashboards

4 de febrero de 2022 08:01
4 comentarios

Hello,

Is it possible to use a hidden data item to sort a table in a B1UP dashboard?

For example I want to sort a table by date, but in the table the date is formatted as month-year, while it has to be sorted as year-month. So not like 2021-12, 2021-11, 2022-01 but like 2022-01, 2021-12, 2021-11. The field with the value month-year has been added to the rows and the field with the value year-month has been added to the hidden data items (dimension).

Thanks,

Ron

Comentarios

4 comentarios

Patrick Herr
- 7 de febrero de 2022 13:11
Yes, just right click on the attribute you want to sort according to the hidden data item and choose the date item you want to sort

Hope this helps

Patrick

0
Ron Zwijnenburg
- 7 de febrero de 2022 14:21
Hi Patrick,

Thanks for your response, but unfortunately I can't choose the hidden field (GeplLevDat) to sort.

Kind regards,

Ron

0
Patrick Herr
- 15 de febrero de 2022 20:28
Ok, not sure then. Have you tried moving GepLevDat to Measures?

0
Ron Zwijnenburg
- 21 de febrero de 2022 15:01
Hi Patrick,

That works! I had not seen the option Mode under More in the menu.

Thank you very much for your help!

Kind regards,

Ron Zwijnenburg

0

Iniciar sesión para dejar un comentario.