Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey all,,
i have this Data :
Network | branch | Data |
x | 1 | 144 |
2 | 155 | |
3 | 155 | |
4 | 166 | |
y | 5 | 16 |
6 | 1666 | |
7 | 144 | |
8 | 16 | |
9 | 166 | |
z | 10 | 177 |
11 | 133 | |
12 | 344 | |
13 | 132 |
need to show 2 pie chart:
1- market share of the branch in each Network (when i select a branch i need to see his market share in the term of other branches within the same network)
2-A second pie chart i need to show the market share of the branch in the term of all branches (when i select a branch i need to see the market share of a branch in term of other branches in all Networks)
What should i write as SET ANALYSIS in A PIE Chart in order to see these to conditions??
Thank you,
See attached qvw.
Hey Thank you For your Reply can you send the qvw again cause i cannot see it..
thank you in advance @ Gysbert Wassenaar
hi mario
have a field like "opened time" -> it's showing like this "'1.22:43:8.000'' s but my requirement need to display into MM:SS format can anyone help me soon
hi anjali i think u can use the interval function
interval#(opened time,'MM:SS')
Hi Mario,
I need help from you
i have dimension as sales office and metric as Revenue, how ever I need to create a gauge chart for that?
how i need to display sales ofc wise revenue amount % in gauge chart?
I hope anybody can help me
Thanks & Regards
you had clarified my doubt earlier thanks for that,
could you please help me for below one,
Could you please help me,I have an straight table expression like this,
if(Metrics='Approval rate' or Metrics='Activation Rate',num(Only({<Year={'=max(Year)'},Scenario={'Actual'},
Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value),'#,##0%'),
Only({<Year={'=max(Year)'},Scenario={'Actual'},Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value)); if(Metrics='Approval rate' or Metrics='Activation Rate',num(Only({<Year={'=max(Year)'},Scenario={'Actual'},
Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value),'#,##0%'),
Only({<Year={'=max(Year)'},Scenario={'Actual'},Year={$(=max(Year))},MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Value));
it is working fine in the table, however I need put this expression in the scripting , can you show me how to do?