topic How to group dimension based on criteria in App Development

How to group dimension based on criteria

Anonymous — Thu, 07 Sep 2017 10:57:44 GMT

Hello gyes,

In a dashboard, I was asked to make a bar chart where to calculate the percentage of clients who visited my our stores at least once a week, monthly, or once every 3 months.

Something like this:

Basically, in terms of data, I have a table with all my clients (ID, Name, Subscribtion_date,...) and a table with all the transaction (TransID, Store, Client_ID, Product, Quantity, Value, Date).

Maybe the title of this question is not correct but I dont know exactly what to ask.

Can you please help me how to build the chart I want?

Thanks in advance,

Miguel Cunha

Re: How to group dimension based on criteria

shraddha_g — Thu, 07 Sep 2017 11:01:27 GMT

Create a Synthetic dimension using Valuelist()

or you can create a inline table in script with these values and use that field as dimension in chart.

For any issues share a sample data so that can help you in better way.

Re: How to group dimension based on criteria

Anonymous — Fri, 08 Sep 2017 11:11:06 GMT

First of all, thanks for your answer.

I searched some discussions about Synthetic Dimensions but I dont understand how to aplly it in my case.

Can you please help me out a little more? What extra information do you need?

Thank you once again!

Re: How to group dimension based on criteria

shraddha_g — Fri, 08 Sep 2017 11:17:54 GMT

In Dimension,

Valuelist('Weekly','Monthly','Every 3 Months')

In Expression,

Pick(Wildmatch(Valuelist('Weekly','Monthly','Every 3 Months'),'Weekly','Monthly','Every 3 Months'),

Expression for Weekly,

Expression for Monthly,

Expression for Every 3 Months

)

In Color by Expression,

Pick(Valuelist('Weekly','Monthly','Every 3 Months'),'Weekly','Monthly','Every 3 Months'),

green(),

yellow(),

red()

)

Re: How to group dimension based on criteria

Anonymous — Fri, 08 Sep 2017 11:25:34 GMT

Thank you very much Shraddha!

You saved my day