Cycle Fields

[#1]

Hi guys,

I'm wondering what exactly a "Cycle" field is. I'm dealing with data that has already been imported and saved by someone else, so I'm not sure where they have been defined, but I'd like to create one myself.

An example is that there is a field called "Time Cycle", which when used in a table has a circular arrow that you can click on which offers a drop down of possible Time cycles:

This way, you can observe the data in the table either by month, week, or year. My question is, how can I create one? Is it possible to create a field in a table that is a drop down list like this that contains other fields? For example, I have three different fields which store the "status" of an order based on three separate evaluations of the order. All of their possible values are the same. Is there a way to create a chart where the user can choose which of these three they want to view, in a similar way as this Time Cycle?

[#2]

In QV there is no need to predefine any heirarchies in the input data.

Associative logic of QV gives you the liberty to access any field as a dimension in any order you like.

One other option could be to explore using inline data functionality.

Regards

Eraaj

[#3 · Accepted solution]

A cycle button allows you to shift through a set of fields defined by the cycle. In your case, you can cycle through the two fields defined.

A cycle button is a form of a group. A group can either be a cycle or drill down.

To create one, go into the properties of a chart and go to the dimensions tab. There is a button on the bottom left called Groups. Click on it to view existing cycle or drill down groups. Or click on new to create a new one.

This should help you in creating the table with the ability to cycle through month, week and year.

Please let me know if you have any questions. I can create a sample file if you can't get it working.

[#4]

thanks for your replies. jcs that was exactly what I was looking for