Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created a inline table as below:
Island:
Load * Inline [
_Metric
Revenue
Cost
ECL
FTE
RWA
];
In front end i have pulled as buttons using vizlib.
i have a bar chart where i am showing Actuals and Forecast as bar chart.
Now i need to show if i click on Revenue button , in the bar chart i need to show the actauls bar.
so i have written code as
if(Getfieldselections(_Metric) = 'Revenue', sum({<_Metric ={'Revenue'}>}[Actual Value]))
Now i have another buttons MTD YTD and QTD.
How should i put in the above code if MTD is also selcted i need sum(actual value). can i put two parameters in getfieldselections.
Regards
srujana
hi
if you always have one value in the fields you can do
if(_Metric= 'Revenue', sum({<_Metric ={'Revenue'}>}[Actual Value])),
so no problem to add other conditions
No, my requirement is
if i click on MTD button and Revenue button , i need to show the sum(actual value) in a bar chart. and in the same bar chart i also need to show other metrics as well.
like:
if(Getfieldselections(_Metric) = 'Revenue', or Getfieldselections(UnitofTime) = 'MTD' or Getfieldselections(_Metric) = 'ECL', or Getfieldselections(_Metric) = 'RWA', or Getfieldselections(_Metric) = 'FTE', sum({<Source = 'XYZ'>}[Actual Value]))
if i write the above code, if i click on Revenue button then i will the show actaul values of revenue, if i click on RWA i will show RWA actual values in a single bar
and the revenue button should deselect.