How can I get history for fields of type CheckBox

Questions & Answers
1

hi.

Previously, for the Datetime field, History was not displayed for each sprint, so I made an inquiry as follows and resolved the issue.

In a similar way, for the CheckBox field, a report is being created to see how many items were checked for each sprint.
I’m trying to get the history of the field that has become a CheckBox with the same script written above, but only the current value is getting.
If you know how to get the History, I will be able to report by applying the contents of the previous inquiry.

image
image1167×627 137 KB

I would like to know if there is a way to get the change history of the CheckBox field through a script in Advanced settings.
I need help.

2

Hi,

eazyBI cannot track the history of multiple value fields, like checkbox.
Perhaps, a workaround is to redefine the field as single value with the following settings:

separate_table=true
changes=true
multiple_values=false

That will make it possible to access the history records of this field, but there will be a side effect that dimension members will be all the combinations of the selected checkboxes:

image
image1310×656 54.3 KB

Kindly,
Janis, eazyBI support