Hi
This is a cohort chart the repetition depends on the divide number
Attached the Image of the workflow.
Very urgently required please help
Input table is
Hoping for a best possible earliest response
Oh, sorry, I did not consider divide column. Here is solution
Change Generate Row (4) value 4 with your month on input
Output:
Hi @Swaraj8565
Good work. You were very close. Delete the recordID and Group By [Product] and [Divide] in the Multi row. Change the Summarize to count distinct month names and add a group by on RowCount in the Cross tab
Dan
@cplewis90
@DavidP
@danilang
Hey Ace experts
please help I also need a solution for this
Please
Hope this help you!
Hey
First of all thanks for the solution but it didnot work
It only worked for divide number 2
lets take for number 4 it should be like
INPUT:
output should be
Hi, @Swaraj8565
Do you mean Output:
Input:
Check your values in jan column it should be repeated 4 times where as your value is repeated 2 times please check the output whichnI am sending with your output image
Hi @Swaraj8565, @Rajsekhar8917
It's interesting that both of you have exactly the same problem. Are your assignments due tonight? Since it looks like this is a learning exercise that you should be doing yourselves, I'll give you a couple of big hints.
Hint #1. This workflow is dynamic and will work for any number of rows and values of [Divide]
Hint #2
The heart of the workflow is the Generate rows that determines the final number of rows in the output using OutputRow <= [Divide]+[Count]-1 and then the Formula removes the proper value using the following
If [OutputRow]>[RecordID]-1 AND [OutputRow]<[Divide]+[RecordID] then [Value] else null() endif
I'll leave it to both of you to determine the configuration of the remaining tools
