-
convert string to whole number using magic etl
Hello, I am trying to convert the datatype of a column to whole number which is having a string datatype using magic ETL and getting attached error. Source for the data load is from CSV file and i am loading data using workbench. Also tried changing the datatype in workbench which also could not complete the run. And when…
-
Vertical bar and line chart
Hi, I am trying to build a card where my yearly data will be shown in vertical bars and yearly avg to be shown in a line like attached. Please advice. Available Sample Data: Product201620172018AvgWipes56856869Soap 27 27Sampoo1414 14Oil525511574Powder42655353 Expected Chart: Best Regards Bikash
-
Week to date conversion
Hi Guys, i have a requirement to display weekly revenue data in a group of quarter and year like attached. How can i make it grouped with taking 2dimension in X-axis. Best Regards Bikash
-
Primary lookup column not found
Hello, I am trying to extract data from cube to DOMO to built my card. I had created few datasets in workbench and tried extracting data. few of then running fine and some of them getting failed with below error message. The only change in all the queries is selection of time period. i have selected Q1, Q2, Q3, Q4. Q3 got…
-
How to filter range of measure value for specific dimension
Hello, I need to ignore some specific range of measure data for some specific dimension value. Please help. Eg : Yellow lines to be ignored. when product name = computer or laptop then amount is not equal to between 100 to -100 Please advice. Thanks Bikash
