'Compare to period' not working for custom tables

lock
push_pin
done
Besvart
2

Hi,

I am working on a solution for a customer to put their revenue data into a custom table so they can use it for dashboarding/selections. It works great but there is one functionality that doesn't seem to work. We can't get the 'Compare to period' functionality to work.

Example:

Tile with the following dataset:

Note that we use  a 'This year' criteria on the invoice date (date field) here.

On the layout tab you will see the grouping, compare to period option, but it is disabled:

We really would like to use the 'compare to period' functionality here so that we can compare it to last year's data.

Is this supposed to work? or just not available for dashboard's based on custom object tables?

 

 

18. okt. 2024 | 02:30 p.m.

Alle Svar (2)

Hi David, 

 

Unfortunately this functionality is currently a bit limited. See also earlier report on this matter related to UDEF date fields.

 

https://community.superoffice.com/en/product-releases/bugs-wishes/product-issue/?bid=59286&azure=1

18. okt. 2024 | 04:09 p.m.

I see that that issue is classified as a wish, so this is intended behavior? Then the tooltip text should be changed.

Or even better, the use case of using UDef fields/custom objects in combination with "compare to period" should be supported 😃

18. okt. 2024 | 06:08 p.m.

Legg til svar