Forum Discussion
How can I create a dynamic table such that....
Hi Community!!
I need help regarding creating a table in a dashboard such that the Measures I have created can be seen row-wise and measures like past 7 days, past 14 days and past 21 days would be column-wise. Kindly see a screenshot that I have attached.
(I have made all the measures which are shown below for 7days,14days,21 days)
pmusram , So you want to measure to dimension conversion ?
This means these split for measures. In that case, you need to create a table like one given below and use that
union(
summarize('Table',"Measure","App","Last 7 Days",[APP 7 Day],"Last 14 days",[APP 14 days],"last 21 Days",[APP 21 Days])
summarize('Table',"Measure","App","Last 7 Days",[Leads 7 Day],"Last 14 days",[Leads 14 days],"last 21 Days",[Leads 21 Days])
)
2 Replies
pmusram , So you want to measure to dimension conversion ?
This means these split for measures. In that case, you need to create a table like one given below and use that
union(
summarize('Table',"Measure","App","Last 7 Days",[APP 7 Day],"Last 14 days",[APP 14 days],"last 21 Days",[APP 21 Days])
summarize('Table',"Measure","App","Last 7 Days",[Leads 7 Day],"Last 14 days",[Leads 14 days],"last 21 Days",[Leads 21 Days])
)amitchandak Thanks it worked😊
