Cycle group with two group of expression

[Anonymous]

Hi there,

I'm new to this community and need your help on this

Is it possible to create a cycle group having 4 expressions, with 2 groups, each having 2 expressions? I have one ReportingDate dimension which I would like to cycle through twice: one for count and one for sum expression.

group1 expression:

1.1--> count([field a])

1.2--> count([field b])

group2 expression:

2.1-->  sum ([field c])

2.2-->  sum ([field d])

Thanks in advance for your input.

Thanks and Regards,

Rafi

[Anonymous]

sorry.. just to add on this...I need to create line chart on the above requirement..

[krishnacbe]

Hi,

Create two expression and group them first using the Group button in Expression tab. then create other tow expression and group them .

[krishnacbe]

Please find attached sample document

[Anonymous]

Hi Kirshna,

Thanks for your input. I have modified your input data as below as per my requirement !.

Salesfact:

LOAD * INLINE [

    ID, MonthYear,     Count1, Amount1, Count2, Amount2

    1,  Jan-2016, 10,   1000, 20, 4000

    2,  Feb-2016, 15,   1502, 25, 2500

    3,  Mar-2016, 54,   5000, 35, 1500

    4,  Apr-2016, 10,   2012, 15, 4500

    5,  May-2016, 25,   5214, 55, 5500

];

The issue is, there is two cyclic drop down, i want to have just one drop down  with two Groups: 1 for Count and 2 for Amount.

When I select Count, it should display line chart for both count expression(Count1 and Count2) and when I select Amount in cyclic drop down it should display another line chart with Amount expression(Amoun1 and Amount2)

hope it clarifies my requirement.  please let me know your input.

Thanks and Regards,

Rafi

[krishnacbe · Accepted solution]

Hi Rafi,

PFA the sample dashboard. Instead of Cyclic group I have enabled a field and set conditional show for expressions.

Hope that helps.

[Anonymous]

Hi Krishna,

Thanks for your quick reply and help. It works for me.

Thanks and Regards,

Rafi

[krishnacbe]

Hi Rafi,

If your issue is resolved, please close the thread by updating the correct answer.

[Anonymous]

Hi Krishna,

Thanks. I just did it.

Thanks and Regards,

Rafi